Query Analyzer Options

• Amazon Athena
• Amazon Redshift
• Apache Cassandra
• Apache Derby
• Apache Hive
• DB2 - LUW 7.x
• DB2 - LUW 8.x/9.x/10.x/11.x
• DB2 - iSeries
• DB2 - z/OS
• Generic - JDBC/ODBC
• Google BigQuery
• Greenplum
• Informix
• Interbase
• MS Excel
• MS SQL Database (Azure)
• MS SQL Server (Azure Synapse)
• MS SQL Server
• MS SQL Server 7.0
• MariaDB 10.x
• MongoDB
• MySQL
• Support for PostgreSQL 11
• Oracle 8i
• Oracle 9i/10g/11g/12c/18c/19c
• ParAccel Analytic Platform
• PostgreSQL, Aurora PostgreSQL, Google PostgreSQL
• SAP HANA
• SingleStore (MemSQL)
• Snowflake
• SQLite
• Sybase ASE 11/12/15/16
• Sybase Anywhere
• Sybase IQ
• Teradata Aster Database
• Teradata Database
• Vertica
• VoltDB

• Amazon Athena
  
  Auto Completion: Default Auto Completion setting for Query Analyzer.
  Max Results: Default Maximum results returned in query for Query Analyzer.
  Auto Complete On All Schemas: Default for Auto Complete On All Schemas for Query Analyzer.
  Parameterized Script: Default for Parameterized Script for Query Analyzer.

       

• Amazon Redshift
  
  Auto Completion: Default Auto Completion setting for Query Analyzer.
  Auto Commit: Default Auto Commit setting for Query Analyzer.
  Max Results: Default Maximum results returned in query for Query Analyzer.
  Auto Complete On All Schemas: Default for Auto Complete On All Schemas for Query Analyzer.
  Parameterized Script: Default for Parameterized Script for Query Analyzer.
  

  

• Apache Cassandra
  
  Auto Completion: Default Auto Completion setting for Query Analyzer.
  Auto Commit: Default Auto Commit setting for Query Analyzer.
  Max Results: Default Maximum results returned in query for Query Analyzer.
  Auto Complete On All Schemas: Default for Auto Complete On All Schemas for Query Analyzer.
  Parameterized Script: Default for Parameterized Script for Query Analyzer.
  

  

• Apache Derby
  
  Auto Completion: Default Auto Completion setting for Query Analyzer.
  Auto Commit: Default Auto Commit setting for Query Analyzer.
  Max Results: Default Maximum results returned in query for Query Analyzer.
  Auto Complete On All Schemas: Default for Auto Complete On All Schemas for Query Analyzer.
  Parameterized Script: Default for Parameterized Script for Query Analyzer.
  

  

• Apache Hive
  
  Auto Completion: Default Auto Completion setting for Query Analyzer.
  Max Results: Default Maximum results returned in query for Query Analyzer.
  Auto Complete On All Schemas: Default for Auto Complete On All Schemas for Query Analyzer.
  Parameterized Script: Default for Parameterized Script for Query Analyzer.
  

  

• DB2 - LUW 7.x
  
  Auto Completion: Default Auto Completion setting for Query Analyzer.
  Auto Commit: Default Auto Commit setting for Query Analyzer.
  Max Results: Default Maximum results returned in query for Query Analyzer.
  Auto Complete On All Schemas: Default for Auto Complete On All Schemas for Query Analyzer.
  Parameterized Script: Default for Parameterized Script for Query Analyzer.
  

  

• DB2 - LUW 8.x/9.x/10.x/11.x
  
  Auto Completion: Default Auto Completion setting for Query Analyzer.
  Auto Commit: Default Auto Commit setting for Query Analyzer.
  Max Results: Default Maximum results returned in query for Query Analyzer.
  Auto Complete On All Schemas: Default for Auto Complete On All Schemas for Query Analyzer.
  Parameterized Script: Default for Parameterized Script for Query Analyzer.
  

  

• DB2 - iSeries
  
  Auto Completion: Default Auto Completion setting for Query Analyzer.
  Auto Commit: Default Auto Commit setting for Query Analyzer.
  Max Results: Default Maximum results returned in query for Query Analyzer.
  Auto Complete On All Schemas: Default for Auto Complete On All Schemas for Query Analyzer.
  Parameterized Script: Default for Parameterized Script for Query Analyzer.
  

  

