!!com.compositesw.common.ds.config.schema.ConfigurationContainer adapter_name: JDBCODBC schema_version: 1 property_categories: general: value_required_for_adapter: true value_required_for_datasource: false value_overridable_by_datasource: false display_in_ui: false members: name: display_name: Data source name value_type: STRING value_required_for_datasource: t display_in_ui: t type: display_name: Adapter internal name value_type: STRING value: JDBCODBC driverName: display_name: Adapter name value_type: STRING value: JDBC-ODBC Bridge inherit: display_name: Inherit from base template file value_type: STRING value: none isEnabled: display_name: Data source is enabled value_type: BOOLEAN value: true value_required_for_datasource: t display_in_ui: t connection_and_authentication: value_required_for_adapter: false value_required_for_datasource: false value_overridable_by_datasource: true display_in_ui: true members: driver: display_name: Driver value_type: STRING dsn: display_name: DSN value_type: STRING user: display_name: User value_type: STRING password: display_name: Password value_type: PASSWORD_STRING value_required_for_datasource: f value_overridable_by_datasource: t display_in_ui: t persistPassword: display_name: Save password value_type: BOOLEAN value: true value_required_for_adapter: t value_required_for_datasource: f value_overridable_by_datasource: t display_in_ui: t isPassThrough: display_name: Pass-through login value_type: STRING allowable_values: - Enabled - Disabled value: Disabled value_required_for_adapter: t value_required_for_datasource: f value_overridable_by_datasource: t display_in_ui: t alternateSecurityProperties: display_name: Alternate Security Properties value_type: STRING value: oauthaccesstoken dsdriver.classname: display_name: JDBC driver class name value_type: STRING value: com.cdata.cis.jdbcodbc value_required_for_adapter: t value_required_for_datasource: f value_overridable_by_datasource: f display_in_ui: f urlDatabaseName: display_name: Database or service name value_type: STRING value: JDBCODBC value_required_for_datasource: f value_overridable_by_datasource: f display_in_ui: f urlPatternStr: display_name: Connection String value_type: STRING value: JDBCODBC value_required_for_adapter: t value_required_for_datasource: f value_overridable_by_datasource: f display_in_ui: f authentication: display_name: Authentication type value_type: STRING allowable_values: - BASIC - KERBEROS - NTLM - NEGOTIATE value: BASIC value_required_for_adapter: t value_required_for_datasource: f value_overridable_by_datasource: f display_in_ui: f spn: display_name: Service principal name for Kerberos authentication value_type: STRING value_required_for_datasource: f display_in_ui: f conn_pooling_and_management: value_required_for_adapter: true value_required_for_datasource: false value_overridable_by_datasource: true display_in_ui: true members: txnIsolationLevel: display_name: Transaction isolation value_type: STRING allowable_values: - Read Committed - Read Uncommitted - Repeatable Read - Serializable - None value: Read Committed value_required_for_datasource: t connProperties: display_name: Connection attributes (name1=value1,name2=value2) value_type: STRING value_required_for_adapter: f value_required_for_datasource: f value_overridable_by_datasource: f display_in_ui: f connPoolMinSize: display_name: Connection pool minimum size value_type: INTEGER value: 0 connPoolMaxSize: display_name: Connection pool maximum size value_type: INTEGER value: 100 connPoolTimeout: display_name: Connection pool idle timeout (sec) value_type: INTEGER value: 30 connStaleTimeout: display_name: Maximum connection lifetime (min) value_type: INTEGER value: 60 connCheckOutProcedure: display_name: Connection checkout procedure value_type: STRING value_required_for_adapter: f ds.conn_checkout_timeout: display_name: Connection checkout timeout value_type: INTEGER value: 45 connValidateQuery: display_name: Connection validation query value_type: STRING value_required_for_adapter: f jdbcds.no_support_query_timeout: display_name: Data source driver doesn't support query timeout value_type: BOOLEAN value: true execTimeout: display_name: Execution timeout (sec) value_type: INTEGER value: 0 value_required_for_adapter: f commitOnFetchDone: display_name: Execute SELECTs in separate transactions from INSERTs/UPDATEs value_type: BOOLEAN value: true introspection: value_required_for_adapter: false value_required_for_datasource: false value_overridable_by_datasource: true display_in_ui: false members: introspect.toolkit.ignore_catalogs: display_name: Ignore calalogs value_type: BOOLEAN value: true value_required_for_adapter: t introspect.config_overrides_implementation: display_name: Data type details in type mappings override resultset implementation value_type: BOOLEAN value: false value_required_for_adapter: t introspect.relational.include_catalog: display_name: Data source supports catalogs value_type: BOOLEAN value: true value_required_for_adapter: t introspect.relational.include_schema: display_name: Data source supports schemas value_type: BOOLEAN value: true value_required_for_adapter: t introspect.relational.include_table: display_name: Data source supports tables value_type: BOOLEAN value: true value_required_for_adapter: t introspect.relational.include_table.primary_keys: display_name: Data source supports primary keys in tables value_type: BOOLEAN value: false value_required_for_adapter: t introspect.relational.include_table.foreign_keys: display_name: Data source supports foreign keys in tables value_type: BOOLEAN value: true value_required_for_adapter: t introspect.relational.include_table.foreign_keys.exported: display_name: Data source supports exported foreign keys in tables value_type: BOOLEAN value: false value_required_for_adapter: t introspect.relational.include_table.foreign_keys.imported: display_name: Data source supports imported foreign keys in tables value_type: BOOLEAN value: false value_required_for_adapter: t introspect.relational.include_table.indexes: display_name: Data source supports indexes in tables value_type: BOOLEAN value: true value_required_for_adapter: t introspect.relational.include_procedure: display_name: Data source supports procedures value_type: BOOLEAN value: false value_required_for_adapter: t introspect.relational.table_types: display_name: Comma separated list of table types value_type: STRING value: TABLE,VIEW introspect.relational.use_catalogs_for_schemas: display_name: Tables/procedures are directly under catalogs value_type: BOOLEAN value: false introspect.override_parallelism_degree: display_name: Override for parallelism degree of introspection task (0 = no value) value_type: INTEGER value: 0 introspect.max_batch_size: display_name: Max batch size for introspecting resources (0 = no value) value_type: INTEGER value: 0 introspect.catalog.table_cat: display_name: Column name for catalog name in java.sql.DatabaseMetaData.getCatalogs() value_type: STRING value: TABLE_CAT introspect.schema.table_cat: display_name: Column name for catalog name in java.sql.DatabaseMetaData.getSchemas() value_type: STRING value: TABLE_CATALOG introspect.schema.table_schem: display_name: Column name for schema name in java.sql.DatabaseMetaData.getSchemas() value_type: STRING value: TABLE_SCHEM introspect.table.table_cat: display_name: Column name for catalog name in java.sql.DatabaseMetaData.getTables() value_type: STRING value: TABLE_CAT introspect.table.table_schem: display_name: Column name for schema name in java.sql.DatabaseMetaData.getTables() value_type: STRING value: TABLE_SCHEM introspect.table.table_name: display_name: Column name for table name in java.sql.DatabaseMetaData.getTables() value_type: STRING value: TABLE_NAME introspect.table.table_type: display_name: Column name for table type in java.sql.DatabaseMetaData.getTables() value_type: STRING value: TABLE_TYPE introspect.column.table_cat: display_name: Column name for catalog name in java.sql.DatabaseMetaData.getColumns() value_type: STRING value: TABLE_CAT introspect.column.table_schem: display_name: Column name for schema name in java.sql.DatabaseMetaData.getColumns() value_type: STRING value: TABLE_SCHEM introspect.column.table_name: display_name: Column name for table name in java.sql.DatabaseMetaData.getColumns() value_type: STRING value: TABLE_NAME introspect.column.column_name: display_name: Column name for column name in java.sql.DatabaseMetaData.getColumns() value_type: STRING value: COLUMN_NAME introspect.column.data_type: display_name: Column name for data type in java.sql.DatabaseMetaData.getColumns() value_type: STRING value: DATA_TYPE introspect.column.type_name: display_name: Column name for type name in java.sql.DatabaseMetaData.getColumns() value_type: STRING value: TYPE_NAME introspect.column.column_size: display_name: Column name for column size in java.sql.DatabaseMetaData.getColumns() value_type: STRING value: COLUMN_SIZE introspect.column.decimal_digits: display_name: Column name for decimal digits in java.sql.DatabaseMetaData.getColumns() value_type: STRING value: DECIMAL_DIGITS introspect.column.nullable: display_name: Column name for nullable in java.sql.DatabaseMetaData.getColumns() value_type: STRING value: NULLABLE introspect.column.column_def: display_name: Column name for column default in java.sql.DatabaseMetaData.getColumns() value_type: STRING value: COLUMN_DEF introspect.column.ordinal_position: display_name: Column name for ordinal position in java.sql.DatabaseMetaData.getColumns() value_type: STRING value: ORDINAL_POSITION introspect.column.is_nullable: display_name: Column name for is_nullable in java.sql.DatabaseMetaData.getColumns() value_type: STRING value: IS_NULLABLE introspect.index.table_cat: display_name: Column name for catalog name in java.sql.DatabaseMetaData.getIndexInfo() value_type: STRING value: TABLE_CAT introspect.index.table_schem: display_name: Column name for schema name in java.sql.DatabaseMetaData.getIndexInfo() value_type: STRING value: TABLE_SCHEM introspect.index.table_name: display_name: Column name for table name in java.sql.DatabaseMetaData.getIndexInfo() value_type: STRING value: TABLE_NAME introspect.index.non_unique: display_name: Column name for non-unique in java.sql.DatabaseMetaData.getIndexInfo() value_type: STRING value: NON_UNIQUE introspect.index.index_name: display_name: Column name for index name in java.sql.DatabaseMetaData.getIndexInfo() value_type: STRING value: INDEX_NAME introspect.index.type: display_name: Column name for type in java.sql.DatabaseMetaData.getIndexInfo() value_type: STRING value: TYPE introspect.index.ordinal_position: display_name: Column name for ordinal position in java.sql.DatabaseMetaData.getIndexInfo() value_type: STRING value: ORDINAL_POSITION introspect.index.column_name: display_name: Column name for column name in java.sql.DatabaseMetaData.getIndexInfo() value_type: STRING value: COLUMN_NAME introspect.index.asc_or_desc: display_name: Column name for asc_or_desc in java.sql.DatabaseMetaData.getIndexInfo() value_type: STRING value: ASC_OR_DESC introspect.index.cardinality: display_name: Column name for cardinality in java.sql.DatabaseMetaData.getIndexInfo() value_type: STRING value: CARDINALITY introspect.pkey.table_cat: display_name: Column name for catalog name in java.sql.DatabaseMetaData.getPrimaryKeys() value_type: STRING value: TABLE_CAT introspect.pkey.table_schem: display_name: Column name for schema name in java.sql.DatabaseMetaData.getPrimaryKeys() value_type: STRING value: TABLE_SCHEM introspect.pkey.table_name: display_name: Column name for table name in java.sql.DatabaseMetaData.getPrimaryKeys() value_type: STRING value: TABLE_NAME introspect.pkey.column_name: display_name: Column name for column name in java.sql.DatabaseMetaData.getPrimaryKeys() value_type: STRING value: COLUMN_NAME introspect.pkey.key_seq: display_name: Column name for key sequence in java.sql.DatabaseMetaData.getPrimaryKeys() value_type: STRING value: KEY_SEQ introspect.pkey.pk_name: display_name: Column name for primary key name in java.sql.DatabaseMetaData.getPrimaryKeys() value_type: STRING value: PK_NAME introspect.fkey.fk_name: display_name: Column name for fk name in java.sql.DatabaseMetaData.getImportedKeys() value_type: STRING value: FK_NAME introspect.fkey.pk_name: display_name: Column name for pk name in java.sql.DatabaseMetaData.getImportedKeys() value_type: STRING value: PK_NAME introspect.fkey.pktable_cat: display_name: Column name for catalog name for pk table in java.sql.DatabaseMetaData.getImportedKeys() value_type: STRING value: PKTABLE_CAT introspect.fkey.pktable_schem: display_name: Column name for schema name for pk table in java.sql.DatabaseMetaData.getImportedKeys() value_type: STRING value: PKTABLE_SCHEM introspect.fkey.pktable_name: display_name: Column name for pk table name in java.sql.DatabaseMetaData.getImportedKeys() value_type: STRING value: PKTABLE_NAME introspect.fkey.pkcolumn_name: display_name: Column name for pk column name in java.sql.DatabaseMetaData.getImportedKeys() value_type: STRING value: PKCOLUMN_NAME introspect.fkey.fktable_cat: display_name: Column name for catalog name for fk table in java.sql.DatabaseMetaData.getImportedKeys() value_type: STRING value: FKTABLE_CAT introspect.fkey.fktable_schem: display_name: Column name for schema name for fk table in java.sql.DatabaseMetaData.getImportedKeys() value_type: STRING value: FKTABLE_SCHEM introspect.fkey.fktable_name: display_name: Column name for fk table name in java.sql.DatabaseMetaData.getImportedKeys() value_type: STRING value: FKTABLE_NAME introspect.fkey.fkcolumn_name: display_name: Column name for fk column name in java.sql.DatabaseMetaData.getImportedKeys() value_type: STRING value: FKCOLUMN_NAME introspect.fkey.key_seq: display_name: Column name for key sequence in java.sql.DatabaseMetaData.getImportedKeys() value_type: STRING value: KEY_SEQ introspect.fkey.deferrability: display_name: Column name for deferrability in java.sql.DatabaseMetaData.getImportedKeys() value_type: STRING value: DEFERRABILITY introspect.fkey.delete_rule: display_name: Column name for delete rule in java.sql.DatabaseMetaData.getImportedKeys() value_type: STRING value: DELETE_RULE introspect.fkey.update_rule: display_name: Column name for update rule in java.sql.DatabaseMetaData.getImportedKeys() value_type: STRING value: UPDATE_RULE introspect.procedure.procedure_cat: display_name: Column name for catalog name in java.sql.DatabaseMetaData.getProcedures() value_type: STRING value: PROCEDURE_CAT introspect.procedure.procedure_schem: display_name: Column name for schema name in java.sql.DatabaseMetaData.getProcedures() value_type: STRING value: PROCEDURE_SCHEM introspect.procedure.procedure_name: display_name: Column name for procedure name in java.sql.DatabaseMetaData.getProcedures() value_type: STRING value: PROCEDURE_NAME introspect.parameter.procedure_cat: display_name: Column name for catalog name in java.sql.DatabaseMetaData.getProcedureColumns() value_type: STRING value: PROCEDURE_CAT introspect.parameter.procedure_schem: display_name: Column name for schema name in java.sql.DatabaseMetaData.getProcedureColumns() value_type: STRING value: PROCEDURE_SCHEM introspect.parameter.procedure_name: display_name: Column name for procedure name in java.sql.DatabaseMetaData.getProcedureColumns() value_type: STRING value: PROCEDURE_NAME introspect.parameter.column_name: display_name: Column name for column name in java.sql.DatabaseMetaData.getProcedureColumns() value_type: STRING value: COLUMN_NAME introspect.parameter.column_type: display_name: Column name for column type in java.sql.DatabaseMetaData.getProcedureColumns() value_type: STRING value: COLUMN_TYPE introspect.parameter.data_type: display_name: Column name for data type in java.sql.DatabaseMetaData.getProcedureColumns() value_type: STRING value: DATA_TYPE introspect.parameter.type_name: display_name: Column name for type name in java.sql.DatabaseMetaData.getProcedureColumns() value_type: STRING value: TYPE_NAME introspect.parameter.length: display_name: Column name for length in java.sql.DatabaseMetaData.getProcedureColumns() value_type: STRING value: LENGTH introspect.parameter.precision: display_name: Column name for precision in java.sql.DatabaseMetaData.getProcedureColumns() value_type: STRING value: PRECISION introspect.parameter.scale: display_name: Column name for scale in java.sql.DatabaseMetaData.getProcedureColumns() value_type: STRING value: SCALE introspect.parameter.nullable: display_name: Column name for nullable in java.sql.DatabaseMetaData.getProcedureColumns() value_type: STRING value: NULLABLE semijoin: value_required_for_adapter: false value_required_for_datasource: false value_overridable_by_datasource: false display_in_ui: false members: jdbcds.disable_semijoin: display_name: Disable semijoin value_type: BOOLEAN value: false value_required_for_adapter: t value_required_for_datasource: f display_in_ui: f supportsStarSchema: display_name: Supports star schema value_type: BOOLEAN value: false value_overridable_by_datasource: f display_in_ui: f maxSourceSideCardinalityForSJ: display_name: 'Max source side cardinality for semijoin (Overrides server-wide setting. Valid values: empty string or positive integer)' value_type: STRING value: '' minTargetToSourceRatioForSJ: display_name: 'Min target to source ratio for semijoin (Overrides server-wide setting. Valid values: empty string or positive integer)' value_type: STRING value: '' jdbcds.use_or_syntax_for_semijoin: display_name: Use OR syntax for semijoin (instead of IN) value_type: BOOLEAN value: false maxNumberForOrSyntax: display_name: Max source side of semijoin to use OR syntax value_type: INTEGER value: 2147483647 value_required_for_adapter: t processing: value_required_for_adapter: false value_required_for_datasource: false value_overridable_by_datasource: true display_in_ui: false members: jdbc.batch_updates: display_name: Supports batch updates value_type: BOOLEAN value: true value_required_for_adapter: t jdbc.batch_size: display_name: Maximum number of statements in a batch for batch updates value_type: INTEGER value: 10000 jdbc.fetch_size: display_name: Number of rows to be fetched at a time (0 = use server-wide setting) value_type: INTEGER value: 0 jdbcds.no_support_autocommit: display_name: Does not support autocommit value_type: BOOLEAN value: true value_required_for_adapter: t jdbcds.set_statement_escape_processing_false: display_name: Should set escape processing on the statement to false value_type: BOOLEAN value: false jdbcds.no_support_accept_url: display_name: Driver does not support acceptsURL() check value_type: BOOLEAN value: false jdbcds.no_support_preparedstmt_for_insert: display_name: Does not support prepared statement for INSERTs value_type: BOOLEAN value: false jdbcds.no_support_preparedstmt_for_update: display_name: Does not support prepared statement for UPDATEs value_type: BOOLEAN value: false jdbcds.supports_fetch: display_name: Supports FETCH (number of rows) value_type: BOOLEAN value: true value_required_for_adapter: t jdbcds.supports_offset: display_name: Supports OFFSET value_type: BOOLEAN value: true value_required_for_adapter: t jdbcds.use_row_num_for_pagination: display_name: Use ROWNUM for pagination (ROWNUM function config item must be defined) value_type: BOOLEAN value: false jdbcds.can_cancel_statement_on_cursor_close: display_name: Can cancel statement on cursor close value_type: BOOLEAN value: false value_required_for_adapter: t string_comparison: value_required_for_adapter: false value_required_for_datasource: false value_overridable_by_datasource: false display_in_ui: false members: jdbcds.comparisons_case_insensitive: display_name: String comparison is case-insensitive value_type: BOOLEAN value: false value_required_for_adapter: t value_required_for_datasource: t value_overridable_by_datasource: t display_in_ui: t jdbcds.trailing_spaces_included_in_comparison: display_name: String comparison honors trailing spaces value_type: BOOLEAN value: true value_required_for_adapter: t value_required_for_datasource: t value_overridable_by_datasource: t display_in_ui: t jdbcds.ignore_case_sensitivity_mismatch: display_name: Ignore case sensitivity mismatch between CIS and data source value_type: BOOLEAN value: true value_required_for_adapter: t value_required_for_datasource: t display_in_ui: t jdbcds.ignore_trailing_spaces_mismatch: display_name: Ignore trailing spaces mismatch between CIS and data source value_type: BOOLEAN value: true value_required_for_adapter: t value_required_for_datasource: t display_in_ui: t jdbcds.distinct_case_insensitive: display_name: DISTINCT ignores case in string comparison value_type: BOOLEAN jdbcds.union_distinct_case_insensitive: display_name: Distinct UNION ignores case in string comparison value_type: BOOLEAN jdbcds.intersect_distinct_case_insensitive: display_name: Distinct INTERSECT ignores case in string comparison value_type: BOOLEAN jdbcds.except_distinct_case_insensitive: display_name: Distinct EXCEPT ignores case in string comparison value_type: BOOLEAN jdbcds.trailing_spaces_included_in_distinct: display_name: DISTINCT considers trailing spaces in string comparison value_type: BOOLEAN jdbcds.trailing_spaces_included_in_union_distinct: display_name: Distinct UNION considers trailing spaces in string comparison value_type: BOOLEAN jdbcds.trailing_spaces_included_in_intersect_distinct: display_name: Distinct INTERSECT considers trailing spaces in string comparison value_type: BOOLEAN jdbcds.trailing_spaces_included_in_except_distinct: display_name: Distinct EXCEPT considers trailing spaces in string comparison value_type: BOOLEAN expressions: value_required_for_adapter: false value_required_for_datasource: false value_overridable_by_datasource: true display_in_ui: false members: expr.numeric: display_name: Expression for a numeric value value_type: STRING value: $1 value_required_for_adapter: t expr.string: display_name: Expression for a string value value_type: STRING value: '''$1''' value_required_for_adapter: t expr.date: display_name: Expression for a date value value_type: STRING value: '''''yyyy-MM-dd''''' value_required_for_adapter: t expr.datetime: display_name: Expression for a datetime/timestamp value value_type: STRING value: '''''yyyy-MM-dd HH:mm:ss.SSS''''''ms''''''''' value_required_for_adapter: t expr.time: display_name: Expression for a time value value_type: STRING value: '''''HH:mm:ss''''' value_required_for_adapter: t expr.interval year: display_name: Expression for an interval year value value_type: STRING value: INTERVAL '$1' YEAR expr.interval month: display_name: Expression for an interval month value value_type: STRING value: INTERVAL '$1' MONTH expr.interval day: display_name: Expression for an interval day value value_type: STRING value: INTERVAL '$1' DAY expr.interval hour: display_name: Expression for an interval hour value value_type: STRING value: INTERVAL '$1' HOUR expr.interval minute: display_name: Expression for an interval minute value value_type: STRING value: INTERVAL '$1' MINUTE expr.interval second: display_name: Expression for an interval second value value_type: STRING value: INTERVAL '$1' SECOND expr.interval year to month: display_name: Expression for an interval year to month value value_type: STRING value: INTERVAL '$1' YEAR TO MONTH expr.interval day to hour: display_name: Expression for an interval day to hour value value_type: STRING value: INTERVAL '$1' DAY TO HOUR expr.interval day to minute: display_name: Expression for an interval day to minute value value_type: STRING value: INTERVAL '$1' DAY TO MINUTE expr.interval day to second: display_name: Expression for an interval day to second value value_type: STRING value: INTERVAL '$1' DAY TO SECOND expr.interval hour to minute: display_name: Expression for an interval hour to minute value value_type: STRING value: INTERVAL '$1' HOUR TO MINUTE expr.interval hour to second: display_name: Expression for an interval hour to second value value_type: STRING value: INTERVAL '$1' HOUR TO SECOND expr.interval minute to second: display_name: Expression for an interval minute to second value value_type: STRING value: INTERVAL '$1' MINUTE TO SECOND expr.like_pattern.wildcard: display_name: Symbol for the wildcard in LIKE value_type: STRING value: '%' value_required_for_adapter: t expr.like_pattern.single_char_wildcard: display_name: Symbol for the single char wildcard in LIKE value_type: STRING value: _ value_required_for_adapter: t expr.characters_to_escape: display_name: Characters to escape (char1 escape_char_for_char1 char2 escape_char_for_char2) value_type: STRING value: \ \ ' \ expr.characters_to_escape_for_like: display_name: Characters to escape for LIKE (char1 escape_char_for_char1 char2 escape_char_for_char2) value_type: STRING expr.interval_year_to_month_cast_pattern: display_name: Expression to cast a string to a year to month interval value_type: STRING expr.interval_day_to_second_cast_pattern: display_name: Expression to cast a string to a day to second interval value_type: STRING expr.eq_native_left_outer_join_pattern: display_name: Expression for EQUAL in native left outer joins value_type: STRING expr.ne_native_left_outer_join_pattern: display_name: Expression for NOT EQUAL in native left outer joins value_type: STRING expr.lt_native_left_outer_join_pattern: display_name: Expression for LESS THAN in native left outer joins value_type: STRING expr.le_native_left_outer_join_pattern: display_name: Expression for LESS OR EQUAL in native left outer joins value_type: STRING expr.gt_native_left_outer_join_pattern: display_name: Expression for GREATER THAN in native left outer joins value_type: STRING expr.ge_native_left_outer_join_pattern: display_name: Expression for GREATER OR EQUAL in native left outer joins value_type: STRING expr.like_native_left_outer_join_pattern: display_name: Expression for LIKE in native left outer joins value_type: STRING expr.eq_native_right_outer_join_pattern: display_name: Expression for EQUAL in native right outer joins value_type: STRING expr.ne_native_right_outer_join_pattern: display_name: Expression for NOT EQUAL in native right outer joins value_type: STRING expr.lt_native_right_outer_join_pattern: display_name: Expression for LESS THAN in native right outer joins value_type: STRING expr.le_native_right_outer_join_pattern: display_name: Expression for LESS OR EQUAL in native right outer joins value_type: STRING expr.gt_native_right_outer_join_pattern: display_name: Expression for GREATER THAN in native right outer joins value_type: STRING expr.ge_native_right_outer_join_pattern: display_name: Expression for GREATER OR EQUAL in native right outer joins value_type: STRING expr.like_native_right_outer_join_pattern: display_name: Expression for LIKE in native right outer joins value_type: STRING identifiers: value_required_for_adapter: true value_required_for_datasource: false value_overridable_by_datasource: true display_in_ui: false members: jdbcds.catalogs_in_tables: display_name: Prefix tables with catalog name value_type: BOOLEAN value: true jdbcds.catalogs_in_tables_for_updates: display_name: Prefix tables with catalog name for UPDATEs value_type: BOOLEAN value: false jdbcds.schemas_in_tables: display_name: Prefix tables with schema name value_type: BOOLEAN value: true jdbcds.schemas_in_tables_for_updates: display_name: Prefix tables with schema name for UPDATEs value_type: BOOLEAN value: true jdbcds.tables_in_columns: display_name: Prefix columns with table name value_type: BOOLEAN value: false jdbcds.unqualified_tables_in_columns: display_name: Do not qualify table name when it prefixes a column (no schema/catalog) value_type: BOOLEAN value: false jdbcds.catalog_delimited_identifier_opening_char: display_name: Catalog delimited identifier opening character value_type: STRING value: '"' jdbcds.catalog_delimited_identifier_closing_char: display_name: Catalog delimited identifier closing character value_type: STRING value: '"' jdbcds.schema_delimited_identifier_opening_char: display_name: Schema delimited identifier opening character value_type: STRING value: '"' jdbcds.schema_delimited_identifier_closing_char: display_name: Schema delimited identifier closing character value_type: STRING value: '"' jdbcds.table_delimited_identifier_opening_char: display_name: Table delimited identifier opening character value_type: STRING value: '"' jdbcds.table_delimited_identifier_closing_char: display_name: Table delimited identifier closing character value_type: STRING value: '"' jdbcds.column_delimited_identifier_opening_char: display_name: Column delimited identifier opening character value_type: STRING value: '"' jdbcds.column_delimited_identifier_closing_char: display_name: Column delimited identifier closing character value_type: STRING value: '"' jdbcds.procedure_delimited_identifier_opening_char: display_name: Procedure delimited identifier opening character value_type: STRING value: '"' jdbcds.procedure_delimited_identifier_closing_char: display_name: Procedure delimited identifier closing character value_type: STRING value: '"' ddl_support: value_required_for_adapter: false value_required_for_datasource: false value_overridable_by_datasource: true display_in_ui: false members: jdbcds.support_ddl: display_name: Supports DDL value_type: BOOLEAN value: false value_required_for_adapter: t jdbcds.ddl.explicit_commit_required: display_name: Explicit commit is required after a DDL statement value_type: BOOLEAN value: true value_required_for_adapter: t jdbcds.ddl_requires_separate_txn: display_name: DDL must be sent in a separate transaction value_type: BOOLEAN value: false jdbcds.support_ddl.avoid_newlines: display_name: DDL must not contain new line characters value_type: BOOLEAN value: false jdbcds.support_ddl.create_table: display_name: Supports CREATE TABLE value_type: BOOLEAN value: false jdbcds.ddl_create_or_replace_table: display_name: Supports CREATE OR REPLACE TABLE value_type: BOOLEAN value: false jdbcds.ddl_create_table_override: display_name: String to use instead of "CREATE TABLE" in DDL statements value_type: STRING jdbcds.support_ddl.create_table_: display_name: String to end a CREATE TABLE statement with value_type: STRING jdbcds.ddl.create_table.no_partition: display_name: CREATE TABLE statement must end with 'NO PARTITION' value_type: BOOLEAN value: false jdbcds.ddl.must_use_lowercase_for_table_identifiers: display_name: DDL must use lowercase for table identifiers value_type: BOOLEAN value: false jdbcds.table.name.max_length: display_name: Maximum allowed length of a table name value_type: INTEGER value: 128 jdbcds.support_ddl.column_defaults_not_nullable: display_name: Columns are not nullable by default value_type: BOOLEAN value: false jdbcds.no_support_nullable_on_bit_column_in_create_table: display_name: Does not support NULLABLE on BIT columns in CREATE TABLE value_type: BOOLEAN value: false jdbcds.ddl_string_postfix: display_name: String to end a VARCHAR COLUMN definition with in CREATE TABLE value_type: STRING jdbcds.ddl_string_postfix_types: display_name: String types for which to postfix COLUMN definitions (comma-separated list) value_type: STRING jdbcds.support_ddl.drop_table: display_name: Supports DROP TABLE value_type: BOOLEAN value: false jdbcds.ddl_drop_table_if_exists: display_name: Supports DROP TABLE IF EXISTS value_type: BOOLEAN value: false jdbcds.ddl_cascade_restrict_drop_table: display_name: CASCADE and RESTRICT are supported in DROP TABLE value_type: BOOLEAN value: false jdbcds.supports_truncate_table: display_name: Supports TRUNCATE TABLE value_type: BOOLEAN value: false jdbcds.requires_immediate_for_truncate_table: display_name: Requires IMMEDIATE keyword after TRUNCATE TABLE value_type: BOOLEAN value: false jdbcds.support_ddl.alter_table: display_name: Supports ALTER TABLE value_type: BOOLEAN value: false jdbcds.support_ddl.create_index: display_name: Supports CREATE INDEX value_type: BOOLEAN value: false jdbcds.unique_index.support_multiple_nulls: display_name: Unique index allows multiple NULL values in the column value_type: BOOLEAN value: false jdbcds.ddl.distribute_clause: display_name: DISTRIBUTE clause syntax, if supported (use $ as column placeholder) value_type: STRING jdbcds.ddl.distribute_on_random_columns: display_name: DISTRIBUTE ON RANDOM syntax, if supported value_type: STRING jdbcds.support_ddl.drop_index: display_name: Supports DROP INDEX value_type: BOOLEAN value: false jdbcds.ddl_drop_index_if_exists: display_name: Supports IF EXISTS in DROP INDEX value_type: BOOLEAN value: false jdbcds.ddl_drop_index_no_support_on: display_name: Does not support ON [table] in DROP INDEX value_type: BOOLEAN value: false jdbcds.ddl_drop_index_no_support_cascade_restrict: display_name: Does not support CASCADE and RESTRICT in DROP INDEX value_type: BOOLEAN value: false jdbcds.drop_index_syntax_tbl_dot_idx: display_name: Qualify index with table name in DROP INDEX value_type: BOOLEAN value: false jdbcds.drop_index_syntax_no_catalog: display_name: Don't qualify index with catalog name in DROP INDEX value_type: BOOLEAN value: false jdbcds.drop_index_syntax_no_schema: display_name: Don't qualify index with schema name in DROP INDEX value_type: BOOLEAN value: false dml_support: value_required_for_adapter: false value_required_for_datasource: false value_overridable_by_datasource: true display_in_ui: false members: jdbcds.max_sql_length: display_name: Maximum supported length of a SQL statement value_type: INTEGER value: 32768 value_required_for_adapter: t iafconnection.inserts: display_name: Supports INSERTs value_type: BOOLEAN value: true value_required_for_adapter: t iafconnection.updates: display_name: Supports UPDATEs value_type: BOOLEAN value: true value_required_for_adapter: t iafconnection.deletes: display_name: Supports DELETEs value_type: BOOLEAN value: true value_required_for_adapter: t iafconnection.fetch_container_with_filter: display_name: Supports predicates e.g. WHERE value_type: BOOLEAN value: true value_required_for_adapter: t iafconnection.fetch_with_native_sql: display_name: Supports SQL natively value_type: BOOLEAN value: true value_required_for_adapter: t jdbcds.no_support_subquery: display_name: Does not support subqueries value_type: BOOLEAN value: false value_required_for_adapter: t ds.uses_non_unicode_ordering: display_name: Uses non-unicode ordering value_type: BOOLEAN value: false jdbcds.column_aliasing_in_with_clause: display_name: Supports column aliasing in WITH clause value_type: BOOLEAN value: false jdbcds.no_support_for_aliases_in_subquery_projections: display_name: Does not support aliases for subquery projections value_type: BOOLEAN value: false jdbcds.no_support_implicit_cast_in_subquery: display_name: Does not support implicit CAST in a subquery value_type: BOOLEAN value: false jdbcds.no_set_operation_in_subquery: display_name: Does not support set operations e.g. UNION in a subquery value_type: BOOLEAN value: false jdbcds.no_support_with_clause_in_subqueries: display_name: Does not support WITH clause in a subquery value_type: BOOLEAN value: true jdbcds.no_support_with_clause_in_derived_table: display_name: Does not support WITH clause in a derived table value_type: BOOLEAN value: true jdbcds.no_support_tables_in_column_names_for_with_clause: display_name: Does not support prefixing columns with table name for projections of WITH clause value_type: BOOLEAN value: true jdbcds.no_support_aliases_in_with_clause_table_ref: display_name: Does not support aliasing of the product of the WITH clause value_type: BOOLEAN value: true jdbcds.no_support_for_with_referencing_with: display_name: Does not support WITH clause referencing another WITH clause value_type: BOOLEAN value: true jdbc.correlated_subqueries: display_name: Supports correlated subqueries value_type: BOOLEAN value: true value_required_for_adapter: t jdbcds.scalar_subqueries: display_name: Supports scalar subqueries value_type: BOOLEAN value: false value_required_for_adapter: t jdbcds.no_support_scalar_subquery_as_projection_with_group_by: display_name: Does not support scalar subquery as projection with GROUP BY value_type: BOOLEAN value: true jdbcds.no_support_scalar_subqueries_in_orderby: display_name: Does not support scalar subqueries in ORDER BY value_type: BOOLEAN value: true jdbcds.no_support_scalar_subqueries_in_aggregate_functions: display_name: Does not support scalar subqueries in aggregate functions value_type: BOOLEAN value: true jdbcds.no_support_aggregate_correlated_references: display_name: Does not support aggregate correlated references value_type: BOOLEAN value: true jdbcds.evaluates_aggregate_correlated_references_in_parent_query: display_name: Data source evaluates aggregate correlated references in the outer query value_type: BOOLEAN value: false jdbcds.no_support_nested_analyticaloraggregate_functions: display_name: Does not support nested analytical or aggregate functions value_type: BOOLEAN value: true jdbcds.no_support_distinct_operator_with_distinct_aggregates: display_name: Does not support DISTINCT operator with DISTINCT aggregates value_type: BOOLEAN value: false jdbc.like_escape_clause: display_name: Supports LIKE operator with ESCAPE character value_type: BOOLEAN value: true jdbcds.no_support_case: display_name: Does not support CASE expression value_type: BOOLEAN value: false value_required_for_adapter: t jdbcds.no_support_case_expression_with_subquery_in_join_criteria: display_name: Does not support CASE expression with a subquery in JOIN criteria value_type: BOOLEAN value: true jdbcds.no_support_in_operator_in_join_criteria: display_name: Does not support IN clause in JOIN criteria value_type: BOOLEAN value: true jdbcds.no_support_subqueries_inside_case_expression: display_name: Does not support subqueries inside CASE expression value_type: BOOLEAN value: true jdbcds.no_support_subqueries_inside_case_expression_in_order_by: display_name: Does not support subqueries inside CASE expression in ORDER BY value_type: BOOLEAN value: true jdbcds.no_support_subqueries_inside_case_expression_in_group_by: display_name: Does not support subqueries inside CASE expression in GROUP BY value_type: BOOLEAN value: true jdbcds.no_support_subqueries_inside_case_expression_in_in_operator_values: display_name: Does not support subqueries inside CASE expression in IN operator values value_type: BOOLEAN value: true jdbcds.no_support_in_operator_with_values: display_name: Does not support IN operator with values value_type: BOOLEAN value: false jdbcds.max_number_of_in_operator_values: display_name: Maximum number of IN operator values value_type: INTEGER jdbcds.supports_only_plain_literal_values_in_in_operator: display_name: Supports only plain literal values as IN clause values value_type: BOOLEAN value: false jdbcds.supports_only_plain_literal_values_in_like_pattern: display_name: Supports only plain literal values as pattern argument of LIKE value_type: BOOLEAN value: false jdbc.mixed_case_quoted_identifiers: display_name: Supports mixed case quoted identifiers value_type: BOOLEAN value: true jdbcds.sql92_join_syntax: display_name: Supports SQL92 JOIN syntax value_type: BOOLEAN value: true value_required_for_adapter: t jdbcds.no_support_sql92_full_outer_join: display_name: Does not support SQL92 FULL OUTER JOIN syntax value_type: BOOLEAN value: false value_required_for_adapter: t jdbcds.no_support_sql92_cross_join: display_name: Does not support SQL92 FULL CROSS JOIN syntax value_type: BOOLEAN value: false value_required_for_adapter: t jdbcds.native_outer_join_syntax: display_name: Supports native (nonstandard) OUTER JOIN syntax value_type: BOOLEAN value: true jdbcds.no_parentheses_for_nested_joins: display_name: Do not use parenthesis in nested JOINs value_type: BOOLEAN value: true jdbcds.no_multi_joins_with_subselect: display_name: Does not support grouping of JOINs using parenthesis if there is a subselect in FROM value_type: BOOLEAN value: false jdbc.subqueries_in_ins: display_name: Supports subqueries in IN clause value_type: BOOLEAN value: true value_required_for_adapter: t jdbcds.subqueries_in_from: display_name: Supports subqueries in FROM clause value_type: BOOLEAN value: true value_required_for_adapter: t jdbcds.no_support_subquery_in_join_criteria: display_name: Does not support subqueries in JOIN criteria value_type: BOOLEAN value: true value_required_for_adapter: t jdbcds.no_support_cor_ref_in_join_criteria: display_name: Does not support correlated reference to parent query in JOIN criteria value_type: BOOLEAN value: true jdbcds.no_support_disjunction_in_join_criteria: display_name: Does not support disjunction (OR) in JOIN criteria value_type: BOOLEAN value: false value_required_for_adapter: t jdbcds.no_support_non_equi_in_join_criteria: display_name: Does not support inequality operator in JOIN criteria value_type: BOOLEAN value: true value_required_for_adapter: t jdbcds.requires_left_deep_join_tree: display_name: Requires left-deep join tree value_type: BOOLEAN value: false jdbcds.no_support_paranthesis_before_select: display_name: Does not support parenthesis before SELECT keyword value_type: BOOLEAN value: true jdbcds.bracket_in_sql: display_name: Needs delimited identifiers in callable statements value_type: BOOLEAN value: false value_required_for_adapter: t jdbcds.insert_with_subqueries: display_name: Subqueries can be used in INSERT statements value_type: BOOLEAN value: true jdbcds.update_not_supported_native_datatype: display_name: Native data types not supported in INSERTs and UPDATEs (comma-separated list) value_type: STRING value: BLOB,CLOB value_required_for_adapter: t jdbcds.insert_with_multi_row_values: display_name: Supports multiple row values in INSERT (insert ... values (1, 2)) value_type: BOOLEAN value: false jdbcds.insert_default_string: display_name: The DEFAULT string in INSERTs (insert ... values (1, DEFAULT)) value_type: STRING jdbcds.insert_default_values_string: display_name: The DEFAULT VALUES string in INSERTs (insert ... default values) value_type: STRING jdbcds.merge: display_name: Supports MERGE statement value_type: BOOLEAN value: false jdbcds.merge.sql2003: display_name: Supports SQL 2003 MERGE statement value_type: BOOLEAN value: false jdbcds.merge.sql2008: display_name: Supports SQL 2008 MERGE statement value_type: BOOLEAN value: false jdbcds.merge.no_support_when_search: display_name: Does not support SQL 2008 MERGE WHEN search conditions value_type: BOOLEAN value: false jdbcds.merge.no_support_delete: display_name: Does not support SQL 2008 MERGE DELETE (WHEN MATCHED THEN DELETE) value_type: BOOLEAN value: false jdbcds.updatable_cursor_requires_unique_index: display_name: For MERGE, target table must have a unique index, and all columns in the unique must be selected value_type: BOOLEAN value: false jdbcds.no_support_count_star: display_name: Does not support COUNT(*) value_type: BOOLEAN value: false value_required_for_adapter: t jdbcds.support_quantified_comparisons: display_name: Supports quantified comparisons (ALL, ANY) value_type: BOOLEAN value: false value_required_for_adapter: t jdbcds.use_dateformat_matching: display_name: Use dateformat matching value_type: BOOLEAN value: false jdbcds.supports_window_frame_exclusion: display_name: Supports window frame exclusion in analytical functions value_type: BOOLEAN value: false jdbcds.no_support_alias: display_name: Does not support aliases value_type: BOOLEAN value: false value_required_for_adapter: t jdbcds.max_sql_alias_length: display_name: Max length of an alias value_type: INTEGER value: 30 value_required_for_adapter: t jdbcds.alias.dot_replacement: display_name: String to replace the dot in aliases value_type: STRING value: _ jdbcds.having_may_use_aliased_selectable: display_name: HAVING can use an aliased selectable value_type: BOOLEAN value: false jdbcds.support_alias_for_aggregate_col_only: display_name: Aliases are supported only on aggregate columns value_type: BOOLEAN value: false jdbcds.table_alias_requires_as: display_name: Must precede table alias with 'AS' value_type: BOOLEAN value: true jdbcds.match_union_left_right_aliases: display_name: Aliases of corresponding columns on both sides of a set operation must match value_type: BOOLEAN value: true jdbcds.generate_aliases_for_duplicate_aliases: display_name: Generate aliases for duplicate aliases value_type: BOOLEAN value: true jdbcds.datatype.max_binary_length: display_name: Max length of binary data type value_type: LONG value: 255 value_required_for_adapter: t jdbcds.datatype.max_varbinary_length: display_name: Max length of varbinary data type value_type: LONG value: 4000 value_required_for_adapter: t jdbcds.datatype.max_blob_length: display_name: Max length of blob data type value_type: LONG value: 4294967296 value_required_for_adapter: t jdbcds.datatype.max_char_length: display_name: Max length of char data type value_type: LONG value: 255 value_required_for_adapter: t jdbcds.datatype.max_varchar_length: display_name: Max length of varchar data type value_type: LONG value: 4000 value_required_for_adapter: t jdbcds.datatype.max_clob_length: display_name: Max length of clob data type value_type: LONG value: 4294967296 value_required_for_adapter: t jdbcds.datatype.max_precision: display_name: Max precision of decimal data type value_type: LONG value: 38 value_required_for_adapter: t jdbcds.datatype.max_scale: display_name: Max scale of decimal data type value_type: LONG value: 10 value_required_for_adapter: t jdbcds.datatype.min_precision: display_name: Minimum precision of decimal data type value_type: LONG jdbcds.datatype.min_scale: display_name: Minimum scale of decimal data type value_type: LONG jdbcds.cast_function_max_binary_length: display_name: Max length of binary data type in CAST function value_type: LONG value: 255 jdbcds.cast_function_max_varbinary_length: display_name: Max length of varbinary data type in CAST function value_type: LONG value: 4000 jdbcds.cast_function_max_char_length: display_name: Max length of char data type in CAST function value_type: LONG value: 255 jdbcds.cast_function_max_varchar_length: display_name: Max length of varchar data type in CAST function value_type: LONG value: 4000 jdbcds.cast_function_max_precision: display_name: Max precision of decimal data type in CAST function value_type: LONG value: 38 value_required_for_adapter: t jdbcds.cast_function_max_scale: display_name: Max scale of decimal data type in CAST function value_type: LONG value: 10 jdbcds.no_support_null_literal: display_name: Does not support NULL by itself as a literal value_type: BOOLEAN value: false value_required_for_adapter: t jdbcds.no_support_for_literal_only_comprison: display_name: Does not support comparison with literals on both sides of it value_type: BOOLEAN value: true jdbcds.null_comparison_same_as_is_null_comparison: display_name: '''value = NULL'' is equivalent to ''value is NULL''' value_type: BOOLEAN value: false value_required_for_adapter: t jdbcds.promotes_integer_division_to_float: display_name: Integer division is promoted to a float value_type: BOOLEAN value: true value_required_for_adapter: t jdbcds.requires_alias_for_aggregate_functions_in_order_by: display_name: Requires alias after aggregate function to use it in ORDER BY value_type: BOOLEAN value: false jdbcds.order_by_aggregate_functions_should_be_projected: display_name: Aggregate functions in ORDER BY must be projected value_type: BOOLEAN value: false jdbcds.no_scalar_with_aggregate_functions_in_order_by: display_name: Does not support scalar functions with aggregate functions in ORDER BY value_type: BOOLEAN value: true jdbcds.no_support_for_function_in_predicate: display_name: Does not support functions in the predicate value_type: BOOLEAN value: false jdbcds.no_support_for_null_projections_in_set_operation: display_name: Does not support null projections in set (e.g. union) operations value_type: BOOLEAN value: true jdbcds.no_support_literal_projection: display_name: Does not support literal projections value_type: BOOLEAN value: true value_required_for_adapter: t jdbcds.must_project_sort_arg_with_distinct_gb: display_name: Requires aggregate functions in ORDER BY to be projected value_type: BOOLEAN value: false jdbcds.must_project_group_by_expression: display_name: Requires argument of GROUP BY to be projected value_type: BOOLEAN value: false jdbcds.must_project_sort_arg_expression: display_name: Requires argument of ORDER BY to be projected and aliased value_type: BOOLEAN value: false jdbcds.no_support_more_than_one_aggregate_distinct_function_in_projection: display_name: Does not support more than one aggregate distinct function in projections value_type: BOOLEAN value: true jdbcds.group_by.simple_columns_only: display_name: Does not support expressions such as functions in GROUP BY value_type: BOOLEAN value: false jdbcds.null_predicate.simple_columns_only: display_name: Does not support expressions such as functions used with IS NULL value_type: BOOLEAN value: false jdbcds.distinct_expression.simple_columns_only: display_name: Does not support expressions such as functions inside aggregate distinct functions value_type: BOOLEAN value: false jdbcds.count_function.simple_columns_only: display_name: Does not support expressions such as functions inside COUNT function value_type: BOOLEAN value: true jdbcds.no_support_xml_types_with_distinct: display_name: Does not support DISTINCT with XML types as projections value_type: BOOLEAN value: true data_source_specific: value_required_for_adapter: false value_required_for_datasource: false value_overridable_by_datasource: false display_in_ui: false members: {} type_mappings: value_required_for_adapter: true value_required_for_datasource: false value_overridable_by_datasource: true display_in_ui: false native_to_cis: bigint: bigint bigserial: bigint binary_double: double binary_float: real bit: bit bool: boolean boolean: boolean box: varchar bpchar: char bytea: blob char: char character: char character_varying: varchar cid: char cidr: varchar circle: varchar date: date datetime: timestamp datetime2: timestamp decimal: decimal double_precision: double float: float float4: real float8: double guid: varchar hierarchyid: varbinary image: blob inet: varchar int: integer int2: smallint int4: integer int8: bigint integer: integer interval: interval_day_to_second interval_day: interval_day interval_day_to_hour: interval_day_to_hour interval_day_to_minute: interval_day_to_minute interval_day_to_second: interval_day_to_second interval_hour: interval_hour interval_hour_to_minute: interval_hour_to_minute interval_hour_to_second: interval_hour_to_second interval_minute: interval_minute interval_minute_to_second: interval_minute_to_second interval_month: interval_month interval_second: interval_second interval_year: interval_year interval_year_to_month: interval_year_to_month line: varchar long: bigint lseg: varchar macaddr: varchar money: decimal number: decimal numeric: numeric oid: blob path: varchar point: char polygon: varchar real: real rowid: varchar serial: integer smalldatetime: timestamp smallint: smallint text: clob time: varchar timestamp: timestamp timestamptz: timestamp timetz: time tinyint: smallint uniqueidentifier: char urowid: varchar uuid: char varbit: varchar varchar: varchar varchar2: varchar xid: integer xml: xml cis_to_native: bigint: bigint binary: binary bit: smallint blob: bytea boolean: boolean char: char(&l) clob: text date: date decimal: decimal(&p, &s) double: double float: float integer: integer interval_day: varchar(30) interval_day_to_hour: varchar(30) interval_day_to_minute: varchar(30) interval_day_to_second: varchar(30) interval_hour: varchar(30) interval_hour_to_minute: varchar(30) interval_hour_to_second: varchar(30) interval_minute: varchar(30) interval_minute_to_second: varchar(30) interval_month: varchar(9) interval_second: varchar(30) interval_year: varchar(9) interval_year_to_month: varchar(12) numeric: numeric(&p, &s) real: real smallint: smallint time: time timestamp: timestamp tinyint: smallint varbinary: varbinary varchar: varchar(&l) xml: varchar clause_support: value_required_for_adapter: true value_required_for_datasource: false value_overridable_by_datasource: true display_in_ui: false members: select.clause: display_name: SELECT native_expression: SELECT where.clause: display_name: WHERE native_expression: WHERE unsupported_derived_types: lobs, varbinary, longvarchar, xml join.clause: display_name: JOIN native_expression: JOIN unsupported_derived_types: lobs, varbinary, longvarchar, xml distinct.clause: display_name: DISTINCT native_expression: DISTINCT unsupported_derived_types: lobs, varbinary, longvarchar, xml orderby.clause: display_name: ORDER BY native_expression: ORDER BY unsupported_derived_types: lobs, varbinary, longvarchar, xml groupby.clause: display_name: GROUP BY native_expression: GROUP BY unsupported_derived_types: lobs, varbinary, longvarchar, xml union.clause: display_name: UNION native_expression: UNION unsupported_derived_types: lobs, varbinary, longvarchar, xml union_all.clause: display_name: UNION ALL native_expression: UNION ALL unsupported_derived_types: lobs, varbinary, longvarchar, xml having.clause: display_name: HAVING native_expression: HAVING unsupported_derived_types: lobs, varbinary, longvarchar, xml exists.clause: display_name: EXISTS native_expression: EXISTS unsupported_derived_types: lobs, varbinary, longvarchar, xml operator_support: value_required_for_adapter: false value_required_for_datasource: false value_overridable_by_datasource: true display_in_ui: false members: eq_oper: display_name: X = Y (equal) native_expression: $1 = $2 arguments: combination1: arguments_in_order: - cis.numbers - cis.numbers combination2: arguments_in_order: - cis.varchar - cis.varchar combination3: arguments_in_order: - cis.char - cis.char combination4: arguments_in_order: - cis.date - cis.date combination5: arguments_in_order: - cis.timestamp - cis.timestamp combination6: arguments_in_order: - cis.time - cis.time combination7: arguments_in_order: - cis.binary - cis.binary combination8: arguments_in_order: - cis.varbinary - cis.varbinary combination9: arguments_in_order: - cis.boolean - cis.boolean combination10: arguments_in_order: - cis.any - cis.null combination11: arguments_in_order: - cis.null - cis.any combination12: arguments_in_order: - cis.char - cis.varchar combination13: arguments_in_order: - cis.varchar - cis.char gt_oper: display_name: X > Y (greater than) native_expression: $1 > $2 arguments: combination1: arguments_in_order: - cis.numbers - cis.numbers combination2: arguments_in_order: - cis.varchar - cis.varchar combination3: arguments_in_order: - cis.char - cis.char combination4: arguments_in_order: - cis.date - cis.date combination5: arguments_in_order: - cis.timestamp - cis.timestamp combination6: arguments_in_order: - cis.time - cis.time combination7: arguments_in_order: - cis.binary - cis.binary combination8: arguments_in_order: - cis.varbinary - cis.varbinary combination9: arguments_in_order: - cis.boolean - cis.boolean combination10: arguments_in_order: - cis.null - cis.null combination11: arguments_in_order: - cis.char - cis.varchar combination12: arguments_in_order: - cis.varchar - cis.char lt_oper: display_name: X < Y (less than) native_expression: $1 < $2 arguments: combination1: arguments_in_order: - cis.numbers - cis.numbers combination2: arguments_in_order: - cis.varchar - cis.varchar combination3: arguments_in_order: - cis.char - cis.char combination4: arguments_in_order: - cis.date - cis.date combination5: arguments_in_order: - cis.timestamp - cis.timestamp combination6: arguments_in_order: - cis.time - cis.time combination7: arguments_in_order: - cis.binary - cis.binary combination8: arguments_in_order: - cis.varbinary - cis.varbinary combination9: arguments_in_order: - cis.boolean - cis.boolean combination10: arguments_in_order: - cis.null - cis.null combination11: arguments_in_order: - cis.char - cis.varchar combination12: arguments_in_order: - cis.varchar - cis.char ge_oper: display_name: X >= Y (greater or equal) native_expression: $1 >= $2 arguments: combination1: arguments_in_order: - cis.numbers - cis.numbers combination2: arguments_in_order: - cis.varchar - cis.varchar combination3: arguments_in_order: - cis.char - cis.char combination4: arguments_in_order: - cis.date - cis.date combination5: arguments_in_order: - cis.timestamp - cis.timestamp combination6: arguments_in_order: - cis.time - cis.time combination7: arguments_in_order: - cis.binary - cis.binary combination8: arguments_in_order: - cis.varbinary - cis.varbinary combination9: arguments_in_order: - cis.boolean - cis.boolean combination10: arguments_in_order: - cis.null - cis.null combination11: arguments_in_order: - cis.char - cis.varchar combination12: arguments_in_order: - cis.varchar - cis.char le_oper: display_name: X <= Y (less or equal) native_expression: $1 <= $2 arguments: combination1: arguments_in_order: - cis.numbers - cis.numbers combination2: arguments_in_order: - cis.varchar - cis.varchar combination3: arguments_in_order: - cis.char - cis.char combination4: arguments_in_order: - cis.date - cis.date combination5: arguments_in_order: - cis.timestamp - cis.timestamp combination6: arguments_in_order: - cis.time - cis.time combination7: arguments_in_order: - cis.binary - cis.binary combination8: arguments_in_order: - cis.varbinary - cis.varbinary combination9: arguments_in_order: - cis.boolean - cis.boolean combination10: arguments_in_order: - cis.null - cis.null combination11: arguments_in_order: - cis.char - cis.varchar combination12: arguments_in_order: - cis.varchar - cis.char ne_oper: display_name: X != Y (not equal) native_expression: $1 != $2 arguments: combination1: arguments_in_order: - cis.numbers - cis.numbers combination2: arguments_in_order: - cis.varchar - cis.varchar combination3: arguments_in_order: - cis.char - cis.char combination4: arguments_in_order: - cis.date - cis.date combination5: arguments_in_order: - cis.timestamp - cis.timestamp combination6: arguments_in_order: - cis.time - cis.time combination7: arguments_in_order: - cis.binary - cis.binary combination8: arguments_in_order: - cis.varbinary - cis.varbinary combination9: arguments_in_order: - cis.boolean - cis.boolean combination10: arguments_in_order: - cis.any - cis.null combination11: arguments_in_order: - cis.null - cis.any combination12: arguments_in_order: - cis.char - cis.varchar combination13: arguments_in_order: - cis.varchar - cis.char and_oper: display_name: X AND Y native_expression: $1 AND $2 arguments: {} or_oper: display_name: X OR Y native_expression: $1 OR $2 arguments: {} like_oper: display_name: X LIKE Y native_expression: $1 LIKE $2 arguments: combination1: arguments_in_order: - cis.strings - cis.strings in_oper: display_name: X IN (A,B) native_expression: $1 IN ($2) arguments: {} in_row_oper: display_name: (X,Y) IN (A,B) native_expression: ($1) IN ($2) arguments: {} is_null_oper: display_name: X IS NULL native_expression: $1 IS NULL arguments: combination1: arguments_in_order: - cis.any is_not_null_oper: display_name: X IS NOT NULL native_expression: $1 IS NOT NULL arguments: combination1: arguments_in_order: - cis.any not_oper: display_name: NOT X native_expression: NOT ($1) arguments: {} union_oper: display_name: UNION (define operands here) native_expression: (defined by UNION clause) arguments: combination1: arguments_in_order: - cis.numbers - cis.numbers combination2: arguments_in_order: - cis.varchar - cis.varchar combination3: arguments_in_order: - cis.char - cis.char combination4: arguments_in_order: - cis.date - cis.date combination5: arguments_in_order: - cis.timestamp - cis.timestamp combination6: arguments_in_order: - cis.time - cis.time combination7: arguments_in_order: - cis.binary - cis.binary combination8: arguments_in_order: - cis.varbinary - cis.varbinary combination9: arguments_in_order: - cis.boolean - cis.boolean combination10: arguments_in_order: - cis.any - cis.null combination11: arguments_in_order: - cis.null - cis.any function_support: value_required_for_adapter: false value_required_for_datasource: false value_overridable_by_datasource: true display_in_ui: false members: {}