Page History

Contents

...

• Anchor
  Amazon Athena Amazon Athena

  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.

        Image Modified

• Anchor
  Amazon Redshift Amazon Redshift

  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.
  

  Image Modified

• Anchor
  Apache Cassandra Apache Cassandra

  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.
  

  Image Modified

• Anchor
  Apache Derby Apache Derby

  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.
  

  Image Modified

• Anchor
  Apache Hive Apache Hive

  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.
  

  Image Modified

• Anchor
  DB2 - LUW 7 DB2 - LUW 7

  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.
  

  Image Modified

• Anchor
  DB2 - LUW 8 DB2 - LUW 8

  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.
  

  Image Modified

• Anchor
  DB2 - iSeries DB2 - iSeries

  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.
  

  Image Modified

• Anchor
  DB2 - zOS DB2 - zOS

  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.
  

  Image Modified

• Anchor
  Generic - JDBC Generic - JDBC

  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.
  

  Image Modified

• Anchor
  Google BigQuery Google BigQuery

  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.

        Image Modified

• Anchor
  Greenplum Greenplum

  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.
  

  Image Modified

• Anchor
  Informix Informix

  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.
  

  Image Modified

• Anchor
  InterBase InterBase

  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.
  

  Image Modified

• Anchor
  MS Excel MS Excel

  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.
  

  Image Modified

• Anchor
  MS SQL Azure MS SQL Azure

  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.
  

  Image Modified

• Anchor
  MS SQL Azure Synapse MS SQL Azure Synapse

  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.

        Image Modified

• Anchor
  MS SQL Server MS SQL Server

  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.

        Image Modified

• Anchor
  MS SQL Server 7 MS SQL Server 7

  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.
  

  Image Modified

• Anchor
  MariaDB 10 MariaDB 10

  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.
  

  Image Modified

• Anchor
  MongoDB MongoDB

  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.
  

  Image Modified

• Anchor
  MySQL MySQL

  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.
  

  Image Modified

• Anchor
  Netezza Netezza

  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.
  

  Image Modified

• Anchor
  Oracle 8 Oracle 8

  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.
  

  Image Modified

• Anchor
  Oracle 9+ Oracle 9+

  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.
  

  Image Modified

• Anchor
  ParAccel ParAccel

  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.
  

  Image Modified

• Anchor
  PostgreSQL PostgreSQL

  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.
  

  Image Modified

• Anchor
  SAP HANA SAP HANA

  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.

        Image Modified

• Anchor
  SingleStore SingleStore

  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.

         Image Modified

• Anchor
  Snowflake Snowflake

  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.
  

  Image Modified

• Anchor
  SQLite SQLite

  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.
  

  Image Modified

• Anchor
  Sybase ASE Sybase ASE

  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.
  

  Image Modified

• Anchor
  Sybase Anywhere Sybase Anywhere

  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.
  

  Image Modified

• Anchor
  Sybase IQ Sybase IQ

  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.
  

  Image Modified

• Anchor
  Teradata Aster Teradata Aster

  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.
  

  Image Modified

• Anchor
  Teradata Database Teradata Database

  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.
  

  Image Modified

• Anchor
  Vertica Vertica

  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.
  

  Image Modified

   

• Anchor
  VoltDB VoltDB

  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.
  

  Image Modified