• DB2 - z/OS
  
  Auto Completion: Default Auto Completion setting for Query Analyzer.
  Auto Commit: Default Auto Commit setting for Query Analyzer.
  Max Results: Default Maximum results returned in query for Query Analyzer.
  Auto Complete On All Schemas: Default for Auto Complete On All Schemas for Query Analyzer.
  Parameterized Script: Default for Parameterized Script for Query Analyzer.
  

  

• Generic - JDBC/ODBC
  
  Auto Completion: Default Auto Completion setting for Query Analyzer.
  Auto Commit: Default Auto Commit setting for Query Analyzer.
  Max Results: Default Maximum results returned in query for Query Analyzer.
  Auto Complete On All Schemas: Default for Auto Complete On All Schemas for Query Analyzer.
  Parameterized Script: Default for Parameterized Script for Query Analyzer.
  

  

• Google BigQuery
  
  Auto Completion: Default Auto Completion setting for Query Analyzer.
  Max Results: Default Maximum results returned in query for Query Analyzer.
  Auto Complete On All Datasets: Default for Auto Complete On All Datasets for Query Analyzer.                                                                                                                                                                                                                                                                                                      Parameterized Script: Default for Parameterized Script for Query Analyzer.

       

• Greenplum
  
  Auto Completion: Default Auto Completion setting for Query Analyzer.
  Auto Commit: Default Auto Commit setting for Query Analyzer.
  Max Results: Default Maximum results returned in query for Query Analyzer.
  Auto Complete On All Schemas: Default for Auto Complete On All Schemas for Query Analyzer.
  Parameterized Script: Default for Parameterized Script for Query Analyzer.
  

  

• Informix
  
  Auto Completion: Default Auto Completion setting for Query Analyzer.
  Auto Commit: Default Auto Commit setting for Query Analyzer.
  Max Results: Default Maximum results returned in query for Query Analyzer.
  Auto Complete On All Schemas: Default for Auto Complete On All Schemas for Query Analyzer.
  Parameterized Script: Default for Parameterized Script for Query Analyzer.
  

  

• InterBase
  
  Auto Completion: Default Auto Completion setting for Query Analyzer.
  Auto Commit: Default Auto Commit setting for Query Analyzer.
  Max Results: Default Maximum results returned in query for Query Analyzer.
  Auto Complete On All Schemas: Default for Auto Complete On All Schemas for Query Analyzer.
  Parameterized Script: Default for Parameterized Script for Query Analyzer.
  

  

• MS Excel
  
  Auto Completion: Default Auto Completion setting for Query Analyzer.
  Max Results: Default Maximum results returned in query for Query Analyzer.
  Auto Complete On All Schemas: Default for Auto Complete On All Schemas for Query Analyzer.
  Parameterized Script: Default for Parameterized Script for Query Analyzer.
  

  

• MS SQL Database (Azure)
  
  Auto Completion: Default Auto Completion setting for Query Analyzer.
  Auto Commit: Default Auto Commit setting for Query Analyzer.
  Max Results: Default Maximum results returned in query for Query Analyzer.
  Auto Complete On All Schemas: Default for Auto Complete On All Schemas for Query Analyzer.
  Parameterized Script: Default for Parameterized Script for Query Analyzer.
  

  

• MS SQL Database (Azure Synapse)
  
  Auto Completion: Default Auto Completion setting for Query Analyzer.
  Auto Commit: Default Auto Commit setting for Query Analyzer.
  Max Results: Default Maximum results returned in query for Query Analyzer.
  Auto Complete On All Schemas: Default for Auto Complete On All Schemas for Query Analyzer.
  Parameterized Script: Default for Parameterized Script for Query Analyzer.

       

• MS SQL Server
  
  Auto Completion: Default Auto Completion setting for Query Analyzer.
  Auto Commit: Default Auto Commit setting for Query Analyzer.
  Max Results: Default Maximum results returned in query for Query Analyzer.
  Auto Complete On All Schemas: Default for Auto Complete On All Schemas for Query Analyzer.
  Parameterized Script: Default for Parameterized Script for Query Analyzer.
  Convert all lines ending from LF to CR+LF: Convert all line endings from LF to CR+LF upon script, shell or UI execution.                                                                                                                                                                                                                                 
  Auto Completion Query NoLock: Auto Completion Query NoLock.

       

• MS SQL Server 7.0
  
  Auto Completion: Default Auto Completion setting for Query Analyzer.
  Auto Commit: Default Auto Commit setting for Query Analyzer.
  Max Results: Default Maximum results returned in query for Query Analyzer.
  Auto Complete On All Schemas: Default for Auto Complete On All Schemas for Query Analyzer.
  Parameterized Script: Default for Parameterized Script for Query Analyzer.
  Convert all lines ending from LF to CR+LF: Convert all line endings from LF to CR+LF upon script, shell or UI execution.
  

  

