Skip to main content
Previous section   Next section

[SQL]

This topic describes the parameters found in the [SQL] section of the CPF file.

  • AllowRowIDUpdate – AllowRowIDUpdate Enable/disable SQL row ID update.
  • ANSIPrecedence – Enable/disable ANSI SQL operator precedence system-wide.
  • BiasQueriesAsOutlier – Enable/disable query optimization biased toward outliers.
  • Comment – Comment Enable/disable retaining embedded SQL statements as comments in source code.
  • DBMSSecurity – DBMSSecurityEnable/disable SQL security.
  • DDLDefineBitmapExtent – Determines whether a table created by a DDL statement defines a bitmap extent index.
  • DDLFinal – Determines whether a class created by a DDL statement is final.
  • DDLNo201 – DDLNo201Suppress/return error upon CREATE of a previously existing table.
  • DDLNo30 – DDLNo30 Suppress/return error upon DROP of a nonexistent table.
  • DDLNo307 – DDLNo307Suppress/return error upon CREATE of a primary key constraint when one exists.
  • DDLNo311 – DDLNo311Suppress/return error upon ADD a foreign key, when a key of that name already exists.
  • DDLNo315 – DDLNo315Suppress/return error upon DROP of a nonexistent constraint.
  • DDLNo324 – DDLNo324Suppress/return error upon CREATE of a previously existing index.
  • DDLNo333 – DDLNo333 Suppress/return error upon DROP of a nonexistent index.
  • DDLSQLOnlyCompile – Enable/disable an SQL-only compile.
  • DDLUseSequence – Determines which function a table created by a DDL statement uses for ID assignment.
  • DefaultSchema – DefaultSchemaDefault SQL schema name.
  • DelimitedIds – DelimitedIds Enable/disable interpreting double-quoted strings as delimited identifiers.
  • DropDelete – DropDeleteDROP TABLE behavior.
  • ECPSync – ECPSyncEnsures that the server and client cache are in sync.
  • ExtrinsicFunctions – ExtrinsicFunctions Enable/disable extrinsic functions in SQL statements.
  • FastDistinct – FastDistinctEnable/disable SQL DISTINCT optimization.
  • IdKey – IdKeyPrimary key constraint behavior.
  • IdTrxFrom – IdTrxFrom The “From” list of characters for Identifier Translation.
  • IdTrxTo – IdTrxTo The “To” list of characters for Identifier Translation.
  • JavaClassPath – JavaClassPath List of additional .jar files to load when the JDBC service is started.
  • JavaHome – JavaHome Specifies the Java version to use with the JDBC Gateway.
  • JDBCGatewayAddress – JDBCGatewayAddressAddress of JDBC Gateway.
  • JDBCGatewayJVMArgs – JDBCGatewayJVMArgsOptional JVM arguments to use when starting the JDBC Gateway.
  • JDBCGatewayLog – JDBCGatewayLog Name of the JDBC Gateway log file.
  • JDBCGatewayPort – JDBCGatewayPortPort number for the JDBC Gateway.
  • JDBCGatewayUsePassphrase – Enable/disable the passphrase requirement for JDBC connections.
  • LockThreshold – LockThreshold SQL lock threshold.
  • LockTimeout – LockTimeoutSQL lock timeout.
  • ODBCVarcharMaxlen – ODBCVarcharMaxlen Define the MaxLen for ODBC fields of type VarChar.
  • QueryProcedures – QueryProceduresDefines whether all class queries project as SQL Stored Procedures.
  • ReferentialChecks – ReferentialChecksEnable/disable validating the foreign key constraint.
  • SaveMAC – SaveMAC Enable/disable saving the source code for cached query routines.
  • TCPKeepAlive – TCP Keep-Alive Interval(Windows and Linux) Number of seconds between keep-alive messages.
  • TimePrecision – TimePrecision Default time precision for SQL scalar time functions.
  • TODATEDefaultFormat – TODATEDefaultFormat Default date format for the SQL TO_DATE() function.