Who should use this guide?
You'll need a basic understanding of the SQL92 standard and relational databases.
Setup SQL Client
Connect to Oracle, SQL-Server, or databases that use the MySQL or Postgres wire protocol.
Connect to Cirro using ODBC or JDBC drivers and perform Federated queries across your databases.
You can also use Cirro's built-in Federated Query Builder.
Cirro Query Execution and Federated Systems
When executing queries on federated systems, the behaviors of the underlying database are dominant regarding how results are calculated.
Identifiers and Reserved Words
These words are reserved in either Cirro or the SQL-92 standard and should not be used as identifier names.
SQL Syntax Notation
The Cirro SQL Guide uses a standard syntax notation.
Change Query Delimiter
Use DELIMITER to change the delimiter from the default semicolon ';' to any non-reserved character. It must be followed by a valid SQL query.