• MariaDB 10.x
  
  Auto Completion: Default Auto Completion setting for Query Analyzer.
  Auto Commit: Default Auto Commit setting for Query Analyzer.
  Max Results: Default Maximum results returned in query for Query Analyzer.
  Auto Complete On All Schemas: Default for Auto Complete On All Schemas for Query Analyzer.
  Parameterized Script: Default for Parameterized Script for Query Analyzer.
  

  

• MongoDB
  
  Auto Completion: Default Auto Completion setting for Query Analyzer.
  Max Results: Default Maximum results returned in query for Query Analyzer.
  Auto Complete On All Schemas: Default for Auto Complete On All Schemas for Query Analyzer.
  Parameterized Script: Default for Parameterized Script for Query Analyzer. This is only applicable for MongoSQL Query Analyzer.
  Default Syntex: Default syntax for Query Analyzer. MongoSQL means that Query Analyzer accepts MongoSQL input. MongoJS means that Query Analyzer accepts MongoDB JavaScript input.
  MongoJS Grid Results Nesting: Default option on flattening grid result sets when executing MongoJS commands. FLATTEN removes nesting levels of subdocuments. FLATTEN_ARRAY flattens subdocuments and unfurls array values.
  MongoJS Tree View: Default setting to indicate whether to display the Tree view for MongoJS result sets.
  MongoJS Pretty-Print JSON: Default setting to indicate whether to pretty-print MongoJS result sets in Text view.
  

  

• MySQL, Aurora MySQL, Google MySQL
  
  Auto Completion: Default Auto Completion setting for Query Analyzer.
  Auto Commit: Default Auto Commit setting for Query Analyzer.
  Max Results: Default Maximum results returned in query for Query Analyzer.
  Auto Complete On All Schemas: Default for Auto Complete On All Schemas for Query Analyzer.
  Parameterized Script: Default for Parameterized Script for Query Analyzer.
  

  

• Netezza
  
  Auto Completion: Default Auto Completion setting for Query Analyzer.
  Auto Commit: Default Auto Commit setting for Query Analyzer.
  Max Results: Default Maximum results returned in query for Query Analyzer.
  Auto Complete On All Schemas: Default for Auto Complete On All Schemas for Query Analyzer.
  Parameterized Script: Default for Parameterized Script for Query Analyzer.
  

  

• Oracle 8i
  
  Auto Completion: Default Auto Completion setting for Query Analyzer.
  Auto Commit: Default Auto Commit setting for Query Analyzer.
  Max Results: Default Maximum results returned in query for Query Analyzer.
  Auto Complete On All Schemas: Default for Auto Complete On All Schemas for Query Analyzer.
  Parameterized Script: Default for Parameterized Script for Query Analyzer.
  

  

• Oracle 9i/10g/11g/12c/18c/19c
  
  Auto Completion: Default Auto Completion setting for Query Analyzer.
  Auto Commit: Default Auto Commit setting for Query Analyzer.
  Max Results: Default Maximum results returned in query for Query Analyzer.
  Auto Complete On All Schemas: Default for Auto Complete On All Schemas for Query Analyzer.
  Parameterized Script: Default for Parameterized Script for Query Analyzer.
  Parameterized Script - Quoted String Backslash Enabled: Default for the use of a backslash with a quoted string.
  

  

• ParAccel Analytic Platform
  
  Auto Completion: Default Auto Completion setting for Query Analyzer.
  Auto Commit: Default Auto Commit setting for Query Analyzer.
  Max Results: Default Maximum results returned in query for Query Analyzer.
  Auto Complete On All Schemas: Default for Auto Complete On All Schemas for Query Analyzer.
  Parameterized Script: Default for Parameterized Script for Query Analyzer.
  

  

• PostgreSQL, Aurora PostgreSQL, Google PostgreSQL
  
  Auto Completion: Default Auto Completion setting for Query Analyzer.
  Auto Commit: Default Auto Commit setting for Query Analyzer.
  Max Results: Default Maximum results returned in query for Query Analyzer.
  Auto Complete On All Schemas: Default for Auto Complete On All Schemas for Query Analyzer.
  Parameterized Script: Default for Parameterized Script for Query Analyzer.
  

  

