Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Contents

Table of Contents



  • 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 Athena.pngImage Added

  • 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.
    AmazonRedshift.pngImage Added
  • 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.
    ApacheCassandra.pngImage Added
  • 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.
    ApacheDerby.pngImage Added
  • 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.
    ApacheHive.pngImage Added
  • 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.
    DB2LUW7.x.pngImage Added
  • 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.
    DB2LUW8.x.pngImage Added
  • 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.
    DB2iSeries.pngImage Added
  • 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.
    DB2zOS.pngImage Added
  • 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.
    GenericJDBCODBC.pngImage Added
  • 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.

 GoogleBigQuery.pngImage Added

  • 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.
    Greenplum.pngImage Added
  • 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.
    Informix.pngImage Added
  • 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.
    InterBase.pngImage Added
  • 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.
    MSexcel.pngImage Added
  • 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.
    MSSQLAzure.pngImage Added
  • 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 Database Azure Synapse.pngImage Added

  • 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 SQLserver.pngImage Added

  • 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.
    MSSQLServer7.0.pngImage Added
  • 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.
    MariaDB10.x.pngImage Added
  • 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.
    MongoDB.pngImage Added
  • 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.
    MySQL.pngImage Added
  • 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.
    Netezza.pngImage Added
  • 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.
    Oracle8i.pngImage Added
  • 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.
    Parameters3.pngImage Added
  • 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.
    ParAccelAnalyticPlatform.pngImage Added
  • 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.
    PostgreSQL.pngImage Added
  • 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. SAPHANA.pngImage Added
  • 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.

SingleStore.pngImage Added

  • 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.
    Snowflake.pngImage Added
  • 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.
    SQLite.pngImage Added
  • 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.
    SybaseASE.pngImage Added
  • 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.
    SybaseAnywhere.pngImage Added
  • 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.
    SybaseIQ.pngImage Added
  • 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.
    TeradataAster.pngImage Added
  • 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.
    Teradata.pngImage Added
  • 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.
    Vertica.pngImage Added