• SAP HANA
  
  Auto Completion: Default Auto Completion setting for Query Analyzer.
  Auto Commit: Default Auto Commit setting for Query Analyzer.
  Max Results: Default Maximum results returned in query for Query Analyzer.
  Auto Complete On All Schemas: Default for Auto Complete On All Schemas for Query Analyzer.                                                                                                                                                                                                                                                                                                      Parameterized Script: Default for Parameterized Script for Query Analyzer.

       

• SingleStore (MemSQL)
  
  Auto Completion: Default Auto Completion setting for Query Analyzer.
  Auto Commit: Default Auto Commit setting for Query Analyzer.
  Max Results: Default Maximum results returned in query for Query Analyzer.
  Auto Complete On All Schemas: Default for Auto Complete On All Schemas for Query Analyzer.
  Parameterized Script: Default for Parameterized Script for Query Analyzer.

        

• Snowflake
  
  Auto Completion: Default Auto Completion setting for Query Analyzer.
  Auto Commit: Default Auto Commit setting for Query Analyzer.
  Max Results: Default Maximum results returned in query for Query Analyzer.
  Auto Complete On All Schemas: Default for Auto Complete On All Schemas for Query Analyzer.
  Parameterized Script: Default for Parameterized Script for Query Analyzer.
  

  

• SQLite
  
  Auto Completion: Default Auto Completion setting for Query Analyzer.
  Auto Commit: Default Auto Commit setting for Query Analyzer.
  Max Results: Default Maximum results returned in query for Query Analyzer.
  Auto Complete On All Schemas: Default for Auto Complete On All Schemas for Query Analyzer.
  Parameterized Script: Default for Parameterized Script for Query Analyzer.
  

  

• Sybase ASE 11/12/15/16
  
  Auto Completion: Default Auto Completion setting for Query Analyzer.
  Auto Commit: Default Auto Commit setting for Query Analyzer.
  Max Results: Default Maximum results returned in query for Query Analyzer.
  Auto Complete On All Schemas: Default for Auto Complete On All Schemas for Query Analyzer.
  Parameterized Script: Default for Parameterized Script for Query Analyzer.
  

  

• Sybase Anywhere
  
  Auto Completion: Default Auto Completion setting for Query Analyzer.
  Auto Commit: Default Auto Commit setting for Query Analyzer.
  Max Results: Default Maximum results returned in query for Query Analyzer.
  Auto Complete On All Schemas: Default for Auto Complete On All Schemas for Query Analyzer.
  Parameterized Script: Default for Parameterized Script for Query Analyzer.
  

  

• Sybase IQ
  
  Auto Completion: Default Auto Completion setting for Query Analyzer.
  Auto Commit: Default Auto Commit setting for Query Analyzer.
  Max Results: Default Maximum results returned in query for Query Analyzer.
  Auto Complete On All Schemas: Default for Auto Complete On All Schemas for Query Analyzer.
  Parameterized Script: Default for Parameterized Script for Query Analyzer.
  

  

• Teradata Aster Database
  
  Auto Completion: Default Auto Completion setting for Query Analyzer.
  Auto Commit: Default Auto Commit setting for Query Analyzer.
  Max Results: Default Maximum results returned in query for Query Analyzer.
  Auto Complete On All Schemas: Default for Auto Complete On All Schemas for Query Analyzer.
  Parameterized Script: Default for Parameterized Script for Query Analyzer.
  

  

• Teradata Database
  
  Auto Completion: Default Auto Completion setting for Query Analyzer.
  Auto Commit: Default Auto Commit setting for Query Analyzer.
  Max Results: Default Maximum results returned in query for Query Analyzer.
  Auto Complete On All Schemas: Default for Auto Complete On All Schemas for Query Analyzer.
  Parameterized Script: Default for Parameterized Script for Query Analyzer.
  

  

• Vertica
  
  Auto Completion: Default Auto Completion setting for Query Analyzer.
  Auto Commit: Default Auto Commit setting for Query Analyzer.
  Max Results: Default Maximum results returned in query for Query Analyzer.
  Auto Complete On All Schemas: Default for Auto Complete On All Schemas for Query Analyzer.
  Parameterized Script: Default for Parameterized Script for Query Analyzer.
  

  

   
• VoltDB
  
  Auto Completion: Default Auto Completion setting for Query Analyzer.
  Max Results: Default Maximum results returned in query for Query Analyzer.
  Auto Complete On All Schemas: Default for Auto Complete On All Schemas for Query Analyzer.
  Parameterized Script: Default for Parameterized Script for Query Analyzer.