com.simba.dsi.core.utilities
Class SqlConstants

java.lang.Object
  extended by com.simba.dsi.core.utilities.SqlConstants

public class SqlConstants
extends java.lang.Object

SQL constants.


Field Summary
static long SQL_AA_FALSE
          Constant indicating the application is an Unicode application, used for DSI_CONN_ANSI_APP.
static long SQL_AA_TRUE
          Constant indicating the application is an ANSI application, used for DSI_CONN_ANSI_APP.
static long SQL_AD_ADD_CONSTRAINT_DEFERRABLE
          Bitmask enumerating the clauses in the ALTER DOMAIN statement, indicates the supported <constraint attributes> if <add domain constraint> is supported.
static long SQL_AD_ADD_CONSTRAINT_INITIALLY_DEFERRED
          Bitmask enumerating the clauses in the ALTER DOMAIN statement, indicates the supported <constraint attributes> if <add domain constraint> is supported.
static long SQL_AD_ADD_CONSTRAINT_INITIALLY_IMMEDIATE
          Bitmask enumerating the clauses in the ALTER DOMAIN statement, indicates the supported <constraint attributes> if <add domain constraint> is supported.
static long SQL_AD_ADD_CONSTRAINT_NON_DEFERRABLE
          Bitmask enumerating the clauses in the ALTER DOMAIN statement, indicates the supported <constraint attributes> if <add domain constraint> is supported.
static long SQL_AD_ADD_DOMAIN_CONSTRAINT
          Bitmask enumerating the clauses in the ALTER DOMAIN statement, indicates adding a domain constraint is supported.
static long SQL_AD_ADD_DOMAIN_DEFAULT
          Bitmask enumerating the clauses in the ALTER DOMAIN statement, indicates <alter domain> <set domain default clause> is supported.
static long SQL_AD_CONSTRAINT_NAME_DEFINITION
          Bitmask enumerating the clauses in the ALTER DOMAIN statement, indicates <constraint name definition clause> is supported for naming domain constraint.
static long SQL_AD_DROP_DOMAIN_CONSTRAINT
          Bitmask enumerating the clauses in the ALTER DOMAIN statement, indicates <drop domain constraint clause> is supported.
static long SQL_AD_DROP_DOMAIN_DEFAULT
          Bitmask enumerating the clauses in the ALTER DOMAIN statement, indicates <alter domain> <drop domain default clause> is supported.
static long SQL_AF_ALL
          Bitmask enumerating support for aggregate functions for DSI_AGGREGATE_FUNCTIONS.
static long SQL_AF_AVG
          Bitmask enumerating support for aggregate functions for DSI_AGGREGATE_FUNCTIONS.
static long SQL_AF_COUNT
          Bitmask enumerating support for aggregate functions for DSI_AGGREGATE_FUNCTIONS.
static long SQL_AF_DISTINCT
          Bitmask enumerating support for aggregate functions for DSI_AGGREGATE_FUNCTIONS.
static long SQL_AF_MAX
          Bitmask enumerating support for aggregate functions for DSI_AGGREGATE_FUNCTIONS.
static long SQL_AF_MIN
          Bitmask enumerating support for aggregate functions for DSI_AGGREGATE_FUNCTIONS.
static long SQL_AF_SUM
          Bitmask enumerating support for aggregate functions for DSI_AGGREGATE_FUNCTIONS.
static long SQL_AM_CONNECTION
          A constant specifying the level of asynchronous support in the driver, indicates connection level asynchronous execution is supported.
static long SQL_AM_NONE
          A constant specifying the level of asynchronous support in the driver, indicates asynchronous mode is not supported.
static long SQL_AM_STATEMENT
          A constant specifying the level of asynchronous support in the driver, indicates statement level asynchronous execution is supported.
static long SQL_ASYNC_DBC_CAPABLE
          A constant indicating that asynchronous connection functions execution is supported.
static long SQL_ASYNC_DBC_NOT_CAPABLE
          A constant indicating that asynchronous connection functions execution is not supported.
static long SQL_AT_ADD_COLUMN_COLLATION
          Bitmask enumerating the clauses in the ALTER TABLE statement, indicates <add column> clause is supported, with facility to specify column collation.
static long SQL_AT_ADD_COLUMN_DEFAULT
          Bitmask enumerating the clauses in the ALTER TABLE statement, indicates <add column> clause is supported, with facility to specify column defaults.
static long SQL_AT_ADD_COLUMN_SINGLE
          Bitmask enumerating the clauses in the ALTER TABLE statement, indicates <add column> is supported.
static long SQL_AT_ADD_CONSTRAINT
          Bitmask enumerating the clauses in the ALTER TABLE statement, indicates <add column> clause is supported, with facility to specify column constraints.
static long SQL_AT_ADD_TABLE_CONSTRAINT
          Bitmask enumerating the clauses in the ALTER TABLE statement, indicates <add table constraint> clause is supported.
static long SQL_AT_CONSTRAINT_DEFERRABLE
          Bitmask enumerating the clauses in the ALTER TABLE statement, indicates the support <constraint attributes> if specifying column or table constraints is supported.
static long SQL_AT_CONSTRAINT_INITIALLY_DEFERRED
          Bitmask enumerating the clauses in the ALTER TABLE statement, indicates the support <constraint attributes> if specifying column or table constraints is supported.
static long SQL_AT_CONSTRAINT_INITIALLY_IMMEDIATE
          Bitmask enumerating the clauses in the ALTER TABLE statement, indicates the support <constraint attributes> if specifying column or table constraints is supported.
static long SQL_AT_CONSTRAINT_NAME_DEFINITION
          Bitmask enumerating the clauses in the ALTER TABLE statement, indicates <constraint name definition> is supported for naming column and table constraints.
static long SQL_AT_CONSTRAINT_NON_DEFERRABLE
          Bitmask enumerating the clauses in the ALTER TABLE statement, indicates the support <constraint attributes> if specifying column or table constraints is supported.
static long SQL_AT_DROP_COLUMN_CASCADE
          Bitmask enumerating the clauses in the ALTER TABLE statement, indicates <drop column> CASCADE is supported.
static long SQL_AT_DROP_COLUMN_DEFAULT
          Bitmask enumerating the clauses in the ALTER TABLE statement, indicates <alter column> <drop column default clause> is supported.
static long SQL_AT_DROP_COLUMN_RESTRICT
          Bitmask enumerating the clauses in the ALTER TABLE statement, indicates <drop column> RESTRICT is supported.
static long SQL_AT_DROP_TABLE_CONSTRAINT_CASCADE
          Bitmask enumerating the clauses in the ALTER TABLE statement.
static long SQL_AT_DROP_TABLE_CONSTRAINT_RESTRICT
          Bitmask enumerating the clauses in the ALTER TABLE statement.
static long SQL_AT_SET_COLUMN_DEFAULT
          Bitmask enumerating the clauses in the ALTER TABLE statement, indicates <alter column> <set column default clause> is supported.
static long SQL_AUTOCOMMIT_OFF
          Constant indicating manual-commit mode, used for DSI_CONN_AUTOCOMMIT.
static long SQL_AUTOCOMMIT_ON
          Constant indicating auto-commit mode, used for DSI_CONN_AUTOCOMMIT.
static long SQL_BP_CLOSE
          Bitmask enumerating the operations through which bookmarks persist, indicates bookmarks are valid after an application calls closes the cursor associated with a statement.
static long SQL_BP_DELETE
          Bitmask enumerating the operations through which bookmarks persist, indicates bookmark for a row is valid after that row has been deleted.
static long SQL_BP_DROP
          Bitmask enumerating the operations through which bookmarks persist, indicates bookmarks are valid after an application calls SQLFreeHandle with a HandleType of SQL_HANDLE_STMT to drop a statement.
static long SQL_BP_OTHER_HSTMT
          Bitmask enumerating the operations through which bookmarks persist, indicates bookmark associated with one statement can be used with another statement.
static long SQL_BP_SCROLL
          Bitmask enumerating the operations through which bookmarks persist, indicates bookmarks are valid after any scrolling operation.
static long SQL_BP_TRANSACTION
          Bitmask enumerating the operations through which bookmarks persist, indicates bookmarks are valid after an application commits or rolls back a transaction.
static long SQL_BP_UPDATE
          Bitmask enumerating the operations through which bookmarks persist, indicates bookmark for a row is valid after any column in that row has been updated, including key columns.
static long SQL_BRC_EXPLICIT
          Bitmask enumerating the behavior of the driver with respect to the availability of row counts, indicates row counts, if any, are available when a batch is executed directly.
static long SQL_BRC_PROCEDURES
          Bitmask enumerating the behavior of the driver with respect to the availability of row counts, indicates row counts, if any, are available when a batch is executed in a stored procedure.
static long SQL_BRC_ROLLED_UP
          Bitmask enumerating the behavior of the driver with respect to the availability of row counts, indicates row counts for consecutive INSERT, DELETE, or UPDATE statements are rolled up into one.
static long SQL_BS_ROW_COUNT_EXPLICIT
          Bitmask enumerating the driver's support for batches, indicates driver supports explicit batches that can have row-count generating statements.
static long SQL_BS_ROW_COUNT_PROC
          Bitmask enumerating the driver's support for batches, indicates driver supports explicit procedures that can have row-count generating statements.
static long SQL_BS_SELECT_EXPLICIT
          Bitmask enumerating the driver's support for batches, indicates driver supports explicit batches that can have result-set generating statements.
static long SQL_BS_SELECT_PROC
          Bitmask enumerating the driver's support for batches, indicates driver supports explicit procedures that can have result-set generating statements.
static long SQL_CA_CONSTRAINT_DEFERRABLE
          Bitmask enumerating the clauses in the CREATE ASSERTION statement, as defined in SQL-92, supported by the data source.
static long SQL_CA_CONSTRAINT_INITIALLY_DEFERRED
          Bitmask enumerating the clauses in the CREATE ASSERTION statement, as defined in SQL-92, supported by the data source.
static long SQL_CA_CONSTRAINT_INITIALLY_IMMEDIATE
          Bitmask enumerating the clauses in the CREATE ASSERTION statement, as defined in SQL-92, supported by the data source.
static long SQL_CA_CONSTRAINT_NON_DEFERRABLE
          Bitmask enumerating the clauses in the CREATE ASSERTION statement, as defined in SQL-92, supported by the data source.
static long SQL_CA_CREATE_ASSERTION
          Bitmask enumerating the clauses in the CREATE ASSERTION statement, as defined in SQL-92, supported by the data source.
static long SQL_CA1_ABSOLUTE
          Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates FetchOrientation arguments of SQL_FETCH_FIRST, SQL_FETCH_LAST, and SQL_FETCH_ABSOLUTE are supported in a call to SQLFetchScroll when the cursor is a dynamic cursor.
static long SQL_CA1_BOOKMARK
          Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates a FetchOrientation argument of SQL_FETCH_BOOKMARK is supported in a call to SQLFetchScroll when the cursor is a dynamic cursor.
static long SQL_CA1_BULK_ADD
          Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates an Operation argument of SQL_ADD is supported in a call to SQLBulkOperations when the cursor is a dynamic cursor.
static long SQL_CA1_BULK_DELETE_BY_BOOKMARK
          Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates an Operation argument of SQL_DELETE_BY_BOOKMARK is supported in a call to SQLBulkOperations when the cursor is a dynamic cursor.
static long SQL_CA1_BULK_FETCH_BY_BOOKMARK
          Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates an Operation argument of SQL_FETCH_BY_BOOKMARK is supported in a call to SQLBulkOperations when the cursor is a dynamic cursor.
static long SQL_CA1_BULK_UPDATE_BY_BOOKMARK
          Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates an Operation argument of SQL_UPDATE_BY_BOOKMARK is supported in a call to SQLBulkOperations when the cursor is a dynamic cursor.
static long SQL_CA1_LOCK_EXCLUSIVE
          Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates a LockType argument of SQL_LOCK_EXCLUSIVE is supported in a call to SQLSetPos when the cursor is a dynamic cursor.
static long SQL_CA1_LOCK_NO_CHANGE
          Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates a LockType argument of SQL_LOCK_NO_CHANGE is supported in a call to SQLSetPos when the cursor is a dynamic cursor.
static long SQL_CA1_LOCK_UNLOCK
          Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates a LockType argument of SQL_LOCK_UNLOCK is supported in a call to SQLSetPos when the cursor is a dynamic cursor.
static long SQL_CA1_NEXT
          Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates a FetchOrientation argument of SQL_FETCH_NEXT is supported in a call to SQLFetchScroll when the cursor is a dynamic cursor.
static long SQL_CA1_POS_DELETE
          Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates an Operation argument of SQL_DELETE is supported in a call to SQLSetPos when the cursor is a dynamic cursor.
static long SQL_CA1_POS_POSITION
          Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates an Operation argument of SQL_POSITION is supported in a call to SQLSetPos when the cursor is a dynamic cursor.
static long SQL_CA1_POS_REFRESH
          Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates an Operation argument of SQL_REFRESH is supported in a call to SQLSetPos when the cursor is a dynamic cursor.
static long SQL_CA1_POS_UPDATE
          Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates an Operation argument of SQL_UPDATE is supported in a call to SQLSetPos when the cursor is a dynamic cursor.
static long SQL_CA1_POSITIONED_DELETE
          Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates a DELETE WHERE CURRENT OF SQL statement is supported when the cursor is a dynamic cursor.
static long SQL_CA1_POSITIONED_UPDATE
          Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates an UPDATE WHERE CURRENT OF SQL statement is supported when the cursor is a dynamic cursor.
static long SQL_CA1_RELATIVE
          Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates FetchOrientation arguments of SQL_FETCH_PRIOR and SQL_FETCH_RELATIVE are supported in a call to SQLFetchScroll when the cursor is a dynamic cursor.
static long SQL_CA1_SELECT_FOR_UPDATE
          Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates a SELECT FOR UPDATE SQL statement is supported when the cursor is a dynamic cursor.
static long SQL_CA2_CRC_APPROXIMATE
          Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates an approximate row count is available in the SQL_DIAG_CURSOR_ROW_COUNT diagnostic field when the cursor is a dynamic cursor.
static long SQL_CA2_CRC_EXACT
          Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates the exact row count is available in the SQL_DIAG_CURSOR_ROW_COUNT diagnostic field when the cursor is a dynamic cursor.
static long SQL_CA2_LOCK_CONCURRENCY
          Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates a dynamic cursor that uses the lowest level of locking sufficient to make sure that the row can be updated is supported.
static long SQL_CA2_MAX_ROWS_AFFECTS_ALL
          Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates the SQL_ATTR_MAX_ROWS statement attribute affects SELECT, INSERT, DELETE, and UPDATE statements, and CATALOG result sets, when the cursor is a dynamic cursor.
static long SQL_CA2_MAX_ROWS_CATALOG
          Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates the SQL_ATTR_MAX_ROWS statement attribute affects CATALOG result sets when the cursor is a dynamic cursor.
static long SQL_CA2_MAX_ROWS_DELETE
          Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates the SQL_ATTR_MAX_ROWS statement attribute affects DELETE statements when the cursor is a dynamic cursor.
static long SQL_CA2_MAX_ROWS_INSERT
          Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates the SQL_ATTR_MAX_ROWS statement attribute affects INSERT statements when the cursor is a dynamic cursor.
static long SQL_CA2_MAX_ROWS_SELECT
          Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates the SQL_ATTR_MAX_ROWS statement attribute affects SELECT statements when the cursor is a dynamic cursor.
static long SQL_CA2_MAX_ROWS_UPDATE
          Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates the SQL_ATTR_MAX_ROWS statement attribute affects UPDATE statements when the cursor is a dynamic cursor.
static long SQL_CA2_OPT_ROWVER_CONCURRENCY
          Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates a dynamic cursor that uses the optimistic concurrency control comparing row versions is supported.
static long SQL_CA2_OPT_VALUES_CONCURRENCY
          Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates a dynamic cursor that uses the optimistic concurrency control comparing values is supported.
static long SQL_CA2_READ_ONLY_CONCURRENCY
          Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates a read-only dynamic cursor, in which no updates are allowed, is supported.
static long SQL_CA2_SENSITIVITY_ADDITIONS
          Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates added rows are visible to a dynamic cursor; the cursor can scroll to those rows.
static long SQL_CA2_SENSITIVITY_DELETIONS
          Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates deleted rows are no longer available to a dynamic cursor, and do not leave a "hole" in the result set; after the dynamic cursor scrolls from a deleted row, it cannot return to that row.
static long SQL_CA2_SENSITIVITY_UPDATES
          Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates updates to rows are visible to a dynamic cursor; if the dynamic cursor scrolls from and returns to an updated row, the data returned by the cursor is the updated data, not the original data.
static long SQL_CA2_SIMULATE_NON_UNIQUE
          Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates the driver does not guarantee that simulated positioned update or delete statements will affect only one row when the cursor is a dynamic cursor; it is the application's responsibility to guarantee this.
static long SQL_CA2_SIMULATE_TRY_UNIQUE
          Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates the driver tries to guarantee that simulated positioned update or delete statements will affect only one row when the cursor is a dynamic cursor.
static long SQL_CA2_SIMULATE_UNIQUE
          Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates the driver guarantees that simulated positioned update or delete statements will affect only one row when the cursor is a dynamic cursor.
static long SQL_CB_CLOSE
          A constant specifying how a COMMIT or ROLLBACK operation affects cursors and prepared statements in the data source (the behavior of the data source when you commit a transaction).
static long SQL_CB_DELETE
          A constant specifying how a COMMIT or ROLLBACK operation affects cursors and prepared statements in the data source (the behavior of the data source when you commit a transaction).
static long SQL_CB_NON_NULL
          A constant that indicates how the data source handles the concatenation of NULL valued character data type columns with non-NULL valued character data type columns, specifies results are concatenation of non-NULL valued column or columns.
static long SQL_CB_NULL
          A constant that indicates how the data source handles the concatenation of NULL valued character data type columns with non-NULL valued character data type columns, specifies results are NULL valued.
static long SQL_CB_PRESERVE
          A constant specifying how a COMMIT or ROLLBACK operation affects cursors and prepared statements in the data source (the behavior of the data source when you commit a transaction).
static long SQL_CCOL_CREATE_COLLATION
          Bitmask enumerating the clauses in the CREATE COLLATION statement, as defined in SQL-92, supported by the data source.
static long SQL_CCS_COLLATE_CLAUSE
          Bitmask enumerating the clauses in the CREATE CHARACTER SET statement, as defined in SQL-92, supported by the data source.
static long SQL_CCS_CREATE_CHARACTER_SET
          Bitmask enumerating the clauses in the CREATE CHARACTER SET statement, as defined in SQL-92, supported by the data source.
static long SQL_CCS_LIMITED_COLLATION
          Bitmask enumerating the clauses in the CREATE CHARACTER SET statement, as defined in SQL-92, supported by the data source.
static long SQL_CD_FALSE
          Constant Indicates that the connection is still active, used for DSI_CONN_CONNECTION_DEAD.
static long SQL_CD_TRUE
          Constant Indicates that the connection has been lost, used for DSI_CONN_CONNECTION_DEAD.
static long SQL_CDO_COLLATION
          Bitmask enumerating the clauses in the CREATE DOMAIN statement, as defined in SQL-92, supported by the data source, specifies domain collation is supported.
static long SQL_CDO_CONSTRAINT
          Bitmask enumerating the clauses in the CREATE DOMAIN statement, as defined in SQL-92, supported by the data source, specifies domain defaults is supported.
static long SQL_CDO_CONSTRAINT_DEFERRABLE
          Bitmask enumerating the clauses in the CREATE DOMAIN statement, as defined in SQL-92, supported by the data source.
static long SQL_CDO_CONSTRAINT_INITIALLY_DEFERRED
          Bitmask enumerating the clauses in the CREATE DOMAIN statement, as defined in SQL-92, supported by the data source.
static long SQL_CDO_CONSTRAINT_INITIALLY_IMMEDIATE
          Bitmask enumerating the clauses in the CREATE DOMAIN statement, as defined in SQL-92, supported by the data source.
static long SQL_CDO_CONSTRAINT_NAME_DEFINITION
          Bitmask enumerating the clauses in the CREATE DOMAIN statement, as defined in SQL-92, supported by the data source, specifies <constraint name definition> is supported for naming domain constraints.
static long SQL_CDO_CONSTRAINT_NON_DEFERRABLE
          Bitmask enumerating the clauses in the CREATE DOMAIN statement, as defined in SQL-92, supported by the data source.
static long SQL_CDO_CREATE_DOMAIN
          Bitmask enumerating the clauses in the CREATE DOMAIN statement, as defined in SQL-92, supported by the data source, specifies the CREATE DOMAIN statement is supported.
static long SQL_CDO_DEFAULT
          Bitmask enumerating the clauses in the CREATE DOMAIN statement, as defined in SQL-92, supported by the data source, specifies domain constraints is supported.
static long SQL_CL_END
          Constant specifying the position of the catalog in a qualified table name.
static long SQL_CL_START
          Constant specifying the position of the catalog in a qualified table name.
static long SQL_CN_ANY
          A constant specifying whether the table correlation names are supported, indicates correlation names are supported and can be any valid user-defined name.
static long SQL_CN_DIFFERENT
          A constant specifying whether the table correlation names are supported, indicates correlation names are supported not supported.
static long SQL_CN_NONE
          A constant specifying whether the table correlation names are supported, indicates correlation names are supported but must differ from the names of the tables they represent.
static long SQL_CS_AUTHORIZATION
          Bitmask enumerating the clauses in the CREATE SCHEMA statement, as defined in SQL-92, supported by the data source.
static long SQL_CS_CREATE_SCHEMA
          Bitmask enumerating the clauses in the CREATE SCHEMA statement, as defined in SQL-92, supported by the data source.
static long SQL_CS_DEFAULT_CHARACTER_SET
          Bitmask enumerating the clauses in the CREATE SCHEMA statement, as defined in SQL-92, supported by the data source.
static long SQL_CT_COLUMN_COLLATION
          Bitmask enumerating the clauses in the CREATE TABLE statement, as defined in SQL-92, supported by the data source, specifies column collation is supported.
static long SQL_CT_COLUMN_CONSTRAINT
          Bitmask enumerating the clauses in the CREATE TABLE statement, as defined in SQL-92, supported by the data source, specifies column constraints is supported.
static long SQL_CT_COLUMN_DEFAULT
          Bitmask enumerating the clauses in the CREATE TABLE statement, as defined in SQL-92, supported by the data source, specifies column defaults is supported .
static long SQL_CT_COMMIT_DELETE
          Bitmask enumerating the clauses in the CREATE TABLE statement, as defined in SQL-92, supported by the data source, specifies deleted rows are deleted on commit for temporary tables.
static long SQL_CT_COMMIT_PRESERVE
          Bitmask enumerating the clauses in the CREATE TABLE statement, as defined in SQL-92, supported by the data source, specifies deleted rows are preserved on commit for temporary tables.
static long SQL_CT_CONSTRAINT_DEFERRABLE
          Bitmask enumerating the clauses in the CREATE TABLE statement, as defined in SQL-92, supported by the data source.
static long SQL_CT_CONSTRAINT_INITIALLY_DEFERRED
          Bitmask enumerating the clauses in the CREATE TABLE statement, as defined in SQL-92, supported by the data source.
static long SQL_CT_CONSTRAINT_INITIALLY_IMMEDIATE
          Bitmask enumerating the clauses in the CREATE TABLE statement, as defined in SQL-92, supported by the data source.
static long SQL_CT_CONSTRAINT_NAME_DEFINITION
          Bitmask enumerating the clauses in the CREATE TABLE statement, as defined in SQL-92, supported by the data source, specifies <constraint name definition> clause is supported for naming column and table constraints.
static long SQL_CT_CONSTRAINT_NON_DEFERRABLE
          Bitmask enumerating the clauses in the CREATE TABLE statement, as defined in SQL-92, supported by the data source.
static long SQL_CT_CREATE_TABLE
          Bitmask enumerating the clauses in the CREATE TABLE statement, as defined in SQL-92, supported by the data source, specifies CREATE TABLE statement is supported.
static long SQL_CT_GLOBAL_TEMPORARY
          Bitmask enumerating the clauses in the CREATE TABLE statement, as defined in SQL-92, supported by the data source, specifies global temporary tables can be created.
static long SQL_CT_LOCAL_TEMPORARY
          Bitmask enumerating the clauses in the CREATE TABLE statement, as defined in SQL-92, supported by the data source, specifies local temporary tables can be created.
static long SQL_CT_TABLE_CONSTRAINT
          Bitmask enumerating the clauses in the CREATE TABLE statement, as defined in SQL-92, supported by the data source, specifies table constraints is supported.
static long SQL_CTR_CREATE_TRANSLATION
          Bitmask enumerating the clauses in the CREATE TRANSLATION statement, as defined in SQL-92, supported by the data source.
static long SQL_CU_DML_STATEMENTS
          Bitmask enumerating the statements in which catalogs can be used, indicates catalogs are supported in all Data Manipulation Language statements: SELECT, INSERT, UPDATE, DELETE, and if supported, SELECT FOR UPDATE and positioned update and delete statements.
static long SQL_CU_INDEX_DEFINITION
          Bitmask enumerating the statements in which catalogs can be used, indicates catalogs are supported in all index definition statements: CREATE INDEX and DROP INDEX.
static long SQL_CU_PRIVILEGE_DEFINITION
          Bitmask enumerating the statements in which catalogs can be used, indicates catalogs are supported in all privilege definition statements: GRANT and REVOKE.
static long SQL_CU_PROCEDURE_INVOCATION
          Bitmask enumerating the statements in which catalogs can be used, indicates catalogs are supported in the ODBC procedure invocation statement.
static long SQL_CU_TABLE_DEFINITION
          Bitmask enumerating the statements in which catalogs can be used, indicates catalogs are supported in all table definition statements: CREATE TABLE, CREATE VIEW, ALTER TABLE, DROP TABLE, and DROP VIEW.
static long SQL_CV_CASCADED
          Bitmask enumerating the clauses in the CREATE VIEW statement, as defined in SQL-92, supported by the data source.
static long SQL_CV_CHECK_OPTION
          Bitmask enumerating the clauses in the CREATE VIEW statement, as defined in SQL-92, supported by the data source.
static long SQL_CV_CREATE_VIEW
          Bitmask enumerating the clauses in the CREATE VIEW statement, as defined in SQL-92, supported by the data source.
static long SQL_CV_LOCAL
          Bitmask enumerating the clauses in the CREATE VIEW statement, as defined in SQL-92, supported by the data source.
static long SQL_CVT_BIGINT
          Bitmask enumerating the conversions supported by the data source with the CONVERT scalar function for data of the type named in the InfoType, indicates conversions to BIGINT are supported.
static long SQL_CVT_BINARY
          Bitmask enumerating the conversions supported by the data source with the CONVERT scalar function for data of the type named in the InfoType, indicates conversions to binary are supported.
static long SQL_CVT_BIT
          Bitmask enumerating the conversions supported by the data source with the CONVERT scalar function for data of the type named in the InfoType, indicates conversions to bit are supported.
static long SQL_CVT_CHAR
          Bitmask enumerating the conversions supported by the data source with the CONVERT scalar function for data of the type named in the InfoType, indicates conversions to char are supported.
static long SQL_CVT_DATE
          Bitmask enumerating the conversions supported by the data source with the CONVERT scalar function for data of the type named in the InfoType, indicates conversions to date are supported.
static long SQL_CVT_DECIMAL
          Bitmask enumerating the conversions supported by the data source with the CONVERT scalar function for data of the type named in the InfoType, indicates conversions to decimal are supported.
static long SQL_CVT_DOUBLE
          Bitmask enumerating the conversions supported by the data source with the CONVERT scalar function for data of the type named in the InfoType, indicates conversions to double are supported.
static long SQL_CVT_FLOAT
          Bitmask enumerating the conversions supported by the data source with the CONVERT scalar function for data of the type named in the InfoType, indicates conversions to float are supported.
static long SQL_CVT_GUID
          Bitmask enumerating the conversions supported by the data source with the CONVERT scalar function for data of the type named in the InfoType, indicates conversions to GUID are supported.
static long SQL_CVT_INTEGER
          Bitmask enumerating the conversions supported by the data source with the CONVERT scalar function for data of the type named in the InfoType, indicates conversions to integer are supported.
static long SQL_CVT_INTERVAL_DAY_TIME
          Bitmask enumerating the conversions supported by the data source with the CONVERT scalar function for data of the type named in the InfoType, indicates conversions to interval day time are supported.
static long SQL_CVT_INTERVAL_YEAR_MONTH
          Bitmask enumerating the conversions supported by the data source with the CONVERT scalar function for data of the type named in the InfoType, indicates conversions to interval year month are supported.
static long SQL_CVT_LONGVARBINARY
          Bitmask enumerating the conversions supported by the data source with the CONVERT scalar function for data of the type named in the InfoType, indicates conversions to long varbinary are supported.
static long SQL_CVT_LONGVARCHAR
          Bitmask enumerating the conversions supported by the data source with the CONVERT scalar function for data of the type named in the InfoType, indicates conversions to long varchar are supported.
static long SQL_CVT_NUMERIC
          Bitmask enumerating the conversions supported by the data source with the CONVERT scalar function for data of the type named in the InfoType, indicates conversions to numeric are supported.
static long SQL_CVT_REAL
          Bitmask enumerating the conversions supported by the data source with the CONVERT scalar function for data of the type named in the InfoType, indicates conversions to real are supported.
static long SQL_CVT_SMALLINT
          Bitmask enumerating the conversions supported by the data source with the CONVERT scalar function for data of the type named in the InfoType, indicates conversions to smallint are supported.
static long SQL_CVT_TIME
          Bitmask enumerating the conversions supported by the data source with the CONVERT scalar function for data of the type named in the InfoType, indicates conversions to time are supported.
static long SQL_CVT_TIMESTAMP
          Bitmask enumerating the conversions supported by the data source with the CONVERT scalar function for data of the type named in the InfoType, indicates conversions to timestamp are supported.
static long SQL_CVT_TINYINT
          Bitmask enumerating the conversions supported by the data source with the CONVERT scalar function for data of the type named in the InfoType, indicates conversions to tiny int are supported.
static long SQL_CVT_VARBINARY
          Bitmask enumerating the conversions supported by the data source with the CONVERT scalar function for data of the type named in the InfoType, indicates conversions to varbinary are supported.
static long SQL_CVT_VARCHAR
          Bitmask enumerating the conversions supported by the data source with the CONVERT scalar function for data of the type named in the InfoType, indicates conversions to varchar are supported.
static long SQL_CVT_WCHAR
          Bitmask enumerating the conversions supported by the data source with the CONVERT scalar function for data of the type named in the InfoType, indicates conversions to wchar are supported.
static long SQL_CVT_WLONGVARCHAR
          Bitmask enumerating the conversions supported by the data source with the CONVERT scalar function for data of the type named in the InfoType, indicates conversions to long wvarchar are supported.
static long SQL_CVT_WVARCHAR
          Bitmask enumerating the conversions supported by the data source with the CONVERT scalar function for data of the type named in the InfoType, indicates conversions to wvarchar are supported.
static long SQL_DA_DROP_ASSERTION
          Bitmask enumerating the clauses in the DROP ASSERTION statement, as defined in SQL-92, supported by the data source.
static long SQL_DC_DROP_COLLATION
          Bitmask enumerating the clauses in the DROP COLLATION statement, as defined in SQL-92, supported by the data source.
static long SQL_DCS_DROP_CHARACTER_SET
          Bitmask enumerating the clauses in the DROP CHARACTER SET statement, as defined in SQL-92, supported by the data source.
static long SQL_DD_CASCADE
          Bitmask enumerating the clauses in the DROP DOMAIN statement, as defined in SQL-92, supported by the data source.
static long SQL_DD_DROP_DOMAIN
          Bitmask enumerating the clauses in the DROP DOMAIN statement, as defined in SQL-92, supported by the data source.
static long SQL_DD_RESTRICT
          Bitmask enumerating the clauses in the DROP DOMAIN statement, as defined in SQL-92, supported by the data source.
static long SQL_DI_CREATE_INDEX
          A constant specifying support for creation and dropping of indexes.
static long SQL_DI_DROP_INDEX
          A constant specifying support for creation and dropping of indexes.
static long SQL_DS_CASCADE
          Bitmask enumerating the clauses in the DROP SCHEMA statement, as defined in SQL-92, supported by the data source.
static long SQL_DS_DROP_SCHEMA
          Bitmask enumerating the clauses in the DROP SCHEMA statement, as defined in SQL-92, supported by the data source.
static long SQL_DS_RESTRICT
          Bitmask enumerating the clauses in the DROP SCHEMA statement, as defined in SQL-92, supported by the data source.
static long SQL_DT_CASCADE
          Bitmask enumerating the clauses in the DROP TABLE statement, as defined in SQL-92, supported by the data source.
static long SQL_DT_DROP_TABLE
          Bitmask enumerating the clauses in the DROP TABLE statement, as defined in SQL-92, supported by the data source.
static long SQL_DT_RESTRICT
          Bitmask enumerating the clauses in the DROP TABLE statement, as defined in SQL-92, supported by the data source.
static long SQL_DTR_DROP_TRANSLATION
          Bitmask enumerating the clauses in the DROP TRANSLATION statement, as defined in SQL-92, supported by the data source.
static long SQL_DV_CASCADE
          Bitmask enumerating the clauses in the DROP VIEW statement, as defined in SQL-92, supported by the data source.
static long SQL_DV_DROP_VIEW
          Bitmask enumerating the clauses in the DROP VIEW statement, as defined in SQL-92, supported by the data source.
static long SQL_DV_RESTRICT
          Bitmask enumerating the clauses in the DROP VIEW statement, as defined in SQL-92, supported by the data source.
static int SQL_FALSE
          Constant indicating a false condition.
static char SQL_FILE_CATALOG
          A constant specifying how a single-tier driver directly treats files in a data source, indicates single-tier driver treats files in a data source as a catalog.
static char SQL_FILE_NOT_SUPPORTED
          A constant specifying how a single-tier driver directly treats files in a data source, indicates driver is not a single-tier driver.
static char SQL_FILE_TABLE
          A constant specifying how a single-tier driver directly treats files in a data source, indicates single-tier driver treats files in a data source as tables.
static long SQL_FN_CVT_CAST
          Bitmask enumerating the scalar conversion functions supported by the driver and associated data source.
static long SQL_FN_CVT_CONVERT
          Bitmask enumerating the scalar conversion functions supported by the driver and associated data source.
static long SQL_FN_NUM_ABS
          Bitmask enumerating the scalar numeric functions supported by the driver and associated data source.
static long SQL_FN_NUM_ACOS
          Bitmask enumerating the scalar numeric functions supported by the driver and associated data source.
static long SQL_FN_NUM_ASIN
          Bitmask enumerating the scalar numeric functions supported by the driver and associated data source.
static long SQL_FN_NUM_ATAN
          Bitmask enumerating the scalar numeric functions supported by the driver and associated data source.
static long SQL_FN_NUM_ATAN2
          Bitmask enumerating the scalar numeric functions supported by the driver and associated data source.
static long SQL_FN_NUM_CEILING
          Bitmask enumerating the scalar numeric functions supported by the driver and associated data source.
static long SQL_FN_NUM_COS
          Bitmask enumerating the scalar numeric functions supported by the driver and associated data source.
static long SQL_FN_NUM_COT
          Bitmask enumerating the scalar numeric functions supported by the driver and associated data source.
static long SQL_FN_NUM_DEGREES
          Bitmask enumerating the scalar numeric functions supported by the driver and associated data source.
static long SQL_FN_NUM_EXP
          Bitmask enumerating the scalar numeric functions supported by the driver and associated data source.
static long SQL_FN_NUM_FLOOR
          Bitmask enumerating the scalar numeric functions supported by the driver and associated data source.
static long SQL_FN_NUM_LOG
          Bitmask enumerating the scalar numeric functions supported by the driver and associated data source.
static long SQL_FN_NUM_LOG10
          Bitmask enumerating the scalar numeric functions supported by the driver and associated data source.
static long SQL_FN_NUM_MOD
          Bitmask enumerating the scalar numeric functions supported by the driver and associated data source.
static long SQL_FN_NUM_PI
          Bitmask enumerating the scalar numeric functions supported by the driver and associated data source.
static long SQL_FN_NUM_POWER
          Bitmask enumerating the scalar numeric functions supported by the driver and associated data source.
static long SQL_FN_NUM_RADIANS
          Bitmask enumerating the scalar numeric functions supported by the driver and associated data source.
static long SQL_FN_NUM_RAND
          Bitmask enumerating the scalar numeric functions supported by the driver and associated data source.
static long SQL_FN_NUM_ROUND
          Bitmask enumerating the scalar numeric functions supported by the driver and associated data source.
static long SQL_FN_NUM_SIGN
          Bitmask enumerating the scalar numeric functions supported by the driver and associated data source.
static long SQL_FN_NUM_SIN
          Bitmask enumerating the scalar numeric functions supported by the driver and associated data source.
static long SQL_FN_NUM_SQRT
          Bitmask enumerating the scalar numeric functions supported by the driver and associated data source.
static long SQL_FN_NUM_TAN
          Bitmask enumerating the scalar numeric functions supported by the driver and associated data source.
static long SQL_FN_NUM_TRUNCATE
          Bitmask enumerating the scalar numeric functions supported by the driver and associated data source.
static long SQL_FN_STR_ASCII
          Bitmask enumerating the scalar string functions supported by the driver and associated data source.
static long SQL_FN_STR_BIT_LENGTH
          Bitmask enumerating the scalar string functions supported by the driver and associated data source.
static long SQL_FN_STR_CHAR
          Bitmask enumerating the scalar string functions supported by the driver and associated data source.
static long SQL_FN_STR_CHAR_LENGTH
          Bitmask enumerating the scalar string functions supported by the driver and associated data source.
static long SQL_FN_STR_CHARACTER_LENGTH
          Bitmask enumerating the scalar string functions supported by the driver and associated data source.
static long SQL_FN_STR_CONCAT
          Bitmask enumerating the scalar string functions supported by the driver and associated data source.
static long SQL_FN_STR_DIFFERENCE
          Bitmask enumerating the scalar string functions supported by the driver and associated data source.
static long SQL_FN_STR_INSERT
          Bitmask enumerating the scalar string functions supported by the driver and associated data source.
static long SQL_FN_STR_LCASE
          Bitmask enumerating the scalar string functions supported by the driver and associated data source.
static long SQL_FN_STR_LEFT
          Bitmask enumerating the scalar string functions supported by the driver and associated data source.
static long SQL_FN_STR_LENGTH
          Bitmask enumerating the scalar string functions supported by the driver and associated data source.
static long SQL_FN_STR_LOCATE
          Bitmask enumerating the scalar string functions supported by the driver and associated data source.
static long SQL_FN_STR_LOCATE_2
          Bitmask enumerating the scalar string functions supported by the driver and associated data source.
static long SQL_FN_STR_LTRIM
          Bitmask enumerating the scalar string functions supported by the driver and associated data source.
static long SQL_FN_STR_OCTET_LENGTH
          Bitmask enumerating the scalar string functions supported by the driver and associated data source.
static long SQL_FN_STR_POSITION
          Bitmask enumerating the scalar string functions supported by the driver and associated data source.
static long SQL_FN_STR_REPEAT
          Bitmask enumerating the scalar string functions supported by the driver and associated data source.
static long SQL_FN_STR_REPLACE
          Bitmask enumerating the scalar string functions supported by the driver and associated data source.
static long SQL_FN_STR_RIGHT
          Bitmask enumerating the scalar string functions supported by the driver and associated data source.
static long SQL_FN_STR_RTRIM
          Bitmask enumerating the scalar string functions supported by the driver and associated data source.
static long SQL_FN_STR_SOUNDEX
          Bitmask enumerating the scalar string functions supported by the driver and associated data source.
static long SQL_FN_STR_SPACE
          Bitmask enumerating the scalar string functions supported by the driver and associated data source.
static long SQL_FN_STR_SUBSTRING
          Bitmask enumerating the scalar string functions supported by the driver and associated data source.
static long SQL_FN_STR_UCASE
          Bitmask enumerating the scalar string functions supported by the driver and associated data source.
static long SQL_FN_SYS_DBNAME
          Bitmask enumerating the timestamp intervals supported by the driver and associated data source for the scalar function.
static long SQL_FN_SYS_IFNULL
          Bitmask enumerating the timestamp intervals supported by the driver and associated data source for the scalar function.
static long SQL_FN_SYS_USERNAME
          Bitmask enumerating the timestamp intervals supported by the driver and associated data source for the scalar function.
static long SQL_FN_TD_CURDATE
          Bitmask enumerating the scalar date and time functions supported by the driver and associated data source.
static long SQL_FN_TD_CURRENT_DATE
          Bitmask enumerating the scalar date and time functions supported by the driver and associated data source.
static long SQL_FN_TD_CURRENT_TIME
          Bitmask enumerating the scalar date and time functions supported by the driver and associated data source.
static long SQL_FN_TD_CURRENT_TIMESTAMP
          Bitmask enumerating the scalar date and time functions supported by the driver and associated data source.
static long SQL_FN_TD_CURTIME
          Bitmask enumerating the scalar date and time functions supported by the driver and associated data source.
static long SQL_FN_TD_DAYNAME
          Bitmask enumerating the scalar date and time functions supported by the driver and associated data source.
static long SQL_FN_TD_DAYOFMONTH
          Bitmask enumerating the scalar date and time functions supported by the driver and associated data source.
static long SQL_FN_TD_DAYOFWEEK
          Bitmask enumerating the scalar date and time functions supported by the driver and associated data source.
static long SQL_FN_TD_DAYOFYEAR
          Bitmask enumerating the scalar date and time functions supported by the driver and associated data source.
static long SQL_FN_TD_EXTRACT
          Bitmask enumerating the scalar date and time functions supported by the driver and associated data source.
static long SQL_FN_TD_HOUR
          Bitmask enumerating the scalar date and time functions supported by the driver and associated data source.
static long SQL_FN_TD_MINUTE
          Bitmask enumerating the scalar date and time functions supported by the driver and associated data source.
static long SQL_FN_TD_MONTH
          Bitmask enumerating the scalar date and time functions supported by the driver and associated data source.
static long SQL_FN_TD_MONTHNAME
          Bitmask enumerating the scalar date and time functions supported by the driver and associated data source.
static long SQL_FN_TD_NOW
          Bitmask enumerating the scalar date and time functions supported by the driver and associated data source.
static long SQL_FN_TD_QUARTER
          Bitmask enumerating the scalar date and time functions supported by the driver and associated data source.
static long SQL_FN_TD_SECOND
          Bitmask enumerating the scalar date and time functions supported by the driver and associated data source.
static long SQL_FN_TD_TIMESTAMPADD
          Bitmask enumerating the scalar date and time functions supported by the driver and associated data source.
static long SQL_FN_TD_TIMESTAMPDIFF
          Bitmask enumerating the scalar date and time functions supported by the driver and associated data source.
static long SQL_FN_TD_WEEK
          Bitmask enumerating the scalar date and time functions supported by the driver and associated data source.
static long SQL_FN_TD_YEAR
          Bitmask enumerating the scalar date and time functions supported by the driver and associated data source.
static long SQL_FN_TSI_DAY
          Bitmask enumerating the timestamp intervals supported by the driver and associated data source for the scalar function.
static long SQL_FN_TSI_FRAC_SECOND
          Bitmask enumerating the timestamp intervals supported by the driver and associated data source for the scalar function.
static long SQL_FN_TSI_HOUR
          Bitmask enumerating the timestamp intervals supported by the driver and associated data source for the scalar function.
static long SQL_FN_TSI_MINUTE
          Bitmask enumerating the timestamp intervals supported by the driver and associated data source for the scalar function.
static long SQL_FN_TSI_MONTH
          Bitmask enumerating the timestamp intervals supported by the driver and associated data source for the scalar function.
static long SQL_FN_TSI_QUARTER
          Bitmask enumerating the timestamp intervals supported by the driver and associated data source for the scalar function.
static long SQL_FN_TSI_SECOND
          Bitmask enumerating the timestamp intervals supported by the driver and associated data source for the scalar function.
static long SQL_FN_TSI_WEEK
          Bitmask enumerating the timestamp intervals supported by the driver and associated data source for the scalar function.
static long SQL_FN_TSI_YEAR
          Bitmask enumerating the timestamp intervals supported by the driver and associated data source for the scalar function.
static long SQL_GB_COLLATE
          A constant specifying the relationship between the columns in the GROUP BY clause and the nonaggregated columns in the select list, indicates a COLLATE clause can be specified at the end of each grouping column.
static long SQL_GB_GROUP_BY_CONTAINS_SELECT
          A constant specifying the relationship between the columns in the GROUP BY clause and the nonaggregated columns in the select list, indicates the GROUP BY clause must contain all nonaggregated columns in the select list.
static long SQL_GB_GROUP_BY_EQUALS_SELECT
          A constant specifying the relationship between the columns in the GROUP BY clause and the nonaggregated columns in the select list, indicates the GROUP BY clause must contain all nonaggregated columns in the select list.
static long SQL_GB_NO_RELATION
          A constant specifying the relationship between the columns in the GROUP BY clause and the nonaggregated columns in the select list, indicates the columns in the GROUP BY clause and the select list are not related.
static long SQL_GB_NOT_SUPPORTED
          A constant specifying the relationship between the columns in the GROUP BY clause and the nonaggregated columns in the select list, indicates GROUP BY clauses are not supported.
static char SQL_IC_LOWER
          A constant specifying identifiers in SQL are not case-sensitive and are stored in lowercase in system catalog.
static char SQL_IC_MIXED
          A constant specifying identifiers in SQL are not case-sensitive and are stored in mixed case in system catalog.
static char SQL_IC_SENSITIVE
          A constant specifying identifiers in SQL are case sensitive and are stored in mixed case in system catalog.
static char SQL_IC_UPPER
          A constant specifying identifiers in SQL are not case-sensitive and are stored in uppercase in system catalog.
static long SQL_IK_ALL
          Bitmask enumerates keywords in the CREATE INDEX statement that are supported by the driver, indicates all keywords are supported.
static long SQL_IK_ASC
          Bitmask enumerates keywords in the CREATE INDEX statement that are supported by the driver, indicates ASC keyword is supported.
static long SQL_IK_DESC
          Bitmask enumerates keywords in the CREATE INDEX statement that are supported by the driver, indicates DESC keyword is supported Used for DSI_INDEX_KEYWORDS.
static long SQL_IK_NONE
          Bitmask enumerates keywords in the CREATE INDEX statement that are supported by the driver, indicates non of the keywords are supported.
static long SQL_INSENSITIVE
          A constant specifying the support for cursor sensitivity, indicating all cursors on the statement handle show the result set without reflecting any changes that were made to it by any other cursor within the same transaction.
static long SQL_IS_INSERT_LITERALS
          Bitmask enumerating support for INSERT statements.
static long SQL_IS_INSERT_SEARCHED
          Bitmask enumerating support for INSERT statements.
static long SQL_IS_SELECT_INTO
          Bitmask enumerating support for INSERT statements.
static long SQL_ISV_ASSERTIONS
          Bitmask enumerating the views in the INFORMATION_SCHEMA that are supported by the driver, indicates the catalog's assertions that are owned by a given user.
static long SQL_ISV_CHARACTER_SETS
          Bitmask enumerating the views in the INFORMATION_SCHEMA that are supported by the driver, indicates the catalog's character sets that can be accessed by a given user.
static long SQL_ISV_CHECK_CONSTRAINTS
          Bitmask enumerating the views in the INFORMATION_SCHEMA that are supported by the driver, indicates the CHECK constraints that are owned by a given user.
static long SQL_ISV_COLLATIONS
          Bitmask enumerating the views in the INFORMATION_SCHEMA that are supported by the driver, indicates the character collations for the catalog that can be accessed by a given user.
static long SQL_ISV_COLUMN_DOMAIN_USAGE
          Bitmask enumerating the views in the INFORMATION_SCHEMA that are supported by the driver, indicates columns for the catalog that depend on domains defined in the catalog and are owned by a given user.
static long SQL_ISV_COLUMN_PRIVILEGES
          Bitmask enumerating the views in the INFORMATION_SCHEMA that are supported by the driver, indicates the privileges on columns of persistent tables that are available to or granted by a given user.
static long SQL_ISV_COLUMNS
          Bitmask enumerating the views in the INFORMATION_SCHEMA that are supported by the driver, indicates the columns of persistent tables that can be accessed by a given user.
static long SQL_ISV_CONSTRAINT_COLUMN_USAGE
          Bitmask enumerating the views in the INFORMATION_SCHEMA that are supported by the driver, indicates columns are identified for the various constraints that are owned by a given user.
static long SQL_ISV_CONSTRAINT_TABLE_USAGE
          Bitmask enumerating the views in the INFORMATION_SCHEMA that are supported by the driver, indicates the tables that are used by constraints (referential, unique, and assertions), and are owned by a given user.
static long SQL_ISV_DOMAIN_CONSTRAINTS
          Bitmask enumerating the views in the INFORMATION_SCHEMA that are supported by the driver, indicates the domain constraints (of the domains in the catalog) that can be accessed by a given user.
static long SQL_ISV_DOMAINS
          Bitmask enumerating the views in the INFORMATION_SCHEMA that are supported by the driver, indicates the domains defined in a catalog that can be accessed by the user.
static long SQL_ISV_KEY_COLUMN_USAGE
          Bitmask enumerating the views in the INFORMATION_SCHEMA that are supported by the driver, indicates columns defined in the catalog that are constrained as keys by a given user.
static long SQL_ISV_REFERENTIAL_CONSTRAINTS
          Bitmask enumerating the views in the INFORMATION_SCHEMA that are supported by the driver, indicates the referential constraints that are owned by a given user.
static long SQL_ISV_SCHEMATA
          Bitmask enumerating the views in the INFORMATION_SCHEMA that are supported by the driver, indicates the schemas that are owned by a given user.
static long SQL_ISV_SQL_LANGUAGES
          Bitmask enumerating the views in the INFORMATION_SCHEMA that are supported by the driver, indicates the SQL conformance levels, options, and dialects supported by the SQL implementation.
static long SQL_ISV_TABLE_CONSTRAINTS
          Bitmask enumerating the views in the INFORMATION_SCHEMA that are supported by the driver, indicates the table constraints that are owned by a given user.
static long SQL_ISV_TABLE_PRIVILEGES
          Bitmask enumerating the views in the INFORMATION_SCHEMA that are supported by the driver, indicates the privileges on persistent tables that are available to or granted by a given user.
static long SQL_ISV_TABLES
          Bitmask enumerating the views in the INFORMATION_SCHEMA that are supported by the driver, indicates the persistent tables defined in a catalog that can be accessed by a given user.
static long SQL_ISV_TRANSLATIONS
          Bitmask enumerating the views in the INFORMATION_SCHEMA that are supported by the driver, indicates character translations for the catalog that can be accessed by a given user.
static long SQL_ISV_USAGE_PRIVILEGES
          Bitmask enumerating the views in the INFORMATION_SCHEMA that are supported by the driver, indicates the USAGE privileges on catalog objects that are available to or owned by a given user.
static long SQL_ISV_VIEW_COLUMN_USAGE
          Bitmask enumerating the views in the INFORMATION_SCHEMA that are supported by the driver, indicates the columns on which the catalog's views that are owned by a given user are dependent.
static long SQL_ISV_VIEW_TABLE_USAGE
          Bitmask enumerating the views in the INFORMATION_SCHEMA that are supported by the driver, indicates the tables on which the catalog's views that are owned by a given user are dependent.
static long SQL_ISV_VIEWS
          Bitmask enumerating the views in the INFORMATION_SCHEMA that are supported by the driver, indicates the viewed tables defined in this catalog that can be accessed by a given user.
static long SQL_MAX_LENGTH_DEFAULT
          A constant specifying the default maximum amount of data that the driver returns from a character or binary column, which is defined to be 0 for the driver to return all data.
static long SQL_MAX_ROWS_DEFAULT
          A constant specifying the default maximum number of rows to return to the application for a SELECT statement, which is defined to be 0 for driver to return all rows.
static long SQL_MODE_READ_ONLY
          A constant that indicates that the connection is not required to support SQL statements that cause updates to occur.
static long SQL_MODE_READ_WRITE
          A constant that indicates that the connection is required to support SQL statements that cause updates to occur.
static long SQL_NC_END
          A constant specifying where NULLs are sorted in a result set, indicates NULLs are sorted at the end of the result set, regardless of the ASC or DESC keywords.
static long SQL_NC_HIGH
          A constant specifying where NULLs are sorted in a result set, indicates NULLs are sorted at the high end of the result set, depending on the ASC or DESC keywords.
static long SQL_NC_LOW
          A constant specifying where NULLs are sorted in a result set, indicates NULLs are sorted at the low end of the result set, depending on the ASC or DESC keywords.
static long SQL_NC_START
          A constant specifying where NULLs are sorted in a result set, indicates NULLs are sorted at the start of the result set, regardless of the ASC or DESC keywords.
static long SQL_NNC_NON_NULL
          A constant specifying whether the data source supports NOT NULL in columns, indicates columns cannot be nullable.
static long SQL_NNC_NULL
          A constant specifying whether the data source supports NOT NULL in columns, indicates all columns must be nullable.
static long SQL_NS_OFF
          A constant specifying that the driver scans SQL strings for escape sequences.
static long SQL_NS_ON
          A constant specifying that the driver does not scan SQL strings for escape sequences.
static long SQL_OIC_CORE
          A constant specifying the level of the ODBC 3.x interface that the driver complies with, indicates minimum level that all ODBC drivers are expected to comply with.
static long SQL_OIC_LEVEL1
          A constant specifying the level of the ODBC 3.x interface that the driver complies with, indicates level including the core standards compliance level functionality, plus scrollable cursors, bookmarks, positioned updates and deletes, and so on.
static long SQL_OIC_LEVEL2
          A constant specifying the level of the ODBC 3.x interface that the driver complies with, indicates level including level 1 standards compliance level functionality, plus advanced features such as sensitive cursors; update, delete, and refresh by bookmarks; stored procedure support; catalog functions for primary and foreign keys; multi-catalog support; and so on.
static long SQL_OJ_ALL_COMPARISON_OPS
          Bitmask enumerating the types of outer joins supported by the driver and data source, indicates the comparison operator in the ON clause can be any of the ODBC comparison operators.
static long SQL_OJ_FULL
          Bitmask enumerating the types of outer joins supported by the driver and data source, indicates full outer joins are supported.
static long SQL_OJ_INNER
          Bitmask enumerating the types of outer joins supported by the driver and data source, indicates the inner table (the right table in a left outer join or the left table in a right outer join) can also be used in an inner join.
static long SQL_OJ_LEFT
          Bitmask enumerating the types of outer joins supported by the driver and data source, indicates left outer joins are supported.
static long SQL_OJ_NESTED
          Bitmask enumerating the types of outer joins supported by the driver and data source, indicates nested outer joins are supported.
static long SQL_OJ_NOT_ORDERED
          Bitmask enumerating the types of outer joins supported by the driver and data source, indicates the column names in the ON clause of the outer join do not have to be in the same order as their respective table names in the OUTER JOIN clause.
static long SQL_OJ_RIGHT
          Bitmask enumerating the types of outer joins supported by the driver and data source, indicates right outer joins are supported.
static short SQL_OSC_CORE
          A Constant specifying SQL grammar supported by the driver, indicates core grammar supported.
static short SQL_OSC_EXTENDED
          A Constant specifying SQL grammar supported by the driver, indicates extended grammar supported.
static short SQL_OSC_MINIMUM
          A Constant specifying SQL grammar supported by the driver, indicates minimum grammar supported.
static long SQL_PARC_BATCH
          A constant specifying the driver's properties regarding the availability of row counts in a parameterized execution, indicates individual row counts are available for each set of parameters.
static long SQL_PARC_NO_BATCH
          A constant specifying the driver's properties regarding the availability of row counts in a parameterized execution, indicates there is only one row count available, which is the cumulative row count resulting from the execution of the statement for the entire array of parameters.
static long SQL_PAS_BATCH
          A constant specifying the driver's properties regarding the availability of result sets in a parameterized execution, indicates there is one result set available per set of parameters.
static long SQL_PAS_NO_BATCH
          A constant specifying the driver's properties regarding the availability of result sets in a parameterized execution, indicates there is only one result set available, which represents the cumulative result set resulting from the execution of the statement for the complete array of parameters.
static long SQL_PAS_NO_SELECT
          A constant specifying the driver's properties regarding the availability of result sets in a parameterized execution, indicates driver does not allow a result-set generating statement to be executed with an array of parameters.
static long SQL_QUERY_TIMEOUT_DEFAULT
          A constant specifying the default number of seconds to wait for an SQL statement to execute before returning to the application, which is defined to be 0 for no timeout.
static long SQL_RC_DELETE_ANY
          A valid bitmask for SQL_CONN_RETURN_ESCAPE_CLAUSE.
static long SQL_RC_DELETE_ROWID
          A valid bitmask for SQL_CONN_RETURN_ESCAPE_CLAUSE.
static long SQL_RC_INSERT_MULTIPLE_ANY
          A valid bitmask for SQL_CONN_RETURN_ESCAPE_CLAUSE.
static long SQL_RC_INSERT_MULTIPLE_ROWID
          A valid bitmask for SQL_CONN_RETURN_ESCAPE_CLAUSE.
static long SQL_RC_INSERT_SELECT_ANY
          A valid bitmask for SQL_CONN_RETURN_ESCAPE_CLAUSE.
static long SQL_RC_INSERT_SELECT_ROWID
          A valid bitmask for SQL_CONN_RETURN_ESCAPE_CLAUSE.
static long SQL_RC_INSERT_SINGLE_ANY
          A valid bitmask for SQL_CONN_RETURN_ESCAPE_CLAUSE.
static long SQL_RC_INSERT_SINGLE_ROWID
          A valid bitmask for SQL_CONN_RETURN_ESCAPE_CLAUSE.
static long SQL_RC_SELECT_INTO_ANY
          A valid bitmask for SQL_CONN_RETURN_ESCAPE_CLAUSE.
static long SQL_RC_SELECT_INTO_ROWID
          A valid bitmask for SQL_CONN_RETURN_ESCAPE_CLAUSE.
static long SQL_RC_UPDATE_ANY
          A valid bitmask for SQL_CONN_RETURN_ESCAPE_CLAUSE.
static long SQL_RC_UPDATE_ROWID
          A valid bitmask for SQL_CONN_RETURN_ESCAPE_CLAUSE.
static long SQL_RD_OFF
          A constant specifying the that the cursor does not retrieve data after it is positioned.
static long SQL_RD_ON
          A constant specifying the that the cursor retrieves data after it is positioned.
static short SQL_REFRESH_AUTO
          SQL Value to indicate what type of OAuth token refreshing should happen.
static short SQL_REFRESH_MANUAL
          SQL Value to indicate what type of OAuth token refreshing should happen.
static short SQL_REFRESH_NOW
          SQL Value to indicate what type of OAuth token refreshing should happen.
static long SQL_SC_FIPS127_2_TRANSITIONAL
          A constant specifying the level of SQL-92 supported by the driver, indicates FIPS 127-2 transitional level compliant.
static long SQL_SC_SQL92_ENTRY
          A constant specifying the level of SQL-92 supported by the driver, indicates entry level SQL-92 compliant.
static long SQL_SC_SQL92_FULL
          A constant specifying the level of SQL-92 supported by the driver, indicates full level SQL-92 compliant.
static long SQL_SC_SQL92_INTERMEDIATE
          A constant specifying the level of SQL-92 supported by the driver, indicates intermediate level SQL-92 compliant.
static long SQL_SCC_ISO92_CLI
          Bitmask enumerating the CLI standard or standards to which the driver conforms, indicates driver complies with the ISO 92 CLI.
static long SQL_SCC_XOPEN_CLI_VERSION1
          Bitmask enumerating the CLI standard or standards to which the driver conforms, indicates driver complies with the X/Open CLI version 1.
static long SQL_SDF_CURRENT_DATE
          Bitmask enumerating the datetime scalar functions that are supported by the driver and the associated data source, as defined in SQL-92.
static long SQL_SDF_CURRENT_TIME
          Bitmask enumerating the datetime scalar functions that are supported by the driver and the associated data source, as defined in SQL-92.
static long SQL_SDF_CURRENT_TIMESTAMP
          Bitmask enumerating the datetime scalar functions that are supported by the driver and the associated data source, as defined in SQL-92.
static long SQL_SENSITIVE
          A constant specifying the support for cursor sensitivity, indicating cursors are sensitive to changes that were made by other cursors within the same transaction.
static long SQL_SFKD_CASCADE
          Bitmask enumerating the rules supported for a foreign key in a DELETE statement, as defined in SQL-92.
static long SQL_SFKD_NO_ACTION
          Bitmask enumerating the rules supported for a foreign key in a DELETE statement, as defined in SQL-92.
static long SQL_SFKD_SET_DEFAULT
          Bitmask enumerating the rules supported for a foreign key in a DELETE statement, as defined in SQL-92.
static long SQL_SFKD_SET_NULL
          Bitmask enumerating the rules supported for a foreign key in a DELETE statement, as defined in SQL-92.
static long SQL_SFKU_CASCADE
          Bitmask enumerating the rules supported for a foreign key in an UPDATE statement, as defined in SQL-92.
static long SQL_SFKU_NO_ACTION
          Bitmask enumerating the rules supported for a foreign key in an UPDATE statement, as defined in SQL-92.
static long SQL_SFKU_SET_DEFAULT
          Bitmask enumerating the rules supported for a foreign key in an UPDATE statement, as defined in SQL-92.
static long SQL_SFKU_SET_NULL
          Bitmask enumerating the rules supported for a foreign key in an UPDATE statement, as defined in SQL-92.
static long SQL_SG_DELETE_TABLE
          Bitmask enumerating the clauses supported in the GRANT statement, as defined in SQL-92.
static long SQL_SG_INSERT_COLUMN
          Bitmask enumerating the clauses supported in the GRANT statement, as defined in SQL-92.
static long SQL_SG_INSERT_TABLE
          Bitmask enumerating the clauses supported in the GRANT statement, as defined in SQL-92.
static long SQL_SG_REFERENCES_COLUMN
          Bitmask enumerating the clauses supported in the GRANT statement, as defined in SQL-92.
static long SQL_SG_REFERENCES_TABLE
          Bitmask enumerating the clauses supported in the GRANT statement, as defined in SQL-92.
static long SQL_SG_SELECT_TABLE
          Bitmask enumerating the clauses supported in the GRANT statement, as defined in SQL-92.
static long SQL_SG_UPDATE_COLUMN
          Bitmask enumerating the clauses supported in the GRANT statement, as defined in SQL-92.
static long SQL_SG_UPDATE_TABLE
          Bitmask enumerating the clauses supported in the GRANT statement, as defined in SQL-92.
static long SQL_SG_USAGE_ON_CHARACTER_SET
          Bitmask enumerating the clauses supported in the GRANT statement, as defined in SQL-92.
static long SQL_SG_USAGE_ON_COLLATION
          Bitmask enumerating the clauses supported in the GRANT statement, as defined in SQL-92.
static long SQL_SG_USAGE_ON_DOMAIN
          Bitmask enumerating the clauses supported in the GRANT statement, as defined in SQL-92.
static long SQL_SG_USAGE_ON_TRANSLATION
          Bitmask enumerating the clauses supported in the GRANT statement, as defined in SQL-92.
static long SQL_SG_WITH_GRANT_OPTION
          Bitmask enumerating the clauses supported in the GRANT statement, as defined in SQL-92.
static long SQL_SNVF_BIT_LENGTH
          Bitmask enumerating the numeric value scalar functions that are supported by the driver and the associated data source, as defined in SQL-92.
static long SQL_SNVF_CHAR_LENGTH
          Bitmask enumerating the numeric value scalar functions that are supported by the driver and the associated data source, as defined in SQL-92.
static long SQL_SNVF_CHARACTER_LENGTH
          Bitmask enumerating the numeric value scalar functions that are supported by the driver and the associated data source, as defined in SQL-92.
static long SQL_SNVF_EXTRACT
          Bitmask enumerating the numeric value scalar functions that are supported by the driver and the associated data source, as defined in SQL-92.
static long SQL_SNVF_OCTET_LENGTH
          Bitmask enumerating the numeric value scalar functions that are supported by the driver and the associated data source, as defined in SQL-92.
static long SQL_SNVF_POSITION
          Bitmask enumerating the numeric value scalar functions that are supported by the driver and the associated data source, as defined in SQL-92.
static long SQL_SP_BETWEEN
          Bitmask enumerating the predicates supported in a SELECT statement, as defined in SQL-92.
static long SQL_SP_COMPARISON
          Bitmask enumerating the predicates supported in a SELECT statement, as defined in SQL-92.
static long SQL_SP_EXISTS
          Bitmask enumerating the predicates supported in a SELECT statement, as defined in SQL-92.
static long SQL_SP_IN
          Bitmask enumerating the predicates supported in a SELECT statement, as defined in SQL-92.
static long SQL_SP_ISNOTNULL
          Bitmask enumerating the predicates supported in a SELECT statement, as defined in SQL-92.
static long SQL_SP_ISNULL
          Bitmask enumerating the predicates supported in a SELECT statement, as defined in SQL-92.
static long SQL_SP_LIKE
          Bitmask enumerating the predicates supported in a SELECT statement, as defined in SQL-92.
static long SQL_SP_MATCH_FULL
          Bitmask enumerating the predicates supported in a SELECT statement, as defined in SQL-92.
static long SQL_SP_MATCH_PARTIAL
          Bitmask enumerating the predicates supported in a SELECT statement, as defined in SQL-92.
static long SQL_SP_MATCH_UNIQUE_FULL
          Bitmask enumerating the predicates supported in a SELECT statement, as defined in SQL-92.
static long SQL_SP_MATCH_UNIQUE_PARTIAL
          Bitmask enumerating the predicates supported in a SELECT statement, as defined in SQL-92.
static long SQL_SP_OVERLAPS
          Bitmask enumerating the predicates supported in a SELECT statement, as defined in SQL-92.
static long SQL_SP_QUANTIFIED_COMPARISON
          Bitmask enumerating the predicates supported in a SELECT statement, as defined in SQL-92.
static long SQL_SP_UNIQUE
          Bitmask enumerating the predicates supported in a SELECT statement, as defined in SQL-92.
static long SQL_SQ_COMPARISON
          Bitmask enumerating the predicates that support subqueries.
static long SQL_SQ_CORRELATED_SUBQUERIES
          Bitmask enumerating the predicates that support subqueries.
static long SQL_SQ_EXISTS
          Bitmask enumerating the predicates that support subqueries.
static long SQL_SQ_IN
          Bitmask enumerating the predicates that support subqueries.
static long SQL_SQ_QUANTIFIED
          Bitmask enumerating the predicates that support subqueries.
static long SQL_SR_CASCADE
          Bitmask enumerating the clauses supported in the REVOKE statement, as defined in SQL-92, supported by the data source.
static long SQL_SR_DELETE_TABLE
          Bitmask enumerating the clauses supported in the REVOKE statement, as defined in SQL-92, supported by the data source.
static long SQL_SR_GRANT_OPTION_FOR
          Bitmask enumerating the clauses supported in the REVOKE statement, as defined in SQL-92, supported by the data source.
static long SQL_SR_INSERT_COLUMN
          Bitmask enumerating the clauses supported in the REVOKE statement, as defined in SQL-92, supported by the data source.
static long SQL_SR_INSERT_TABLE
          Bitmask enumerating the clauses supported in the REVOKE statement, as defined in SQL-92, supported by the data source.
static long SQL_SR_REFERENCES_COLUMN
          Bitmask enumerating the clauses supported in the REVOKE statement, as defined in SQL-92, supported by the data source.
static long SQL_SR_REFERENCES_TABLE
          Bitmask enumerating the clauses supported in the REVOKE statement, as defined in SQL-92, supported by the data source.
static long SQL_SR_RESTRICT
          Bitmask enumerating the clauses supported in the REVOKE statement, as defined in SQL-92, supported by the data source.
static long SQL_SR_SELECT_TABLE
          Bitmask enumerating the clauses supported in the REVOKE statement, as defined in SQL-92, supported by the data source.
static long SQL_SR_UPDATE_COLUMN
          Bitmask enumerating the clauses supported in the REVOKE statement, as defined in SQL-92, supported by the data source.
static long SQL_SR_UPDATE_TABLE
          Bitmask enumerating the clauses supported in the REVOKE statement, as defined in SQL-92, supported by the data source.
static long SQL_SR_USAGE_ON_CHARACTER_SET
          Bitmask enumerating the clauses supported in the REVOKE statement, as defined in SQL-92, supported by the data source.
static long SQL_SR_USAGE_ON_COLLATION
          Bitmask enumerating the clauses supported in the REVOKE statement, as defined in SQL-92, supported by the data source.
static long SQL_SR_USAGE_ON_DOMAIN
          Bitmask enumerating the clauses supported in the REVOKE statement, as defined in SQL-92, supported by the data source.
static long SQL_SR_USAGE_ON_TRANSLATION
          Bitmask enumerating the clauses supported in the REVOKE statement, as defined in SQL-92, supported by the data source.
static long SQL_SRJO_CORRESPONDING_CLAUSE
          Bitmask enumerating the relational join operators supported in a SELECT statement, as defined in SQL-92.
static long SQL_SRJO_CROSS_JOIN
          Bitmask enumerating the relational join operators supported in a SELECT statement, as defined in SQL-92.
static long SQL_SRJO_EXCEPT_JOIN
          Bitmask enumerating the relational join operators supported in a SELECT statement, as defined in SQL-92.
static long SQL_SRJO_FULL_OUTER_JOIN
          Bitmask enumerating the relational join operators supported in a SELECT statement, as defined in SQL-92.
static long SQL_SRJO_INNER_JOIN
          Bitmask enumerating the relational join operators supported in a SELECT statement, as defined in SQL-92.
static long SQL_SRJO_INTERSECT_JOIN
          Bitmask enumerating the relational join operators supported in a SELECT statement, as defined in SQL-92.
static long SQL_SRJO_LEFT_OUTER_JOIN
          Bitmask enumerating the relational join operators supported in a SELECT statement, as defined in SQL-92.
static long SQL_SRJO_NATURAL_JOIN
          Bitmask enumerating the relational join operators supported in a SELECT statement, as defined in SQL-92.
static long SQL_SRJO_RIGHT_OUTER_JOIN
          Bitmask enumerating the relational join operators supported in a SELECT statement, as defined in SQL-92.
static long SQL_SRJO_UNION_JOIN
          Bitmask enumerating the relational join operators supported in a SELECT statement, as defined in SQL-92.
static long SQL_SRVC_DEFAULT
          Bitmask enumerating the row value constructor expressions supported in a SELECT statement, as defined in SQL-92.
static long SQL_SRVC_NULL
          Bitmask enumerating the row value constructor expressions supported in a SELECT statement, as defined in SQL-92.
static long SQL_SRVC_ROW_SUBQUERY
          Bitmask enumerating the row value constructor expressions supported in a SELECT statement, as defined in SQL-92.
static long SQL_SRVC_VALUE_EXPRESSION
          Bitmask enumerating the row value constructor expressions supported in a SELECT statement, as defined in SQL-92.
static long SQL_SSF_CONVERT
          Bitmask enumerating the string scalar functions that are supported by the driver and the associated data source, as defined in SQL-92.
static long SQL_SSF_LOWER
          Bitmask enumerating the string scalar functions that are supported by the driver and the associated data source, as defined in SQL-92.
static long SQL_SSF_SUBSTRING
          Bitmask enumerating the string scalar functions that are supported by the driver and the associated data source, as defined in SQL-92.
static long SQL_SSF_TRANSLATE
          Bitmask enumerating the string scalar functions that are supported by the driver and the associated data source, as defined in SQL-92.
static long SQL_SSF_TRIM_BOTH
          Bitmask enumerating the string scalar functions that are supported by the driver and the associated data source, as defined in SQL-92.
static long SQL_SSF_TRIM_LEADING
          Bitmask enumerating the string scalar functions that are supported by the driver and the associated data source, as defined in SQL-92.
static long SQL_SSF_TRIM_TRAILING
          Bitmask enumerating the string scalar functions that are supported by the driver and the associated data source, as defined in SQL-92.
static long SQL_SSF_UPPER
          Bitmask enumerating the string scalar functions that are supported by the driver and the associated data source, as defined in SQL-92.
static long SQL_SU_DML_STATEMENTS
          Bitmask enumerating the statements in which schemas can be used, indicates schemas are supported in all Data Manipulation Language statements: SELECT, INSERT, UPDATE, DELETE, and if supported, SELECT FOR UPDATE and positioned update and delete statements.
static long SQL_SU_INDEX_DEFINITION
          Bitmask enumerating the statements in which schemas can be used, indicates schemas are supported in all index definition statements: CREATE INDEX and DROP INDEX.
static long SQL_SU_PRIVILEGE_DEFINITION
          Bitmask enumerating the statements in which schemas can be used, indicates schemas are supported in all privilege definition statements: GRANT and REVOKE.
static long SQL_SU_PROCEDURE_INVOCATION
          Bitmask enumerating the statements in which schemas can be used, indicates schemas are supported in the ODBC procedure invocation statement.
static long SQL_SU_TABLE_DEFINITION
          Bitmask enumerating the statements in which schemas can be used, indicates schemas are supported in all table definition statements: CREATE TABLE, CREATE VIEW, ALTER TABLE, DROP TABLE, and DROP VIEW.
static long SQL_SVE_CASE
          Bitmask enumerating the value expressions supported, as defined in SQL-92.
static long SQL_SVE_CAST
          Bitmask enumerating the value expressions supported, as defined in SQL-92.
static long SQL_SVE_COALESCE
          Bitmask enumerating the value expressions supported, as defined in SQL-92.
static long SQL_SVE_NULLIF
          Bitmask enumerating the value expressions supported, as defined in SQL-92.
static char SQL_TC_ALL
          A constant specifying the transaction support in the driver or data source, indicates transactions can contain DDL statements and DML statements in any order.
static char SQL_TC_DDL_COMMIT
          A constant specifying the transaction support in the driver or data source, indicates transactions can contain only DML statements.
static char SQL_TC_DDL_IGNORE
          A constant specifying the transaction support in the driver or data source, indicates transactions can contain only DML statements.
static char SQL_TC_DML
          A constant specifying the transaction support in the driver or data source, indicates transactions can contain only Data Manipulation Language (DML) statements (SELECT, INSERT, UPDATE, DELETE).
static char SQL_TC_NONE
          A constant specifying the transaction support in the driver or data source, indicates transactions not supported.
static int SQL_TRUE
          Constant indicating a true condition.
static long SQL_TXN_READ_COMMITTED
          A constant specifying the default transaction isolation level supported by the driver or data source, or zero if the data source does not support transactions.
static long SQL_TXN_READ_UNCOMMITTED
          A constant specifying the default transaction isolation level supported by the driver or data source, or zero if the data source does not support transactions.
static long SQL_TXN_REPEATABLE_READ
          A constant specifying the default transaction isolation level supported by the driver or data source, or zero if the data source does not support transactions.
static long SQL_TXN_SERIALIZABLE
          A constant specifying the default transaction isolation level supported by the driver or data source, or zero if the data source does not support transactions.
static long SQL_U_UNION
          Bitmask enumerating the support for the UNION clause, indicates data source supports the UNION clause.
static long SQL_U_UNION_ALL
          Bitmask enumerating the support for the UNION clause, indicates data source supports the ALL keyword in the UNION clause.
static long SQL_UNSPECIFIED
          A constant specifying the support for cursor sensitivity, indicating whether cursors on the statement handle make visible the changes that were made to a result set by another cursor within the same transaction.
 
Constructor Summary
SqlConstants()
           
 
Method Summary
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

SQL_FALSE

public static final int SQL_FALSE
Constant indicating a false condition.

See Also:
Constant Field Values

SQL_TRUE

public static final int SQL_TRUE
Constant indicating a true condition.

See Also:
Constant Field Values

SQL_CD_FALSE

public static final long SQL_CD_FALSE
Constant Indicates that the connection is still active, used for DSI_CONN_CONNECTION_DEAD.

See Also:
Constant Field Values

SQL_CD_TRUE

public static final long SQL_CD_TRUE
Constant Indicates that the connection has been lost, used for DSI_CONN_CONNECTION_DEAD.

See Also:
Constant Field Values

SQL_AA_TRUE

public static final long SQL_AA_TRUE
Constant indicating the application is an ANSI application, used for DSI_CONN_ANSI_APP.

See Also:
Constant Field Values

SQL_AA_FALSE

public static final long SQL_AA_FALSE
Constant indicating the application is an Unicode application, used for DSI_CONN_ANSI_APP.

See Also:
Constant Field Values

SQL_AUTOCOMMIT_OFF

public static final long SQL_AUTOCOMMIT_OFF
Constant indicating manual-commit mode, used for DSI_CONN_AUTOCOMMIT.

See Also:
Constant Field Values

SQL_AUTOCOMMIT_ON

public static final long SQL_AUTOCOMMIT_ON
Constant indicating auto-commit mode, used for DSI_CONN_AUTOCOMMIT.

See Also:
Constant Field Values

SQL_AF_ALL

public static final long SQL_AF_ALL
Bitmask enumerating support for aggregate functions for DSI_AGGREGATE_FUNCTIONS.

See Also:
Constant Field Values

SQL_AF_AVG

public static final long SQL_AF_AVG
Bitmask enumerating support for aggregate functions for DSI_AGGREGATE_FUNCTIONS.

See Also:
Constant Field Values

SQL_AF_COUNT

public static final long SQL_AF_COUNT
Bitmask enumerating support for aggregate functions for DSI_AGGREGATE_FUNCTIONS.

See Also:
Constant Field Values

SQL_AF_DISTINCT

public static final long SQL_AF_DISTINCT
Bitmask enumerating support for aggregate functions for DSI_AGGREGATE_FUNCTIONS.

See Also:
Constant Field Values

SQL_AF_MAX

public static final long SQL_AF_MAX
Bitmask enumerating support for aggregate functions for DSI_AGGREGATE_FUNCTIONS.

See Also:
Constant Field Values

SQL_AF_MIN

public static final long SQL_AF_MIN
Bitmask enumerating support for aggregate functions for DSI_AGGREGATE_FUNCTIONS.

See Also:
Constant Field Values

SQL_AF_SUM

public static final long SQL_AF_SUM
Bitmask enumerating support for aggregate functions for DSI_AGGREGATE_FUNCTIONS.

See Also:
Constant Field Values

SQL_AD_ADD_DOMAIN_CONSTRAINT

public static final long SQL_AD_ADD_DOMAIN_CONSTRAINT
Bitmask enumerating the clauses in the ALTER DOMAIN statement, indicates adding a domain constraint is supported. Used for DSI_ALTER_DOMAIN.

See Also:
Constant Field Values

SQL_AD_ADD_DOMAIN_DEFAULT

public static final long SQL_AD_ADD_DOMAIN_DEFAULT
Bitmask enumerating the clauses in the ALTER DOMAIN statement, indicates <alter domain> <set domain default clause> is supported. Used for DSI_ALTER_DOMAIN.

See Also:
Constant Field Values

SQL_AD_CONSTRAINT_NAME_DEFINITION

public static final long SQL_AD_CONSTRAINT_NAME_DEFINITION
Bitmask enumerating the clauses in the ALTER DOMAIN statement, indicates <constraint name definition clause> is supported for naming domain constraint. Used for DSI_ALTER_DOMAIN.

See Also:
Constant Field Values

SQL_AD_DROP_DOMAIN_CONSTRAINT

public static final long SQL_AD_DROP_DOMAIN_CONSTRAINT
Bitmask enumerating the clauses in the ALTER DOMAIN statement, indicates <drop domain constraint clause> is supported. Used for DSI_ALTER_DOMAIN.

See Also:
Constant Field Values

SQL_AD_DROP_DOMAIN_DEFAULT

public static final long SQL_AD_DROP_DOMAIN_DEFAULT
Bitmask enumerating the clauses in the ALTER DOMAIN statement, indicates <alter domain> <drop domain default clause> is supported. Used for DSI_ALTER_DOMAIN.

See Also:
Constant Field Values

SQL_AD_ADD_CONSTRAINT_DEFERRABLE

public static final long SQL_AD_ADD_CONSTRAINT_DEFERRABLE
Bitmask enumerating the clauses in the ALTER DOMAIN statement, indicates the supported <constraint attributes> if <add domain constraint> is supported. Used for DSI_ALTER_DOMAIN.

See Also:
Constant Field Values

SQL_AD_ADD_CONSTRAINT_NON_DEFERRABLE

public static final long SQL_AD_ADD_CONSTRAINT_NON_DEFERRABLE
Bitmask enumerating the clauses in the ALTER DOMAIN statement, indicates the supported <constraint attributes> if <add domain constraint> is supported. Used for DSI_ALTER_DOMAIN.

See Also:
Constant Field Values

SQL_AD_ADD_CONSTRAINT_INITIALLY_DEFERRED

public static final long SQL_AD_ADD_CONSTRAINT_INITIALLY_DEFERRED
Bitmask enumerating the clauses in the ALTER DOMAIN statement, indicates the supported <constraint attributes> if <add domain constraint> is supported. Used for DSI_ALTER_DOMAIN.

See Also:
Constant Field Values

SQL_AD_ADD_CONSTRAINT_INITIALLY_IMMEDIATE

public static final long SQL_AD_ADD_CONSTRAINT_INITIALLY_IMMEDIATE
Bitmask enumerating the clauses in the ALTER DOMAIN statement, indicates the supported <constraint attributes> if <add domain constraint> is supported. Used for DSI_ALTER_DOMAIN.

See Also:
Constant Field Values

SQL_AT_ADD_COLUMN_COLLATION

public static final long SQL_AT_ADD_COLUMN_COLLATION
Bitmask enumerating the clauses in the ALTER TABLE statement, indicates <add column> clause is supported, with facility to specify column collation. Used for DSI_ALTER_TABLE.

See Also:
Constant Field Values

SQL_AT_ADD_COLUMN_DEFAULT

public static final long SQL_AT_ADD_COLUMN_DEFAULT
Bitmask enumerating the clauses in the ALTER TABLE statement, indicates <add column> clause is supported, with facility to specify column defaults. Used for DSI_ALTER_TABLE.

See Also:
Constant Field Values

SQL_AT_ADD_COLUMN_SINGLE

public static final long SQL_AT_ADD_COLUMN_SINGLE
Bitmask enumerating the clauses in the ALTER TABLE statement, indicates <add column> is supported. Used for DSI_ALTER_TABLE.

See Also:
Constant Field Values

SQL_AT_ADD_CONSTRAINT

public static final long SQL_AT_ADD_CONSTRAINT
Bitmask enumerating the clauses in the ALTER TABLE statement, indicates <add column> clause is supported, with facility to specify column constraints. Used for DSI_ALTER_TABLE.

See Also:
Constant Field Values

SQL_AT_ADD_TABLE_CONSTRAINT

public static final long SQL_AT_ADD_TABLE_CONSTRAINT
Bitmask enumerating the clauses in the ALTER TABLE statement, indicates <add table constraint> clause is supported. Used for DSI_ALTER_TABLE.

See Also:
Constant Field Values

SQL_AT_CONSTRAINT_NAME_DEFINITION

public static final long SQL_AT_CONSTRAINT_NAME_DEFINITION
Bitmask enumerating the clauses in the ALTER TABLE statement, indicates <constraint name definition> is supported for naming column and table constraints. Used for DSI_ALTER_TABLE.

See Also:
Constant Field Values

SQL_AT_DROP_COLUMN_CASCADE

public static final long SQL_AT_DROP_COLUMN_CASCADE
Bitmask enumerating the clauses in the ALTER TABLE statement, indicates <drop column> CASCADE is supported. Used for DSI_ALTER_TABLE.

See Also:
Constant Field Values

SQL_AT_DROP_COLUMN_DEFAULT

public static final long SQL_AT_DROP_COLUMN_DEFAULT
Bitmask enumerating the clauses in the ALTER TABLE statement, indicates <alter column> <drop column default clause> is supported. Used for DSI_ALTER_TABLE.

See Also:
Constant Field Values

SQL_AT_DROP_COLUMN_RESTRICT

public static final long SQL_AT_DROP_COLUMN_RESTRICT
Bitmask enumerating the clauses in the ALTER TABLE statement, indicates <drop column> RESTRICT is supported. Used for DSI_ALTER_TABLE.

See Also:
Constant Field Values

SQL_AT_DROP_TABLE_CONSTRAINT_CASCADE

public static final long SQL_AT_DROP_TABLE_CONSTRAINT_CASCADE
Bitmask enumerating the clauses in the ALTER TABLE statement. Used for DSI_ALTER_TABLE.

See Also:
Constant Field Values

SQL_AT_DROP_TABLE_CONSTRAINT_RESTRICT

public static final long SQL_AT_DROP_TABLE_CONSTRAINT_RESTRICT
Bitmask enumerating the clauses in the ALTER TABLE statement. Used for DSI_ALTER_TABLE.

See Also:
Constant Field Values

SQL_AT_SET_COLUMN_DEFAULT

public static final long SQL_AT_SET_COLUMN_DEFAULT
Bitmask enumerating the clauses in the ALTER TABLE statement, indicates <alter column> <set column default clause> is supported. Used for DSI_ALTER_TABLE.

See Also:
Constant Field Values

SQL_AT_CONSTRAINT_INITIALLY_DEFERRED

public static final long SQL_AT_CONSTRAINT_INITIALLY_DEFERRED
Bitmask enumerating the clauses in the ALTER TABLE statement, indicates the support <constraint attributes> if specifying column or table constraints is supported. Used for DSI_ALTER_TABLE.

See Also:
Constant Field Values

SQL_AT_CONSTRAINT_INITIALLY_IMMEDIATE

public static final long SQL_AT_CONSTRAINT_INITIALLY_IMMEDIATE
Bitmask enumerating the clauses in the ALTER TABLE statement, indicates the support <constraint attributes> if specifying column or table constraints is supported. Used for DSI_ALTER_TABLE.

See Also:
Constant Field Values

SQL_AT_CONSTRAINT_DEFERRABLE

public static final long SQL_AT_CONSTRAINT_DEFERRABLE
Bitmask enumerating the clauses in the ALTER TABLE statement, indicates the support <constraint attributes> if specifying column or table constraints is supported. Used for DSI_ALTER_TABLE.

See Also:
Constant Field Values

SQL_AT_CONSTRAINT_NON_DEFERRABLE

public static final long SQL_AT_CONSTRAINT_NON_DEFERRABLE
Bitmask enumerating the clauses in the ALTER TABLE statement, indicates the support <constraint attributes> if specifying column or table constraints is supported. Used for DSI_ALTER_TABLE.

See Also:
Constant Field Values

SQL_BP_CLOSE

public static final long SQL_BP_CLOSE
Bitmask enumerating the operations through which bookmarks persist, indicates bookmarks are valid after an application calls closes the cursor associated with a statement. Used for DSI_BOOKMARK_PERSISTENCE.

See Also:
Constant Field Values

SQL_BP_DELETE

public static final long SQL_BP_DELETE
Bitmask enumerating the operations through which bookmarks persist, indicates bookmark for a row is valid after that row has been deleted. Used for DSI_BOOKMARK_PERSISTENCE.

See Also:
Constant Field Values

SQL_BP_DROP

public static final long SQL_BP_DROP
Bitmask enumerating the operations through which bookmarks persist, indicates bookmarks are valid after an application calls SQLFreeHandle with a HandleType of SQL_HANDLE_STMT to drop a statement. Used for DSI_BOOKMARK_PERSISTENCE.

See Also:
Constant Field Values

SQL_BP_TRANSACTION

public static final long SQL_BP_TRANSACTION
Bitmask enumerating the operations through which bookmarks persist, indicates bookmarks are valid after an application commits or rolls back a transaction. Used for DSI_BOOKMARK_PERSISTENCE.

See Also:
Constant Field Values

SQL_BP_UPDATE

public static final long SQL_BP_UPDATE
Bitmask enumerating the operations through which bookmarks persist, indicates bookmark for a row is valid after any column in that row has been updated, including key columns. Used for DSI_BOOKMARK_PERSISTENCE.

See Also:
Constant Field Values

SQL_BP_OTHER_HSTMT

public static final long SQL_BP_OTHER_HSTMT
Bitmask enumerating the operations through which bookmarks persist, indicates bookmark associated with one statement can be used with another statement. Unless SQL_BP_CLOSE or SQL_BP_DROP is specified, the cursor on the first statement must be open. Used for DSI_BOOKMARK_PERSISTENCE.

See Also:
Constant Field Values

SQL_BP_SCROLL

public static final long SQL_BP_SCROLL
Bitmask enumerating the operations through which bookmarks persist, indicates bookmarks are valid after any scrolling operation. Used for DSI_BOOKMARK_PERSISTENCE.

See Also:
Constant Field Values

SQL_CL_START

public static final long SQL_CL_START
Constant specifying the position of the catalog in a qualified table name. Used for DSI_CATALOG_LOCATION.

See Also:
Constant Field Values

SQL_CL_END

public static final long SQL_CL_END
Constant specifying the position of the catalog in a qualified table name. Used for DSI_CATALOG_LOCATION.

See Also:
Constant Field Values

SQL_CU_DML_STATEMENTS

public static final long SQL_CU_DML_STATEMENTS
Bitmask enumerating the statements in which catalogs can be used, indicates catalogs are supported in all Data Manipulation Language statements: SELECT, INSERT, UPDATE, DELETE, and if supported, SELECT FOR UPDATE and positioned update and delete statements. Used for DSI_CATALOG_USAGE.

See Also:
Constant Field Values

SQL_CU_PROCEDURE_INVOCATION

public static final long SQL_CU_PROCEDURE_INVOCATION
Bitmask enumerating the statements in which catalogs can be used, indicates catalogs are supported in the ODBC procedure invocation statement. Used for DSI_CATALOG_USAGE.

See Also:
Constant Field Values

SQL_CU_TABLE_DEFINITION

public static final long SQL_CU_TABLE_DEFINITION
Bitmask enumerating the statements in which catalogs can be used, indicates catalogs are supported in all table definition statements: CREATE TABLE, CREATE VIEW, ALTER TABLE, DROP TABLE, and DROP VIEW. Used for DSI_CATALOG_USAGE.

See Also:
Constant Field Values

SQL_CU_INDEX_DEFINITION

public static final long SQL_CU_INDEX_DEFINITION
Bitmask enumerating the statements in which catalogs can be used, indicates catalogs are supported in all index definition statements: CREATE INDEX and DROP INDEX. Used for DSI_CATALOG_USAGE.

See Also:
Constant Field Values

SQL_CU_PRIVILEGE_DEFINITION

public static final long SQL_CU_PRIVILEGE_DEFINITION
Bitmask enumerating the statements in which catalogs can be used, indicates catalogs are supported in all privilege definition statements: GRANT and REVOKE. Used for DSI_CATALOG_USAGE.

See Also:
Constant Field Values

SQL_CB_NULL

public static final long SQL_CB_NULL
A constant that indicates how the data source handles the concatenation of NULL valued character data type columns with non-NULL valued character data type columns, specifies results are NULL valued. Used for DSI_CONCAT_NULL_BEHAVIOR.

See Also:
Constant Field Values

SQL_CB_NON_NULL

public static final long SQL_CB_NON_NULL
A constant that indicates how the data source handles the concatenation of NULL valued character data type columns with non-NULL valued character data type columns, specifies results are concatenation of non-NULL valued column or columns. Used for DSI_CONCAT_NULL_BEHAVIOR.

See Also:
Constant Field Values

SQL_MODE_READ_WRITE

public static final long SQL_MODE_READ_WRITE
A constant that indicates that the connection is required to support SQL statements that cause updates to occur. Used for DSI_CONN_ACCESS_MODE.

See Also:
Constant Field Values

SQL_MODE_READ_ONLY

public static final long SQL_MODE_READ_ONLY
A constant that indicates that the connection is not required to support SQL statements that cause updates to occur. This mode can be used to optimize locking strategies, transaction management, or other areas as appropriate to the driver or data source. The driver is not required to prevent such statements from being submitted to the data source. The behavior of the driver and data source when asked to process SQL statements that are not read-only during a read-only connection is implementation-defined. Used for DSI_CONN_ACCESS_MODE.

See Also:
Constant Field Values

SQL_CVT_BIGINT

public static final long SQL_CVT_BIGINT
Bitmask enumerating the conversions supported by the data source with the CONVERT scalar function for data of the type named in the InfoType, indicates conversions to BIGINT are supported. Used for

See Also:
Constant Field Values

SQL_CVT_BINARY

public static final long SQL_CVT_BINARY
Bitmask enumerating the conversions supported by the data source with the CONVERT scalar function for data of the type named in the InfoType, indicates conversions to binary are supported. Used for

See Also:
Constant Field Values

SQL_CVT_BIT

public static final long SQL_CVT_BIT
Bitmask enumerating the conversions supported by the data source with the CONVERT scalar function for data of the type named in the InfoType, indicates conversions to bit are supported. Used for

See Also:
Constant Field Values

SQL_CVT_CHAR

public static final long SQL_CVT_CHAR
Bitmask enumerating the conversions supported by the data source with the CONVERT scalar function for data of the type named in the InfoType, indicates conversions to char are supported. Used for

See Also:
Constant Field Values

SQL_CVT_GUID

public static final long SQL_CVT_GUID
Bitmask enumerating the conversions supported by the data source with the CONVERT scalar function for data of the type named in the InfoType, indicates conversions to GUID are supported. Used for

See Also:
Constant Field Values

SQL_CVT_DATE

public static final long SQL_CVT_DATE
Bitmask enumerating the conversions supported by the data source with the CONVERT scalar function for data of the type named in the InfoType, indicates conversions to date are supported. Used for

See Also:
Constant Field Values

SQL_CVT_DECIMAL

public static final long SQL_CVT_DECIMAL
Bitmask enumerating the conversions supported by the data source with the CONVERT scalar function for data of the type named in the InfoType, indicates conversions to decimal are supported. Used for

See Also:
Constant Field Values

SQL_CVT_DOUBLE

public static final long SQL_CVT_DOUBLE
Bitmask enumerating the conversions supported by the data source with the CONVERT scalar function for data of the type named in the InfoType, indicates conversions to double are supported. Used for

See Also:
Constant Field Values

SQL_CVT_FLOAT

public static final long SQL_CVT_FLOAT
Bitmask enumerating the conversions supported by the data source with the CONVERT scalar function for data of the type named in the InfoType, indicates conversions to float are supported. Used for

See Also:
Constant Field Values

SQL_CVT_INTEGER

public static final long SQL_CVT_INTEGER
Bitmask enumerating the conversions supported by the data source with the CONVERT scalar function for data of the type named in the InfoType, indicates conversions to integer are supported. Used for

See Also:
Constant Field Values

SQL_CVT_INTERVAL_YEAR_MONTH

public static final long SQL_CVT_INTERVAL_YEAR_MONTH
Bitmask enumerating the conversions supported by the data source with the CONVERT scalar function for data of the type named in the InfoType, indicates conversions to interval year month are supported. Used for

See Also:
Constant Field Values

SQL_CVT_INTERVAL_DAY_TIME

public static final long SQL_CVT_INTERVAL_DAY_TIME
Bitmask enumerating the conversions supported by the data source with the CONVERT scalar function for data of the type named in the InfoType, indicates conversions to interval day time are supported. Used for

See Also:
Constant Field Values

SQL_CVT_LONGVARBINARY

public static final long SQL_CVT_LONGVARBINARY
Bitmask enumerating the conversions supported by the data source with the CONVERT scalar function for data of the type named in the InfoType, indicates conversions to long varbinary are supported. Used for

See Also:
Constant Field Values

SQL_CVT_LONGVARCHAR

public static final long SQL_CVT_LONGVARCHAR
Bitmask enumerating the conversions supported by the data source with the CONVERT scalar function for data of the type named in the InfoType, indicates conversions to long varchar are supported. Used for

See Also:
Constant Field Values

SQL_CVT_NUMERIC

public static final long SQL_CVT_NUMERIC
Bitmask enumerating the conversions supported by the data source with the CONVERT scalar function for data of the type named in the InfoType, indicates conversions to numeric are supported. Used for

See Also:
Constant Field Values

SQL_CVT_REAL

public static final long SQL_CVT_REAL
Bitmask enumerating the conversions supported by the data source with the CONVERT scalar function for data of the type named in the InfoType, indicates conversions to real are supported. Used for

See Also:
Constant Field Values

SQL_CVT_SMALLINT

public static final long SQL_CVT_SMALLINT
Bitmask enumerating the conversions supported by the data source with the CONVERT scalar function for data of the type named in the InfoType, indicates conversions to smallint are supported. Used for

See Also:
Constant Field Values

SQL_CVT_TIME

public static final long SQL_CVT_TIME
Bitmask enumerating the conversions supported by the data source with the CONVERT scalar function for data of the type named in the InfoType, indicates conversions to time are supported. Used for

See Also:
Constant Field Values

SQL_CVT_TIMESTAMP

public static final long SQL_CVT_TIMESTAMP
Bitmask enumerating the conversions supported by the data source with the CONVERT scalar function for data of the type named in the InfoType, indicates conversions to timestamp are supported. Used for

See Also:
Constant Field Values

SQL_CVT_TINYINT

public static final long SQL_CVT_TINYINT
Bitmask enumerating the conversions supported by the data source with the CONVERT scalar function for data of the type named in the InfoType, indicates conversions to tiny int are supported. Used for

See Also:
Constant Field Values

SQL_CVT_VARBINARY

public static final long SQL_CVT_VARBINARY
Bitmask enumerating the conversions supported by the data source with the CONVERT scalar function for data of the type named in the InfoType, indicates conversions to varbinary are supported. Used for

See Also:
Constant Field Values

SQL_CVT_VARCHAR

public static final long SQL_CVT_VARCHAR
Bitmask enumerating the conversions supported by the data source with the CONVERT scalar function for data of the type named in the InfoType, indicates conversions to varchar are supported. Used for

See Also:
Constant Field Values

SQL_CVT_WCHAR

public static final long SQL_CVT_WCHAR
Bitmask enumerating the conversions supported by the data source with the CONVERT scalar function for data of the type named in the InfoType, indicates conversions to wchar are supported. Used for

See Also:
Constant Field Values

SQL_CVT_WLONGVARCHAR

public static final long SQL_CVT_WLONGVARCHAR
Bitmask enumerating the conversions supported by the data source with the CONVERT scalar function for data of the type named in the InfoType, indicates conversions to long wvarchar are supported. Used for

See Also:
Constant Field Values

SQL_CVT_WVARCHAR

public static final long SQL_CVT_WVARCHAR
Bitmask enumerating the conversions supported by the data source with the CONVERT scalar function for data of the type named in the InfoType, indicates conversions to wvarchar are supported. Used for

See Also:
Constant Field Values

SQL_FN_CVT_CONVERT

public static final long SQL_FN_CVT_CONVERT
Bitmask enumerating the scalar conversion functions supported by the driver and associated data source. Used for DSI_CONVERT_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_CVT_CAST

public static final long SQL_FN_CVT_CAST
Bitmask enumerating the scalar conversion functions supported by the driver and associated data source. Used for DSI_CONVERT_FUNCTIONS.

See Also:
Constant Field Values

SQL_CN_ANY

public static final long SQL_CN_ANY
A constant specifying whether the table correlation names are supported, indicates correlation names are supported and can be any valid user-defined name. Used for DSI_CORRELATION_NAME.

See Also:
Constant Field Values

SQL_CN_NONE

public static final long SQL_CN_NONE
A constant specifying whether the table correlation names are supported, indicates correlation names are supported but must differ from the names of the tables they represent. Used for DSI_CORRELATION_NAME.

See Also:
Constant Field Values

SQL_CN_DIFFERENT

public static final long SQL_CN_DIFFERENT
A constant specifying whether the table correlation names are supported, indicates correlation names are supported not supported. Used for DSI_CORRELATION_NAME.

See Also:
Constant Field Values

SQL_CA_CREATE_ASSERTION

public static final long SQL_CA_CREATE_ASSERTION
Bitmask enumerating the clauses in the CREATE ASSERTION statement, as defined in SQL-92, supported by the data source. Used for DSI_CREATE_ASSERTION.

See Also:
Constant Field Values

SQL_CA_CONSTRAINT_INITIALLY_DEFERRED

public static final long SQL_CA_CONSTRAINT_INITIALLY_DEFERRED
Bitmask enumerating the clauses in the CREATE ASSERTION statement, as defined in SQL-92, supported by the data source. Used for DSI_CREATE_ASSERTION.

See Also:
Constant Field Values

SQL_CA_CONSTRAINT_INITIALLY_IMMEDIATE

public static final long SQL_CA_CONSTRAINT_INITIALLY_IMMEDIATE
Bitmask enumerating the clauses in the CREATE ASSERTION statement, as defined in SQL-92, supported by the data source. Used for DSI_CREATE_ASSERTION.

See Also:
Constant Field Values

SQL_CA_CONSTRAINT_DEFERRABLE

public static final long SQL_CA_CONSTRAINT_DEFERRABLE
Bitmask enumerating the clauses in the CREATE ASSERTION statement, as defined in SQL-92, supported by the data source. Used for DSI_CREATE_ASSERTION.

See Also:
Constant Field Values

SQL_CA_CONSTRAINT_NON_DEFERRABLE

public static final long SQL_CA_CONSTRAINT_NON_DEFERRABLE
Bitmask enumerating the clauses in the CREATE ASSERTION statement, as defined in SQL-92, supported by the data source. Used for DSI_CREATE_ASSERTION.

See Also:
Constant Field Values

SQL_CCS_CREATE_CHARACTER_SET

public static final long SQL_CCS_CREATE_CHARACTER_SET
Bitmask enumerating the clauses in the CREATE CHARACTER SET statement, as defined in SQL-92, supported by the data source. Used for DSI_CREATE_CHARACTER_SET.

See Also:
Constant Field Values

SQL_CCS_COLLATE_CLAUSE

public static final long SQL_CCS_COLLATE_CLAUSE
Bitmask enumerating the clauses in the CREATE CHARACTER SET statement, as defined in SQL-92, supported by the data source. Used for DSI_CREATE_CHARACTER_SET.

See Also:
Constant Field Values

SQL_CCS_LIMITED_COLLATION

public static final long SQL_CCS_LIMITED_COLLATION
Bitmask enumerating the clauses in the CREATE CHARACTER SET statement, as defined in SQL-92, supported by the data source. Used for DSI_CREATE_CHARACTER_SET.

See Also:
Constant Field Values

SQL_CCOL_CREATE_COLLATION

public static final long SQL_CCOL_CREATE_COLLATION
Bitmask enumerating the clauses in the CREATE COLLATION statement, as defined in SQL-92, supported by the data source. Used for DSI_CREATE_COLLATION.

See Also:
Constant Field Values

SQL_CDO_CREATE_DOMAIN

public static final long SQL_CDO_CREATE_DOMAIN
Bitmask enumerating the clauses in the CREATE DOMAIN statement, as defined in SQL-92, supported by the data source, specifies the CREATE DOMAIN statement is supported. Used for DSI_CREATE_DOMAIN.

See Also:
Constant Field Values

SQL_CDO_CONSTRAINT_NAME_DEFINITION

public static final long SQL_CDO_CONSTRAINT_NAME_DEFINITION
Bitmask enumerating the clauses in the CREATE DOMAIN statement, as defined in SQL-92, supported by the data source, specifies <constraint name definition> is supported for naming domain constraints. Used for DSI_CREATE_DOMAIN.

See Also:
Constant Field Values

SQL_CDO_DEFAULT

public static final long SQL_CDO_DEFAULT
Bitmask enumerating the clauses in the CREATE DOMAIN statement, as defined in SQL-92, supported by the data source, specifies domain constraints is supported. Used for DSI_CREATE_DOMAIN.

See Also:
Constant Field Values

SQL_CDO_CONSTRAINT

public static final long SQL_CDO_CONSTRAINT
Bitmask enumerating the clauses in the CREATE DOMAIN statement, as defined in SQL-92, supported by the data source, specifies domain defaults is supported. Used for DSI_CREATE_DOMAIN.

See Also:
Constant Field Values

SQL_CDO_COLLATION

public static final long SQL_CDO_COLLATION
Bitmask enumerating the clauses in the CREATE DOMAIN statement, as defined in SQL-92, supported by the data source, specifies domain collation is supported. Used for DSI_CREATE_DOMAIN.

See Also:
Constant Field Values

SQL_CDO_CONSTRAINT_INITIALLY_DEFERRED

public static final long SQL_CDO_CONSTRAINT_INITIALLY_DEFERRED
Bitmask enumerating the clauses in the CREATE DOMAIN statement, as defined in SQL-92, supported by the data source. Used for DSI_CREATE_DOMAIN.

See Also:
Constant Field Values

SQL_CDO_CONSTRAINT_INITIALLY_IMMEDIATE

public static final long SQL_CDO_CONSTRAINT_INITIALLY_IMMEDIATE
Bitmask enumerating the clauses in the CREATE DOMAIN statement, as defined in SQL-92, supported by the data source. Used for DSI_CREATE_DOMAIN.

See Also:
Constant Field Values

SQL_CDO_CONSTRAINT_DEFERRABLE

public static final long SQL_CDO_CONSTRAINT_DEFERRABLE
Bitmask enumerating the clauses in the CREATE DOMAIN statement, as defined in SQL-92, supported by the data source. Used for DSI_CREATE_DOMAIN.

See Also:
Constant Field Values

SQL_CDO_CONSTRAINT_NON_DEFERRABLE

public static final long SQL_CDO_CONSTRAINT_NON_DEFERRABLE
Bitmask enumerating the clauses in the CREATE DOMAIN statement, as defined in SQL-92, supported by the data source. Used for DSI_CREATE_DOMAIN.

See Also:
Constant Field Values

SQL_CS_CREATE_SCHEMA

public static final long SQL_CS_CREATE_SCHEMA
Bitmask enumerating the clauses in the CREATE SCHEMA statement, as defined in SQL-92, supported by the data source. Used for DSI_CREATE_SCHEMA.

See Also:
Constant Field Values

SQL_CS_AUTHORIZATION

public static final long SQL_CS_AUTHORIZATION
Bitmask enumerating the clauses in the CREATE SCHEMA statement, as defined in SQL-92, supported by the data source. Used for DSI_CREATE_SCHEMA.

See Also:
Constant Field Values

SQL_CS_DEFAULT_CHARACTER_SET

public static final long SQL_CS_DEFAULT_CHARACTER_SET
Bitmask enumerating the clauses in the CREATE SCHEMA statement, as defined in SQL-92, supported by the data source. Used for DSI_CREATE_SCHEMA.

See Also:
Constant Field Values

SQL_CT_CREATE_TABLE

public static final long SQL_CT_CREATE_TABLE
Bitmask enumerating the clauses in the CREATE TABLE statement, as defined in SQL-92, supported by the data source, specifies CREATE TABLE statement is supported. Used for DSI_CREATE_TABLE.

See Also:
Constant Field Values

SQL_CT_TABLE_CONSTRAINT

public static final long SQL_CT_TABLE_CONSTRAINT
Bitmask enumerating the clauses in the CREATE TABLE statement, as defined in SQL-92, supported by the data source, specifies table constraints is supported. Used for DSI_CREATE_TABLE.

See Also:
Constant Field Values

SQL_CT_CONSTRAINT_NAME_DEFINITION

public static final long SQL_CT_CONSTRAINT_NAME_DEFINITION
Bitmask enumerating the clauses in the CREATE TABLE statement, as defined in SQL-92, supported by the data source, specifies <constraint name definition> clause is supported for naming column and table constraints. Used for DSI_CREATE_TABLE.

See Also:
Constant Field Values

SQL_CT_COMMIT_PRESERVE

public static final long SQL_CT_COMMIT_PRESERVE
Bitmask enumerating the clauses in the CREATE TABLE statement, as defined in SQL-92, supported by the data source, specifies deleted rows are preserved on commit for temporary tables. Used for DSI_CREATE_TABLE.

See Also:
Constant Field Values

SQL_CT_COMMIT_DELETE

public static final long SQL_CT_COMMIT_DELETE
Bitmask enumerating the clauses in the CREATE TABLE statement, as defined in SQL-92, supported by the data source, specifies deleted rows are deleted on commit for temporary tables. Used for DSI_CREATE_TABLE.

See Also:
Constant Field Values

SQL_CT_GLOBAL_TEMPORARY

public static final long SQL_CT_GLOBAL_TEMPORARY
Bitmask enumerating the clauses in the CREATE TABLE statement, as defined in SQL-92, supported by the data source, specifies global temporary tables can be created. Used for DSI_CREATE_TABLE.

See Also:
Constant Field Values

SQL_CT_LOCAL_TEMPORARY

public static final long SQL_CT_LOCAL_TEMPORARY
Bitmask enumerating the clauses in the CREATE TABLE statement, as defined in SQL-92, supported by the data source, specifies local temporary tables can be created. Used for DSI_CREATE_TABLE.

See Also:
Constant Field Values

SQL_CT_COLUMN_CONSTRAINT

public static final long SQL_CT_COLUMN_CONSTRAINT
Bitmask enumerating the clauses in the CREATE TABLE statement, as defined in SQL-92, supported by the data source, specifies column constraints is supported. Used for DSI_CREATE_TABLE.

See Also:
Constant Field Values

SQL_CT_COLUMN_DEFAULT

public static final long SQL_CT_COLUMN_DEFAULT
Bitmask enumerating the clauses in the CREATE TABLE statement, as defined in SQL-92, supported by the data source, specifies column defaults is supported . Used for DSI_CREATE_TABLE.

See Also:
Constant Field Values

SQL_CT_COLUMN_COLLATION

public static final long SQL_CT_COLUMN_COLLATION
Bitmask enumerating the clauses in the CREATE TABLE statement, as defined in SQL-92, supported by the data source, specifies column collation is supported. Used for DSI_CREATE_TABLE.

See Also:
Constant Field Values

SQL_CT_CONSTRAINT_INITIALLY_DEFERRED

public static final long SQL_CT_CONSTRAINT_INITIALLY_DEFERRED
Bitmask enumerating the clauses in the CREATE TABLE statement, as defined in SQL-92, supported by the data source. Used for DSI_CREATE_TABLE.

See Also:
Constant Field Values

SQL_CT_CONSTRAINT_INITIALLY_IMMEDIATE

public static final long SQL_CT_CONSTRAINT_INITIALLY_IMMEDIATE
Bitmask enumerating the clauses in the CREATE TABLE statement, as defined in SQL-92, supported by the data source. Used for DSI_CREATE_TABLE.

See Also:
Constant Field Values

SQL_CT_CONSTRAINT_DEFERRABLE

public static final long SQL_CT_CONSTRAINT_DEFERRABLE
Bitmask enumerating the clauses in the CREATE TABLE statement, as defined in SQL-92, supported by the data source. Used for DSI_CREATE_TABLE.

See Also:
Constant Field Values

SQL_CT_CONSTRAINT_NON_DEFERRABLE

public static final long SQL_CT_CONSTRAINT_NON_DEFERRABLE
Bitmask enumerating the clauses in the CREATE TABLE statement, as defined in SQL-92, supported by the data source. Used for DSI_CREATE_TABLE.

See Also:
Constant Field Values

SQL_CTR_CREATE_TRANSLATION

public static final long SQL_CTR_CREATE_TRANSLATION
Bitmask enumerating the clauses in the CREATE TRANSLATION statement, as defined in SQL-92, supported by the data source. Used for DSI_CREATE_TRANSLATION.

See Also:
Constant Field Values

SQL_CV_CREATE_VIEW

public static final long SQL_CV_CREATE_VIEW
Bitmask enumerating the clauses in the CREATE VIEW statement, as defined in SQL-92, supported by the data source. Used for DSI_CREATE_VIEW.

See Also:
Constant Field Values

SQL_CV_CHECK_OPTION

public static final long SQL_CV_CHECK_OPTION
Bitmask enumerating the clauses in the CREATE VIEW statement, as defined in SQL-92, supported by the data source. Used for DSI_CREATE_VIEW.

See Also:
Constant Field Values

SQL_CV_CASCADED

public static final long SQL_CV_CASCADED
Bitmask enumerating the clauses in the CREATE VIEW statement, as defined in SQL-92, supported by the data source. Used for DSI_CREATE_VIEW.

See Also:
Constant Field Values

SQL_CV_LOCAL

public static final long SQL_CV_LOCAL
Bitmask enumerating the clauses in the CREATE VIEW statement, as defined in SQL-92, supported by the data source. Used for DSI_CREATE_VIEW.

See Also:
Constant Field Values

SQL_CB_DELETE

public static final long SQL_CB_DELETE
A constant specifying how a COMMIT or ROLLBACK operation affects cursors and prepared statements in the data source (the behavior of the data source when you commit a transaction). Close cursors and delete prepared statements. To use the cursor again, the application must reprepare and reexecute the statement. Used for DSI_CURSOR_COMMIT_BEHAVIOR, DSI_CURSOR_ROLLBACK_BEHAVIOR.

See Also:
Constant Field Values

SQL_CB_CLOSE

public static final long SQL_CB_CLOSE
A constant specifying how a COMMIT or ROLLBACK operation affects cursors and prepared statements in the data source (the behavior of the data source when you commit a transaction). Close cursors. For prepared statements, the application can execute on the statement without preparing again. Used for DSI_CURSOR_COMMIT_BEHAVIOR, DSI_CURSOR_ROLLBACK_BEHAVIOR.

See Also:
Constant Field Values

SQL_CB_PRESERVE

public static final long SQL_CB_PRESERVE
A constant specifying how a COMMIT or ROLLBACK operation affects cursors and prepared statements in the data source (the behavior of the data source when you commit a transaction). Preserve cursors in the same position as before the COMMIT or ROLLBACK operation. The application can continue to fetch data, or it can close the cursor and re-execute the statement without re-preparing it. Used for DSI_CURSOR_COMMIT_BEHAVIOR, DSI_CURSOR_ROLLBACK_BEHAVIOR.

See Also:
Constant Field Values

SQL_INSENSITIVE

public static final long SQL_INSENSITIVE
A constant specifying the support for cursor sensitivity, indicating all cursors on the statement handle show the result set without reflecting any changes that were made to it by any other cursor within the same transaction. Used for DSI_CURSOR_SENSITIVITY.

See Also:
Constant Field Values

SQL_UNSPECIFIED

public static final long SQL_UNSPECIFIED
A constant specifying the support for cursor sensitivity, indicating whether cursors on the statement handle make visible the changes that were made to a result set by another cursor within the same transaction. Cursors on the statement handle may make visible none, some, or all such changes. Used for DSI_CURSOR_SENSITIVITY.

See Also:
Constant Field Values

SQL_SENSITIVE

public static final long SQL_SENSITIVE
A constant specifying the support for cursor sensitivity, indicating cursors are sensitive to changes that were made by other cursors within the same transaction. Used for DSI_CURSOR_SENSITIVITY.

See Also:
Constant Field Values

SQL_DI_CREATE_INDEX

public static final long SQL_DI_CREATE_INDEX
A constant specifying support for creation and dropping of indexes. Used for DSI_DDL_INDEX.

See Also:
Constant Field Values

SQL_DI_DROP_INDEX

public static final long SQL_DI_DROP_INDEX
A constant specifying support for creation and dropping of indexes. Used for DSI_DDL_INDEX.

See Also:
Constant Field Values

SQL_TXN_READ_UNCOMMITTED

public static final long SQL_TXN_READ_UNCOMMITTED
A constant specifying the default transaction isolation level supported by the driver or data source, or zero if the data source does not support transactions. Used for DSI_DEFAULT_TXN_ISOLATION.

See Also:
Constant Field Values

SQL_TXN_READ_COMMITTED

public static final long SQL_TXN_READ_COMMITTED
A constant specifying the default transaction isolation level supported by the driver or data source, or zero if the data source does not support transactions. Used for DSI_DEFAULT_TXN_ISOLATION.

See Also:
Constant Field Values

SQL_TXN_REPEATABLE_READ

public static final long SQL_TXN_REPEATABLE_READ
A constant specifying the default transaction isolation level supported by the driver or data source, or zero if the data source does not support transactions. Used for DSI_DEFAULT_TXN_ISOLATION.

See Also:
Constant Field Values

SQL_TXN_SERIALIZABLE

public static final long SQL_TXN_SERIALIZABLE
A constant specifying the default transaction isolation level supported by the driver or data source, or zero if the data source does not support transactions. Used for DSI_DEFAULT_TXN_ISOLATION.

See Also:
Constant Field Values

SQL_DA_DROP_ASSERTION

public static final long SQL_DA_DROP_ASSERTION
Bitmask enumerating the clauses in the DROP ASSERTION statement, as defined in SQL-92, supported by the data source. Used for DSI_DROP_ASSERTION.

See Also:
Constant Field Values

SQL_DCS_DROP_CHARACTER_SET

public static final long SQL_DCS_DROP_CHARACTER_SET
Bitmask enumerating the clauses in the DROP CHARACTER SET statement, as defined in SQL-92, supported by the data source. Used for DSI_DROP_CHARACTER_SET.

See Also:
Constant Field Values

SQL_DC_DROP_COLLATION

public static final long SQL_DC_DROP_COLLATION
Bitmask enumerating the clauses in the DROP COLLATION statement, as defined in SQL-92, supported by the data source. Used for DSI_DROP_COLLATION.

See Also:
Constant Field Values

SQL_DD_DROP_DOMAIN

public static final long SQL_DD_DROP_DOMAIN
Bitmask enumerating the clauses in the DROP DOMAIN statement, as defined in SQL-92, supported by the data source. Used for DSI_DROP_DOMAIN.

See Also:
Constant Field Values

SQL_DD_CASCADE

public static final long SQL_DD_CASCADE
Bitmask enumerating the clauses in the DROP DOMAIN statement, as defined in SQL-92, supported by the data source. Used for DSI_DROP_DOMAIN.

See Also:
Constant Field Values

SQL_DD_RESTRICT

public static final long SQL_DD_RESTRICT
Bitmask enumerating the clauses in the DROP DOMAIN statement, as defined in SQL-92, supported by the data source. Used for DSI_DROP_DOMAIN.

See Also:
Constant Field Values

SQL_DS_DROP_SCHEMA

public static final long SQL_DS_DROP_SCHEMA
Bitmask enumerating the clauses in the DROP SCHEMA statement, as defined in SQL-92, supported by the data source. Used for DSI_DROP_SCHEMA.

See Also:
Constant Field Values

SQL_DS_CASCADE

public static final long SQL_DS_CASCADE
Bitmask enumerating the clauses in the DROP SCHEMA statement, as defined in SQL-92, supported by the data source. Used for DSI_DROP_SCHEMA.

See Also:
Constant Field Values

SQL_DS_RESTRICT

public static final long SQL_DS_RESTRICT
Bitmask enumerating the clauses in the DROP SCHEMA statement, as defined in SQL-92, supported by the data source. Used for DSI_DROP_SCHEMA.

See Also:
Constant Field Values

SQL_DT_DROP_TABLE

public static final long SQL_DT_DROP_TABLE
Bitmask enumerating the clauses in the DROP TABLE statement, as defined in SQL-92, supported by the data source. Used for DSI_DROP_TABLE.

See Also:
Constant Field Values

SQL_DT_CASCADE

public static final long SQL_DT_CASCADE
Bitmask enumerating the clauses in the DROP TABLE statement, as defined in SQL-92, supported by the data source. Used for DSI_DROP_TABLE.

See Also:
Constant Field Values

SQL_DT_RESTRICT

public static final long SQL_DT_RESTRICT
Bitmask enumerating the clauses in the DROP TABLE statement, as defined in SQL-92, supported by the data source. Used for DSI_DROP_TABLE.

See Also:
Constant Field Values

SQL_DTR_DROP_TRANSLATION

public static final long SQL_DTR_DROP_TRANSLATION
Bitmask enumerating the clauses in the DROP TRANSLATION statement, as defined in SQL-92, supported by the data source. Used for DSI_DROP_TRANSLATION.

See Also:
Constant Field Values

SQL_DV_DROP_VIEW

public static final long SQL_DV_DROP_VIEW
Bitmask enumerating the clauses in the DROP VIEW statement, as defined in SQL-92, supported by the data source. Used for DSI_DROP_VIEW.

See Also:
Constant Field Values

SQL_DV_CASCADE

public static final long SQL_DV_CASCADE
Bitmask enumerating the clauses in the DROP VIEW statement, as defined in SQL-92, supported by the data source. Used for DSI_DROP_VIEW.

See Also:
Constant Field Values

SQL_DV_RESTRICT

public static final long SQL_DV_RESTRICT
Bitmask enumerating the clauses in the DROP VIEW statement, as defined in SQL-92, supported by the data source. Used for DSI_DROP_VIEW.

See Also:
Constant Field Values

SQL_GB_COLLATE

public static final long SQL_GB_COLLATE
A constant specifying the relationship between the columns in the GROUP BY clause and the nonaggregated columns in the select list, indicates a COLLATE clause can be specified at the end of each grouping column. Used for DSI_GROUP_BY.

See Also:
Constant Field Values

SQL_GB_NOT_SUPPORTED

public static final long SQL_GB_NOT_SUPPORTED
A constant specifying the relationship between the columns in the GROUP BY clause and the nonaggregated columns in the select list, indicates GROUP BY clauses are not supported. Used for DSI_GROUP_BY.

See Also:
Constant Field Values

SQL_GB_GROUP_BY_EQUALS_SELECT

public static final long SQL_GB_GROUP_BY_EQUALS_SELECT
A constant specifying the relationship between the columns in the GROUP BY clause and the nonaggregated columns in the select list, indicates the GROUP BY clause must contain all nonaggregated columns in the select list. It cannot contain any other columns. Used for DSI_GROUP_BY.

See Also:
Constant Field Values

SQL_GB_GROUP_BY_CONTAINS_SELECT

public static final long SQL_GB_GROUP_BY_CONTAINS_SELECT
A constant specifying the relationship between the columns in the GROUP BY clause and the nonaggregated columns in the select list, indicates the GROUP BY clause must contain all nonaggregated columns in the select list. It can contain columns that are not in the select list. Used for DSI_GROUP_BY.

See Also:
Constant Field Values

SQL_GB_NO_RELATION

public static final long SQL_GB_NO_RELATION
A constant specifying the relationship between the columns in the GROUP BY clause and the nonaggregated columns in the select list, indicates the columns in the GROUP BY clause and the select list are not related. The meaning of nongrouped, nonaggregated columns in the select list is data source-dependent. Used for DSI_GROUP_BY.

See Also:
Constant Field Values

SQL_IC_UPPER

public static final char SQL_IC_UPPER
A constant specifying identifiers in SQL are not case-sensitive and are stored in uppercase in system catalog. Used for DSI_IDENTIFIER_CASE.

See Also:
Constant Field Values

SQL_IC_LOWER

public static final char SQL_IC_LOWER
A constant specifying identifiers in SQL are not case-sensitive and are stored in lowercase in system catalog. Used for DSI_IDENTIFIER_CASE.

See Also:
Constant Field Values

SQL_IC_SENSITIVE

public static final char SQL_IC_SENSITIVE
A constant specifying identifiers in SQL are case sensitive and are stored in mixed case in system catalog. Used for DSI_IDENTIFIER_CASE.

See Also:
Constant Field Values

SQL_IC_MIXED

public static final char SQL_IC_MIXED
A constant specifying identifiers in SQL are not case-sensitive and are stored in mixed case in system catalog. Used for DSI_IDENTIFIER_CASE.

See Also:
Constant Field Values

SQL_IK_NONE

public static final long SQL_IK_NONE
Bitmask enumerates keywords in the CREATE INDEX statement that are supported by the driver, indicates non of the keywords are supported. Used for DSI_INDEX_KEYWORDS.

See Also:
Constant Field Values

SQL_IK_ASC

public static final long SQL_IK_ASC
Bitmask enumerates keywords in the CREATE INDEX statement that are supported by the driver, indicates ASC keyword is supported. Used for DSI_INDEX_KEYWORDS.

See Also:
Constant Field Values

SQL_IK_DESC

public static final long SQL_IK_DESC
Bitmask enumerates keywords in the CREATE INDEX statement that are supported by the driver, indicates DESC keyword is supported Used for DSI_INDEX_KEYWORDS.

See Also:
Constant Field Values

SQL_IK_ALL

public static final long SQL_IK_ALL
Bitmask enumerates keywords in the CREATE INDEX statement that are supported by the driver, indicates all keywords are supported. Used for DSI_INDEX_KEYWORDS.

See Also:
Constant Field Values

SQL_IS_INSERT_LITERALS

public static final long SQL_IS_INSERT_LITERALS
Bitmask enumerating support for INSERT statements. Used for DSI_INSERT_STATEMENT.

See Also:
Constant Field Values

SQL_IS_INSERT_SEARCHED

public static final long SQL_IS_INSERT_SEARCHED
Bitmask enumerating support for INSERT statements. Used for DSI_INSERT_STATEMENT.

See Also:
Constant Field Values

SQL_IS_SELECT_INTO

public static final long SQL_IS_SELECT_INTO
Bitmask enumerating support for INSERT statements. Used for DSI_INSERT_STATEMENT.

See Also:
Constant Field Values

SQL_NNC_NULL

public static final long SQL_NNC_NULL
A constant specifying whether the data source supports NOT NULL in columns, indicates all columns must be nullable. Used for DSI_NON_NULLABLE_COLUMNS.

See Also:
Constant Field Values

SQL_NNC_NON_NULL

public static final long SQL_NNC_NON_NULL
A constant specifying whether the data source supports NOT NULL in columns, indicates columns cannot be nullable. Used for DSI_NON_NULLABLE_COLUMNS.

See Also:
Constant Field Values

SQL_NC_END

public static final long SQL_NC_END
A constant specifying where NULLs are sorted in a result set, indicates NULLs are sorted at the end of the result set, regardless of the ASC or DESC keywords. Used for DSI_NULL_COLLATION.

See Also:
Constant Field Values

SQL_NC_HIGH

public static final long SQL_NC_HIGH
A constant specifying where NULLs are sorted in a result set, indicates NULLs are sorted at the high end of the result set, depending on the ASC or DESC keywords. Used for DSI_NULL_COLLATION.

See Also:
Constant Field Values

SQL_NC_LOW

public static final long SQL_NC_LOW
A constant specifying where NULLs are sorted in a result set, indicates NULLs are sorted at the low end of the result set, depending on the ASC or DESC keywords. Used for DSI_NULL_COLLATION.

See Also:
Constant Field Values

SQL_NC_START

public static final long SQL_NC_START
A constant specifying where NULLs are sorted in a result set, indicates NULLs are sorted at the start of the result set, regardless of the ASC or DESC keywords. Used for DSI_NULL_COLLATION.

See Also:
Constant Field Values

SQL_FN_NUM_ABS

public static final long SQL_FN_NUM_ABS
Bitmask enumerating the scalar numeric functions supported by the driver and associated data source. Used for DSI_NUMERIC_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_NUM_ACOS

public static final long SQL_FN_NUM_ACOS
Bitmask enumerating the scalar numeric functions supported by the driver and associated data source. Used for DSI_NUMERIC_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_NUM_ASIN

public static final long SQL_FN_NUM_ASIN
Bitmask enumerating the scalar numeric functions supported by the driver and associated data source. Used for DSI_NUMERIC_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_NUM_ATAN

public static final long SQL_FN_NUM_ATAN
Bitmask enumerating the scalar numeric functions supported by the driver and associated data source. Used for DSI_NUMERIC_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_NUM_ATAN2

public static final long SQL_FN_NUM_ATAN2
Bitmask enumerating the scalar numeric functions supported by the driver and associated data source. Used for DSI_NUMERIC_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_NUM_CEILING

public static final long SQL_FN_NUM_CEILING
Bitmask enumerating the scalar numeric functions supported by the driver and associated data source. Used for DSI_NUMERIC_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_NUM_COS

public static final long SQL_FN_NUM_COS
Bitmask enumerating the scalar numeric functions supported by the driver and associated data source. Used for DSI_NUMERIC_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_NUM_COT

public static final long SQL_FN_NUM_COT
Bitmask enumerating the scalar numeric functions supported by the driver and associated data source. Used for DSI_NUMERIC_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_NUM_DEGREES

public static final long SQL_FN_NUM_DEGREES
Bitmask enumerating the scalar numeric functions supported by the driver and associated data source. Used for DSI_NUMERIC_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_NUM_EXP

public static final long SQL_FN_NUM_EXP
Bitmask enumerating the scalar numeric functions supported by the driver and associated data source. Used for DSI_NUMERIC_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_NUM_FLOOR

public static final long SQL_FN_NUM_FLOOR
Bitmask enumerating the scalar numeric functions supported by the driver and associated data source. Used for DSI_NUMERIC_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_NUM_LOG

public static final long SQL_FN_NUM_LOG
Bitmask enumerating the scalar numeric functions supported by the driver and associated data source. Used for DSI_NUMERIC_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_NUM_LOG10

public static final long SQL_FN_NUM_LOG10
Bitmask enumerating the scalar numeric functions supported by the driver and associated data source. Used for DSI_NUMERIC_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_NUM_MOD

public static final long SQL_FN_NUM_MOD
Bitmask enumerating the scalar numeric functions supported by the driver and associated data source. Used for DSI_NUMERIC_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_NUM_PI

public static final long SQL_FN_NUM_PI
Bitmask enumerating the scalar numeric functions supported by the driver and associated data source. Used for DSI_NUMERIC_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_NUM_POWER

public static final long SQL_FN_NUM_POWER
Bitmask enumerating the scalar numeric functions supported by the driver and associated data source. Used for DSI_NUMERIC_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_NUM_RADIANS

public static final long SQL_FN_NUM_RADIANS
Bitmask enumerating the scalar numeric functions supported by the driver and associated data source. Used for DSI_NUMERIC_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_NUM_RAND

public static final long SQL_FN_NUM_RAND
Bitmask enumerating the scalar numeric functions supported by the driver and associated data source. Used for DSI_NUMERIC_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_NUM_ROUND

public static final long SQL_FN_NUM_ROUND
Bitmask enumerating the scalar numeric functions supported by the driver and associated data source. Used for DSI_NUMERIC_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_NUM_SIGN

public static final long SQL_FN_NUM_SIGN
Bitmask enumerating the scalar numeric functions supported by the driver and associated data source. Used for DSI_NUMERIC_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_NUM_SIN

public static final long SQL_FN_NUM_SIN
Bitmask enumerating the scalar numeric functions supported by the driver and associated data source. Used for DSI_NUMERIC_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_NUM_SQRT

public static final long SQL_FN_NUM_SQRT
Bitmask enumerating the scalar numeric functions supported by the driver and associated data source. Used for DSI_NUMERIC_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_NUM_TAN

public static final long SQL_FN_NUM_TAN
Bitmask enumerating the scalar numeric functions supported by the driver and associated data source. Used for DSI_NUMERIC_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_NUM_TRUNCATE

public static final long SQL_FN_NUM_TRUNCATE
Bitmask enumerating the scalar numeric functions supported by the driver and associated data source. Used for DSI_NUMERIC_FUNCTIONS.

See Also:
Constant Field Values

SQL_OJ_LEFT

public static final long SQL_OJ_LEFT
Bitmask enumerating the types of outer joins supported by the driver and data source, indicates left outer joins are supported. Used for DSI_OJ_CAPABILITIES.

See Also:
Constant Field Values

SQL_OJ_RIGHT

public static final long SQL_OJ_RIGHT
Bitmask enumerating the types of outer joins supported by the driver and data source, indicates right outer joins are supported. Used for DSI_OJ_CAPABILITIES.

See Also:
Constant Field Values

SQL_OJ_FULL

public static final long SQL_OJ_FULL
Bitmask enumerating the types of outer joins supported by the driver and data source, indicates full outer joins are supported. Used for DSI_OJ_CAPABILITIES.

See Also:
Constant Field Values

SQL_OJ_NESTED

public static final long SQL_OJ_NESTED
Bitmask enumerating the types of outer joins supported by the driver and data source, indicates nested outer joins are supported. Used for DSI_OJ_CAPABILITIES.

See Also:
Constant Field Values

SQL_OJ_NOT_ORDERED

public static final long SQL_OJ_NOT_ORDERED
Bitmask enumerating the types of outer joins supported by the driver and data source, indicates the column names in the ON clause of the outer join do not have to be in the same order as their respective table names in the OUTER JOIN clause. Used for DSI_OJ_CAPABILITIES.

See Also:
Constant Field Values

SQL_OJ_INNER

public static final long SQL_OJ_INNER
Bitmask enumerating the types of outer joins supported by the driver and data source, indicates the inner table (the right table in a left outer join or the left table in a right outer join) can also be used in an inner join. This does not apply to full outer joins, which do not have an inner table. Used for DSI_OJ_CAPABILITIES.

See Also:
Constant Field Values

SQL_OJ_ALL_COMPARISON_OPS

public static final long SQL_OJ_ALL_COMPARISON_OPS
Bitmask enumerating the types of outer joins supported by the driver and data source, indicates the comparison operator in the ON clause can be any of the ODBC comparison operators. If this bit is not set, only the equals (=) comparison operator can be used in outer joins. Used for DSI_OJ_CAPABILITIES.

See Also:
Constant Field Values

SQL_SU_DML_STATEMENTS

public static final long SQL_SU_DML_STATEMENTS
Bitmask enumerating the statements in which schemas can be used, indicates schemas are supported in all Data Manipulation Language statements: SELECT, INSERT, UPDATE, DELETE, and if supported, SELECT FOR UPDATE and positioned update and delete statements. Used for DSI_SCHEMA_USAGE.

See Also:
Constant Field Values

SQL_SU_PROCEDURE_INVOCATION

public static final long SQL_SU_PROCEDURE_INVOCATION
Bitmask enumerating the statements in which schemas can be used, indicates schemas are supported in the ODBC procedure invocation statement. Used for DSI_SCHEMA_USAGE.

See Also:
Constant Field Values

SQL_SU_TABLE_DEFINITION

public static final long SQL_SU_TABLE_DEFINITION
Bitmask enumerating the statements in which schemas can be used, indicates schemas are supported in all table definition statements: CREATE TABLE, CREATE VIEW, ALTER TABLE, DROP TABLE, and DROP VIEW. Used for DSI_SCHEMA_USAGE.

See Also:
Constant Field Values

SQL_SU_INDEX_DEFINITION

public static final long SQL_SU_INDEX_DEFINITION
Bitmask enumerating the statements in which schemas can be used, indicates schemas are supported in all index definition statements: CREATE INDEX and DROP INDEX. Used for DSI_SCHEMA_USAGE.

See Also:
Constant Field Values

SQL_SU_PRIVILEGE_DEFINITION

public static final long SQL_SU_PRIVILEGE_DEFINITION
Bitmask enumerating the statements in which schemas can be used, indicates schemas are supported in all privilege definition statements: GRANT and REVOKE. Used for DSI_SCHEMA_USAGE.

See Also:
Constant Field Values

SQL_SC_SQL92_ENTRY

public static final long SQL_SC_SQL92_ENTRY
A constant specifying the level of SQL-92 supported by the driver, indicates entry level SQL-92 compliant. Used for DSI_SQL_CONFORMANCE.

See Also:
Constant Field Values

SQL_SC_FIPS127_2_TRANSITIONAL

public static final long SQL_SC_FIPS127_2_TRANSITIONAL
A constant specifying the level of SQL-92 supported by the driver, indicates FIPS 127-2 transitional level compliant. Used for DSI_SQL_CONFORMANCE.

See Also:
Constant Field Values

SQL_SC_SQL92_FULL

public static final long SQL_SC_SQL92_FULL
A constant specifying the level of SQL-92 supported by the driver, indicates full level SQL-92 compliant. Used for DSI_SQL_CONFORMANCE.

See Also:
Constant Field Values

SQL_SC_SQL92_INTERMEDIATE

public static final long SQL_SC_SQL92_INTERMEDIATE
A constant specifying the level of SQL-92 supported by the driver, indicates intermediate level SQL-92 compliant. Used for DSI_SQL_CONFORMANCE.

See Also:
Constant Field Values

SQL_FN_STR_ASCII

public static final long SQL_FN_STR_ASCII
Bitmask enumerating the scalar string functions supported by the driver and associated data source. Used for DSI_STRING_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_STR_BIT_LENGTH

public static final long SQL_FN_STR_BIT_LENGTH
Bitmask enumerating the scalar string functions supported by the driver and associated data source. Used for DSI_STRING_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_STR_CHAR

public static final long SQL_FN_STR_CHAR
Bitmask enumerating the scalar string functions supported by the driver and associated data source. Used for DSI_STRING_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_STR_CHAR_LENGTH

public static final long SQL_FN_STR_CHAR_LENGTH
Bitmask enumerating the scalar string functions supported by the driver and associated data source. Used for DSI_STRING_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_STR_CHARACTER_LENGTH

public static final long SQL_FN_STR_CHARACTER_LENGTH
Bitmask enumerating the scalar string functions supported by the driver and associated data source. Used for DSI_STRING_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_STR_CONCAT

public static final long SQL_FN_STR_CONCAT
Bitmask enumerating the scalar string functions supported by the driver and associated data source. Used for DSI_STRING_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_STR_DIFFERENCE

public static final long SQL_FN_STR_DIFFERENCE
Bitmask enumerating the scalar string functions supported by the driver and associated data source. Used for DSI_STRING_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_STR_INSERT

public static final long SQL_FN_STR_INSERT
Bitmask enumerating the scalar string functions supported by the driver and associated data source. Used for DSI_STRING_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_STR_LCASE

public static final long SQL_FN_STR_LCASE
Bitmask enumerating the scalar string functions supported by the driver and associated data source. Used for DSI_STRING_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_STR_LEFT

public static final long SQL_FN_STR_LEFT
Bitmask enumerating the scalar string functions supported by the driver and associated data source. Used for DSI_STRING_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_STR_LENGTH

public static final long SQL_FN_STR_LENGTH
Bitmask enumerating the scalar string functions supported by the driver and associated data source. Used for DSI_STRING_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_STR_LOCATE

public static final long SQL_FN_STR_LOCATE
Bitmask enumerating the scalar string functions supported by the driver and associated data source. Used for DSI_STRING_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_STR_LOCATE_2

public static final long SQL_FN_STR_LOCATE_2
Bitmask enumerating the scalar string functions supported by the driver and associated data source. Used for DSI_STRING_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_STR_LTRIM

public static final long SQL_FN_STR_LTRIM
Bitmask enumerating the scalar string functions supported by the driver and associated data source. Used for DSI_STRING_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_STR_OCTET_LENGTH

public static final long SQL_FN_STR_OCTET_LENGTH
Bitmask enumerating the scalar string functions supported by the driver and associated data source. Used for DSI_STRING_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_STR_POSITION

public static final long SQL_FN_STR_POSITION
Bitmask enumerating the scalar string functions supported by the driver and associated data source. Used for DSI_STRING_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_STR_REPEAT

public static final long SQL_FN_STR_REPEAT
Bitmask enumerating the scalar string functions supported by the driver and associated data source. Used for DSI_STRING_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_STR_REPLACE

public static final long SQL_FN_STR_REPLACE
Bitmask enumerating the scalar string functions supported by the driver and associated data source. Used for DSI_STRING_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_STR_RIGHT

public static final long SQL_FN_STR_RIGHT
Bitmask enumerating the scalar string functions supported by the driver and associated data source. Used for DSI_STRING_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_STR_RTRIM

public static final long SQL_FN_STR_RTRIM
Bitmask enumerating the scalar string functions supported by the driver and associated data source. Used for DSI_STRING_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_STR_SOUNDEX

public static final long SQL_FN_STR_SOUNDEX
Bitmask enumerating the scalar string functions supported by the driver and associated data source. Used for DSI_STRING_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_STR_SPACE

public static final long SQL_FN_STR_SPACE
Bitmask enumerating the scalar string functions supported by the driver and associated data source. Used for DSI_STRING_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_STR_SUBSTRING

public static final long SQL_FN_STR_SUBSTRING
Bitmask enumerating the scalar string functions supported by the driver and associated data source. Used for DSI_STRING_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_STR_UCASE

public static final long SQL_FN_STR_UCASE
Bitmask enumerating the scalar string functions supported by the driver and associated data source. Used for DSI_STRING_FUNCTIONS.

See Also:
Constant Field Values

SQL_SQ_CORRELATED_SUBQUERIES

public static final long SQL_SQ_CORRELATED_SUBQUERIES
Bitmask enumerating the predicates that support subqueries. Used for DSI_SUBQUERIES.

See Also:
Constant Field Values

SQL_SQ_COMPARISON

public static final long SQL_SQ_COMPARISON
Bitmask enumerating the predicates that support subqueries. Used for DSI_SUBQUERIES.

See Also:
Constant Field Values

SQL_SQ_EXISTS

public static final long SQL_SQ_EXISTS
Bitmask enumerating the predicates that support subqueries. Used for DSI_SUBQUERIES.

See Also:
Constant Field Values

SQL_SQ_IN

public static final long SQL_SQ_IN
Bitmask enumerating the predicates that support subqueries. Used for DSI_SUBQUERIES.

See Also:
Constant Field Values

SQL_SQ_QUANTIFIED

public static final long SQL_SQ_QUANTIFIED
Bitmask enumerating the predicates that support subqueries. Used for DSI_SUBQUERIES.

See Also:
Constant Field Values

SQL_FN_SYS_DBNAME

public static final long SQL_FN_SYS_DBNAME
Bitmask enumerating the timestamp intervals supported by the driver and associated data source for the scalar function. Used for DSI_TIMEDATE_ADD_INTERVALS, DSI_TIMEDATE_DIFF_INTERVALS.

See Also:
Constant Field Values

SQL_FN_SYS_IFNULL

public static final long SQL_FN_SYS_IFNULL
Bitmask enumerating the timestamp intervals supported by the driver and associated data source for the scalar function. Used for DSI_TIMEDATE_ADD_INTERVALS, DSI_TIMEDATE_DIFF_INTERVALS.

See Also:
Constant Field Values

SQL_FN_SYS_USERNAME

public static final long SQL_FN_SYS_USERNAME
Bitmask enumerating the timestamp intervals supported by the driver and associated data source for the scalar function. Used for DSI_TIMEDATE_ADD_INTERVALS, DSI_TIMEDATE_DIFF_INTERVALS.

See Also:
Constant Field Values

SQL_FN_TSI_FRAC_SECOND

public static final long SQL_FN_TSI_FRAC_SECOND
Bitmask enumerating the timestamp intervals supported by the driver and associated data source for the scalar function. Used for DSI_TIMEDATE_ADD_INTERVALS, DSI_TIMEDATE_DIFF_INTERVALS.

See Also:
Constant Field Values

SQL_FN_TSI_SECOND

public static final long SQL_FN_TSI_SECOND
Bitmask enumerating the timestamp intervals supported by the driver and associated data source for the scalar function. Used for DSI_TIMEDATE_ADD_INTERVALS, DSI_TIMEDATE_DIFF_INTERVALS.

See Also:
Constant Field Values

SQL_FN_TSI_MINUTE

public static final long SQL_FN_TSI_MINUTE
Bitmask enumerating the timestamp intervals supported by the driver and associated data source for the scalar function. Used for DSI_TIMEDATE_ADD_INTERVALS, DSI_TIMEDATE_DIFF_INTERVALS.

See Also:
Constant Field Values

SQL_FN_TSI_HOUR

public static final long SQL_FN_TSI_HOUR
Bitmask enumerating the timestamp intervals supported by the driver and associated data source for the scalar function. Used for DSI_TIMEDATE_ADD_INTERVALS, DSI_TIMEDATE_DIFF_INTERVALS.

See Also:
Constant Field Values

SQL_FN_TSI_DAY

public static final long SQL_FN_TSI_DAY
Bitmask enumerating the timestamp intervals supported by the driver and associated data source for the scalar function. Used for DSI_TIMEDATE_ADD_INTERVALS, DSI_TIMEDATE_DIFF_INTERVALS.

See Also:
Constant Field Values

SQL_FN_TSI_WEEK

public static final long SQL_FN_TSI_WEEK
Bitmask enumerating the timestamp intervals supported by the driver and associated data source for the scalar function. Used for DSI_TIMEDATE_ADD_INTERVALS, DSI_TIMEDATE_DIFF_INTERVALS.

See Also:
Constant Field Values

SQL_FN_TSI_MONTH

public static final long SQL_FN_TSI_MONTH
Bitmask enumerating the timestamp intervals supported by the driver and associated data source for the scalar function. Used for DSI_TIMEDATE_ADD_INTERVALS, DSI_TIMEDATE_DIFF_INTERVALS.

See Also:
Constant Field Values

SQL_FN_TSI_QUARTER

public static final long SQL_FN_TSI_QUARTER
Bitmask enumerating the timestamp intervals supported by the driver and associated data source for the scalar function. Used for DSI_TIMEDATE_ADD_INTERVALS, DSI_TIMEDATE_DIFF_INTERVALS.

See Also:
Constant Field Values

SQL_FN_TSI_YEAR

public static final long SQL_FN_TSI_YEAR
Bitmask enumerating the timestamp intervals supported by the driver and associated data source for the scalar function. Used for DSI_TIMEDATE_ADD_INTERVALS, DSI_TIMEDATE_DIFF_INTERVALS.

See Also:
Constant Field Values

SQL_FN_TD_CURRENT_DATE

public static final long SQL_FN_TD_CURRENT_DATE
Bitmask enumerating the scalar date and time functions supported by the driver and associated data source. Used for DSI_TIMEDATE_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_TD_CURRENT_TIME

public static final long SQL_FN_TD_CURRENT_TIME
Bitmask enumerating the scalar date and time functions supported by the driver and associated data source. Used for DSI_TIMEDATE_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_TD_CURRENT_TIMESTAMP

public static final long SQL_FN_TD_CURRENT_TIMESTAMP
Bitmask enumerating the scalar date and time functions supported by the driver and associated data source. Used for DSI_TIMEDATE_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_TD_CURDATE

public static final long SQL_FN_TD_CURDATE
Bitmask enumerating the scalar date and time functions supported by the driver and associated data source. Used for DSI_TIMEDATE_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_TD_CURTIME

public static final long SQL_FN_TD_CURTIME
Bitmask enumerating the scalar date and time functions supported by the driver and associated data source. Used for DSI_TIMEDATE_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_TD_DAYNAME

public static final long SQL_FN_TD_DAYNAME
Bitmask enumerating the scalar date and time functions supported by the driver and associated data source. Used for DSI_TIMEDATE_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_TD_DAYOFMONTH

public static final long SQL_FN_TD_DAYOFMONTH
Bitmask enumerating the scalar date and time functions supported by the driver and associated data source. Used for DSI_TIMEDATE_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_TD_DAYOFWEEK

public static final long SQL_FN_TD_DAYOFWEEK
Bitmask enumerating the scalar date and time functions supported by the driver and associated data source. Used for DSI_TIMEDATE_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_TD_DAYOFYEAR

public static final long SQL_FN_TD_DAYOFYEAR
Bitmask enumerating the scalar date and time functions supported by the driver and associated data source. Used for DSI_TIMEDATE_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_TD_EXTRACT

public static final long SQL_FN_TD_EXTRACT
Bitmask enumerating the scalar date and time functions supported by the driver and associated data source. Used for DSI_TIMEDATE_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_TD_HOUR

public static final long SQL_FN_TD_HOUR
Bitmask enumerating the scalar date and time functions supported by the driver and associated data source. Used for DSI_TIMEDATE_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_TD_MINUTE

public static final long SQL_FN_TD_MINUTE
Bitmask enumerating the scalar date and time functions supported by the driver and associated data source. Used for DSI_TIMEDATE_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_TD_MONTH

public static final long SQL_FN_TD_MONTH
Bitmask enumerating the scalar date and time functions supported by the driver and associated data source. Used for DSI_TIMEDATE_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_TD_MONTHNAME

public static final long SQL_FN_TD_MONTHNAME
Bitmask enumerating the scalar date and time functions supported by the driver and associated data source. Used for DSI_TIMEDATE_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_TD_NOW

public static final long SQL_FN_TD_NOW
Bitmask enumerating the scalar date and time functions supported by the driver and associated data source. Used for DSI_TIMEDATE_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_TD_QUARTER

public static final long SQL_FN_TD_QUARTER
Bitmask enumerating the scalar date and time functions supported by the driver and associated data source. Used for DSI_TIMEDATE_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_TD_SECOND

public static final long SQL_FN_TD_SECOND
Bitmask enumerating the scalar date and time functions supported by the driver and associated data source. Used for DSI_TIMEDATE_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_TD_TIMESTAMPADD

public static final long SQL_FN_TD_TIMESTAMPADD
Bitmask enumerating the scalar date and time functions supported by the driver and associated data source. Used for DSI_TIMEDATE_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_TD_TIMESTAMPDIFF

public static final long SQL_FN_TD_TIMESTAMPDIFF
Bitmask enumerating the scalar date and time functions supported by the driver and associated data source. Used for DSI_TIMEDATE_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_TD_WEEK

public static final long SQL_FN_TD_WEEK
Bitmask enumerating the scalar date and time functions supported by the driver and associated data source. Used for DSI_TIMEDATE_FUNCTIONS.

See Also:
Constant Field Values

SQL_FN_TD_YEAR

public static final long SQL_FN_TD_YEAR
Bitmask enumerating the scalar date and time functions supported by the driver and associated data source. Used for DSI_TIMEDATE_FUNCTIONS.

See Also:
Constant Field Values

SQL_TC_NONE

public static final char SQL_TC_NONE
A constant specifying the transaction support in the driver or data source, indicates transactions not supported. Used for DSI_TXN_CAPABLE.

See Also:
Constant Field Values

SQL_TC_DML

public static final char SQL_TC_DML
A constant specifying the transaction support in the driver or data source, indicates transactions can contain only Data Manipulation Language (DML) statements (SELECT, INSERT, UPDATE, DELETE). Data Definition Language (DDL) statements encountered in a transaction cause an error. Used for DSI_TXN_CAPABLE.

See Also:
Constant Field Values

SQL_TC_DDL_COMMIT

public static final char SQL_TC_DDL_COMMIT
A constant specifying the transaction support in the driver or data source, indicates transactions can contain only DML statements. DDL statements (CREATE TABLE, DROP INDEX, and so on) encountered in a transaction cause the transaction to be committed. Used for DSI_TXN_CAPABLE.

See Also:
Constant Field Values

SQL_TC_DDL_IGNORE

public static final char SQL_TC_DDL_IGNORE
A constant specifying the transaction support in the driver or data source, indicates transactions can contain only DML statements. DDL statements encountered in a transaction are ignored. Used for DSI_TXN_CAPABLE.

See Also:
Constant Field Values

SQL_TC_ALL

public static final char SQL_TC_ALL
A constant specifying the transaction support in the driver or data source, indicates transactions can contain DDL statements and DML statements in any order. Used for DSI_TXN_CAPABLE.

See Also:
Constant Field Values

SQL_U_UNION

public static final long SQL_U_UNION
Bitmask enumerating the support for the UNION clause, indicates data source supports the UNION clause. Used for DSI_UNION.

See Also:
Constant Field Values

SQL_U_UNION_ALL

public static final long SQL_U_UNION_ALL
Bitmask enumerating the support for the UNION clause, indicates data source supports the ALL keyword in the UNION clause. (SQLGetInfo returns both SQL_U_UNION and SQL_U_UNION_ALL in this case.) Used for DSI_UNION.

See Also:
Constant Field Values

SQL_OSC_MINIMUM

public static final short SQL_OSC_MINIMUM
A Constant specifying SQL grammar supported by the driver, indicates minimum grammar supported. Used for DSI_ODBC_SQL_CONFORMANCE.

See Also:
Constant Field Values

SQL_OSC_CORE

public static final short SQL_OSC_CORE
A Constant specifying SQL grammar supported by the driver, indicates core grammar supported. Used for DSI_ODBC_SQL_CONFORMANCE.

See Also:
Constant Field Values

SQL_OSC_EXTENDED

public static final short SQL_OSC_EXTENDED
A Constant specifying SQL grammar supported by the driver, indicates extended grammar supported. Used for DSI_ODBC_SQL_CONFORMANCE.

See Also:
Constant Field Values

SQL_ASYNC_DBC_NOT_CAPABLE

public static final long SQL_ASYNC_DBC_NOT_CAPABLE
A constant indicating that asynchronous connection functions execution is not supported. Used for DSI_ASYNC_DBC_FUNCTIONS.

See Also:
Constant Field Values

SQL_ASYNC_DBC_CAPABLE

public static final long SQL_ASYNC_DBC_CAPABLE
A constant indicating that asynchronous connection functions execution is supported. Used for DSI_ASYNC_DBC_FUNCTIONS.

See Also:
Constant Field Values

SQL_AM_NONE

public static final long SQL_AM_NONE
A constant specifying the level of asynchronous support in the driver, indicates asynchronous mode is not supported. Used for DSI_ASYNC_MODE.

See Also:
Constant Field Values

SQL_AM_CONNECTION

public static final long SQL_AM_CONNECTION
A constant specifying the level of asynchronous support in the driver, indicates connection level asynchronous execution is supported. Either all statement handles associated with a given connection handle are in asynchronous mode or all are in synchronous mode. A statement handle on a connection cannot be in asynchronous mode while another statement handle on the same connection is in synchronous mode, and vice versa. Used for DSI_ASYNC_MODE.

See Also:
Constant Field Values

SQL_AM_STATEMENT

public static final long SQL_AM_STATEMENT
A constant specifying the level of asynchronous support in the driver, indicates statement level asynchronous execution is supported. Some statement handles associated with a connection handle can be in asynchronous mode, while other statement handles on the same connection are in synchronous mode. Used for DSI_ASYNC_MODE.

See Also:
Constant Field Values

SQL_BRC_EXPLICIT

public static final long SQL_BRC_EXPLICIT
Bitmask enumerating the behavior of the driver with respect to the availability of row counts, indicates row counts, if any, are available when a batch is executed directly. If row counts are available, they can be rolled up or individually available, depending on the SQL_BRC_ROLLED_UP bit. Used for DSI_BATCH_ROW_COUNT.

See Also:
Constant Field Values

SQL_BRC_PROCEDURES

public static final long SQL_BRC_PROCEDURES
Bitmask enumerating the behavior of the driver with respect to the availability of row counts, indicates row counts, if any, are available when a batch is executed in a stored procedure. If row counts are available, they can be rolled up or individually available, depending on the SQL_BRC_ROLLED_UP bit. Used for DSI_BATCH_ROW_COUNT.

See Also:
Constant Field Values

SQL_BRC_ROLLED_UP

public static final long SQL_BRC_ROLLED_UP
Bitmask enumerating the behavior of the driver with respect to the availability of row counts, indicates row counts for consecutive INSERT, DELETE, or UPDATE statements are rolled up into one. If this bit is not set, row counts are available for each statement. Used for DSI_BATCH_ROW_COUNT.

See Also:
Constant Field Values

SQL_BS_ROW_COUNT_EXPLICIT

public static final long SQL_BS_ROW_COUNT_EXPLICIT
Bitmask enumerating the driver's support for batches, indicates driver supports explicit batches that can have row-count generating statements. Used for DSI_BATCH_SUPPORT.

See Also:
Constant Field Values

SQL_BS_ROW_COUNT_PROC

public static final long SQL_BS_ROW_COUNT_PROC
Bitmask enumerating the driver's support for batches, indicates driver supports explicit procedures that can have row-count generating statements. Used for DSI_BATCH_SUPPORT.

See Also:
Constant Field Values

SQL_BS_SELECT_EXPLICIT

public static final long SQL_BS_SELECT_EXPLICIT
Bitmask enumerating the driver's support for batches, indicates driver supports explicit batches that can have result-set generating statements. Used for DSI_BATCH_SUPPORT.

See Also:
Constant Field Values

SQL_BS_SELECT_PROC

public static final long SQL_BS_SELECT_PROC
Bitmask enumerating the driver's support for batches, indicates driver supports explicit procedures that can have result-set generating statements. Used for DSI_BATCH_SUPPORT.

See Also:
Constant Field Values

SQL_CA1_NEXT

public static final long SQL_CA1_NEXT
Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates a FetchOrientation argument of SQL_FETCH_NEXT is supported in a call to SQLFetchScroll when the cursor is a dynamic cursor. Used for DSI_DYNAMIC_CURSOR_ATTRIBUTES1.

See Also:
Constant Field Values

SQL_CA1_ABSOLUTE

public static final long SQL_CA1_ABSOLUTE
Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates FetchOrientation arguments of SQL_FETCH_FIRST, SQL_FETCH_LAST, and SQL_FETCH_ABSOLUTE are supported in a call to SQLFetchScroll when the cursor is a dynamic cursor. (The rowset that will be fetched is independent of the current cursor position). Used for DSI_DYNAMIC_CURSOR_ATTRIBUTES1.

See Also:
Constant Field Values

SQL_CA1_RELATIVE

public static final long SQL_CA1_RELATIVE
Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates FetchOrientation arguments of SQL_FETCH_PRIOR and SQL_FETCH_RELATIVE are supported in a call to SQLFetchScroll when the cursor is a dynamic cursor. (The rowset that will be fetched depends on the current cursor position. Note that this is separated from SQL_FETCH_NEXT because in a forward-only cursor, only SQL_FETCH_NEXT is supported.) Used for DSI_DYNAMIC_CURSOR_ATTRIBUTES1.

See Also:
Constant Field Values

SQL_CA1_BOOKMARK

public static final long SQL_CA1_BOOKMARK
Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates a FetchOrientation argument of SQL_FETCH_BOOKMARK is supported in a call to SQLFetchScroll when the cursor is a dynamic cursor. Used for DSI_DYNAMIC_CURSOR_ATTRIBUTES1.

See Also:
Constant Field Values

SQL_CA1_LOCK_EXCLUSIVE

public static final long SQL_CA1_LOCK_EXCLUSIVE
Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates a LockType argument of SQL_LOCK_EXCLUSIVE is supported in a call to SQLSetPos when the cursor is a dynamic cursor. Used for DSI_DYNAMIC_CURSOR_ATTRIBUTES1.

See Also:
Constant Field Values

SQL_CA1_LOCK_NO_CHANGE

public static final long SQL_CA1_LOCK_NO_CHANGE
Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates a LockType argument of SQL_LOCK_NO_CHANGE is supported in a call to SQLSetPos when the cursor is a dynamic cursor. Used for DSI_DYNAMIC_CURSOR_ATTRIBUTES1.

See Also:
Constant Field Values

SQL_CA1_LOCK_UNLOCK

public static final long SQL_CA1_LOCK_UNLOCK
Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates a LockType argument of SQL_LOCK_UNLOCK is supported in a call to SQLSetPos when the cursor is a dynamic cursor. Used for DSI_DYNAMIC_CURSOR_ATTRIBUTES1.

See Also:
Constant Field Values

SQL_CA1_POS_POSITION

public static final long SQL_CA1_POS_POSITION
Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates an Operation argument of SQL_POSITION is supported in a call to SQLSetPos when the cursor is a dynamic cursor. Used for DSI_DYNAMIC_CURSOR_ATTRIBUTES1.

See Also:
Constant Field Values

SQL_CA1_POS_UPDATE

public static final long SQL_CA1_POS_UPDATE
Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates an Operation argument of SQL_UPDATE is supported in a call to SQLSetPos when the cursor is a dynamic cursor. Used for DSI_DYNAMIC_CURSOR_ATTRIBUTES1.

See Also:
Constant Field Values

SQL_CA1_POS_DELETE

public static final long SQL_CA1_POS_DELETE
Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates an Operation argument of SQL_DELETE is supported in a call to SQLSetPos when the cursor is a dynamic cursor. Used for DSI_DYNAMIC_CURSOR_ATTRIBUTES1.

See Also:
Constant Field Values

SQL_CA1_POS_REFRESH

public static final long SQL_CA1_POS_REFRESH
Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates an Operation argument of SQL_REFRESH is supported in a call to SQLSetPos when the cursor is a dynamic cursor. Used for DSI_DYNAMIC_CURSOR_ATTRIBUTES1.

See Also:
Constant Field Values

SQL_CA1_POSITIONED_UPDATE

public static final long SQL_CA1_POSITIONED_UPDATE
Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates an UPDATE WHERE CURRENT OF SQL statement is supported when the cursor is a dynamic cursor. (An SQL-92 Entry level-conformant driver will always return this option as supported.) Used for DSI_DYNAMIC_CURSOR_ATTRIBUTES1.

See Also:
Constant Field Values

SQL_CA1_POSITIONED_DELETE

public static final long SQL_CA1_POSITIONED_DELETE
Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates a DELETE WHERE CURRENT OF SQL statement is supported when the cursor is a dynamic cursor. (An SQL-92 Entry level-conformant driver will always return this option as supported.) Used for DSI_DYNAMIC_CURSOR_ATTRIBUTES1.

See Also:
Constant Field Values

SQL_CA1_SELECT_FOR_UPDATE

public static final long SQL_CA1_SELECT_FOR_UPDATE
Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates a SELECT FOR UPDATE SQL statement is supported when the cursor is a dynamic cursor. (An SQL-92 Entry level-conformant driver will always return this option as supported.) Used for DSI_DYNAMIC_CURSOR_ATTRIBUTES1.

See Also:
Constant Field Values

SQL_CA1_BULK_ADD

public static final long SQL_CA1_BULK_ADD
Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates an Operation argument of SQL_ADD is supported in a call to SQLBulkOperations when the cursor is a dynamic cursor. Used for DSI_DYNAMIC_CURSOR_ATTRIBUTES1.

See Also:
Constant Field Values

SQL_CA1_BULK_UPDATE_BY_BOOKMARK

public static final long SQL_CA1_BULK_UPDATE_BY_BOOKMARK
Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates an Operation argument of SQL_UPDATE_BY_BOOKMARK is supported in a call to SQLBulkOperations when the cursor is a dynamic cursor. Used for DSI_DYNAMIC_CURSOR_ATTRIBUTES1.

See Also:
Constant Field Values

SQL_CA1_BULK_DELETE_BY_BOOKMARK

public static final long SQL_CA1_BULK_DELETE_BY_BOOKMARK
Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates an Operation argument of SQL_DELETE_BY_BOOKMARK is supported in a call to SQLBulkOperations when the cursor is a dynamic cursor. Used for DSI_DYNAMIC_CURSOR_ATTRIBUTES1.

See Also:
Constant Field Values

SQL_CA1_BULK_FETCH_BY_BOOKMARK

public static final long SQL_CA1_BULK_FETCH_BY_BOOKMARK
Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates an Operation argument of SQL_FETCH_BY_BOOKMARK is supported in a call to SQLBulkOperations when the cursor is a dynamic cursor. Used for DSI_DYNAMIC_CURSOR_ATTRIBUTES1.

See Also:
Constant Field Values

SQL_CA2_READ_ONLY_CONCURRENCY

public static final long SQL_CA2_READ_ONLY_CONCURRENCY
Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates a read-only dynamic cursor, in which no updates are allowed, is supported. (The SQL_ATTR_CONCURRENCY statement attribute can be SQL_CONCUR_READ_ONLY for a dynamic cursor). Used for DSI_DYNAMIC_CURSOR_ATTRIBUTES2.

See Also:
Constant Field Values

SQL_CA2_LOCK_CONCURRENCY

public static final long SQL_CA2_LOCK_CONCURRENCY
Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates a dynamic cursor that uses the lowest level of locking sufficient to make sure that the row can be updated is supported. (The SQL_ATTR_CONCURRENCY statement attribute can be SQL_CONCUR_LOCK for a dynamic cursor.) These locks must be consistent with the transaction isolation level set by the SQL_ATTR_TXN_ISOLATION connection attribute. Used for DSI_DYNAMIC_CURSOR_ATTRIBUTES2.

See Also:
Constant Field Values

SQL_CA2_OPT_ROWVER_CONCURRENCY

public static final long SQL_CA2_OPT_ROWVER_CONCURRENCY
Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates a dynamic cursor that uses the optimistic concurrency control comparing row versions is supported. (The SQL_ATTR_CONCURRENCY statement attribute can be SQL_CONCUR_ROWVER for a dynamic cursor.) Used for DSI_DYNAMIC_CURSOR_ATTRIBUTES2.

See Also:
Constant Field Values

SQL_CA2_OPT_VALUES_CONCURRENCY

public static final long SQL_CA2_OPT_VALUES_CONCURRENCY
Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates a dynamic cursor that uses the optimistic concurrency control comparing values is supported. (The SQL_ATTR_CONCURRENCY statement attribute can be SQL_CONCUR_VALUES for a dynamic cursor.) Used for DSI_DYNAMIC_CURSOR_ATTRIBUTES2.

See Also:
Constant Field Values

SQL_CA2_SENSITIVITY_ADDITIONS

public static final long SQL_CA2_SENSITIVITY_ADDITIONS
Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates added rows are visible to a dynamic cursor; the cursor can scroll to those rows. (Where these rows are added to the cursor is driver-dependent.) Used for DSI_DYNAMIC_CURSOR_ATTRIBUTES2.

See Also:
Constant Field Values

SQL_CA2_SENSITIVITY_DELETIONS

public static final long SQL_CA2_SENSITIVITY_DELETIONS
Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates deleted rows are no longer available to a dynamic cursor, and do not leave a "hole" in the result set; after the dynamic cursor scrolls from a deleted row, it cannot return to that row. Used for DSI_DYNAMIC_CURSOR_ATTRIBUTES2.

See Also:
Constant Field Values

SQL_CA2_SENSITIVITY_UPDATES

public static final long SQL_CA2_SENSITIVITY_UPDATES
Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates updates to rows are visible to a dynamic cursor; if the dynamic cursor scrolls from and returns to an updated row, the data returned by the cursor is the updated data, not the original data. Used for DSI_DYNAMIC_CURSOR_ATTRIBUTES2.

See Also:
Constant Field Values

SQL_CA2_MAX_ROWS_SELECT

public static final long SQL_CA2_MAX_ROWS_SELECT
Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates the SQL_ATTR_MAX_ROWS statement attribute affects SELECT statements when the cursor is a dynamic cursor. Used for DSI_DYNAMIC_CURSOR_ATTRIBUTES2.

See Also:
Constant Field Values

SQL_CA2_MAX_ROWS_INSERT

public static final long SQL_CA2_MAX_ROWS_INSERT
Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates the SQL_ATTR_MAX_ROWS statement attribute affects INSERT statements when the cursor is a dynamic cursor. Used for DSI_DYNAMIC_CURSOR_ATTRIBUTES2.

See Also:
Constant Field Values

SQL_CA2_MAX_ROWS_DELETE

public static final long SQL_CA2_MAX_ROWS_DELETE
Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates the SQL_ATTR_MAX_ROWS statement attribute affects DELETE statements when the cursor is a dynamic cursor. Used for DSI_DYNAMIC_CURSOR_ATTRIBUTES2.

See Also:
Constant Field Values

SQL_CA2_MAX_ROWS_UPDATE

public static final long SQL_CA2_MAX_ROWS_UPDATE
Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates the SQL_ATTR_MAX_ROWS statement attribute affects UPDATE statements when the cursor is a dynamic cursor. Used for DSI_DYNAMIC_CURSOR_ATTRIBUTES2.

See Also:
Constant Field Values

SQL_CA2_MAX_ROWS_CATALOG

public static final long SQL_CA2_MAX_ROWS_CATALOG
Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates the SQL_ATTR_MAX_ROWS statement attribute affects CATALOG result sets when the cursor is a dynamic cursor. Used for DSI_DYNAMIC_CURSOR_ATTRIBUTES2.

See Also:
Constant Field Values

SQL_CA2_MAX_ROWS_AFFECTS_ALL

public static final long SQL_CA2_MAX_ROWS_AFFECTS_ALL
Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates the SQL_ATTR_MAX_ROWS statement attribute affects SELECT, INSERT, DELETE, and UPDATE statements, and CATALOG result sets, when the cursor is a dynamic cursor. Used for DSI_DYNAMIC_CURSOR_ATTRIBUTES2.

See Also:
Constant Field Values

SQL_CA2_CRC_EXACT

public static final long SQL_CA2_CRC_EXACT
Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates the exact row count is available in the SQL_DIAG_CURSOR_ROW_COUNT diagnostic field when the cursor is a dynamic cursor. Used for DSI_DYNAMIC_CURSOR_ATTRIBUTES2.

See Also:
Constant Field Values

SQL_CA2_CRC_APPROXIMATE

public static final long SQL_CA2_CRC_APPROXIMATE
Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates an approximate row count is available in the SQL_DIAG_CURSOR_ROW_COUNT diagnostic field when the cursor is a dynamic cursor. Used for DSI_DYNAMIC_CURSOR_ATTRIBUTES2.

See Also:
Constant Field Values

SQL_CA2_SIMULATE_NON_UNIQUE

public static final long SQL_CA2_SIMULATE_NON_UNIQUE
Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates the driver does not guarantee that simulated positioned update or delete statements will affect only one row when the cursor is a dynamic cursor; it is the application's responsibility to guarantee this. To set this behavior, the application calls SQLSetStmtAttr with the SQL_ATTR_SIMULATE_CURSOR attribute set to SQL_SC_NON_UNIQUE. Used for DSI_DYNAMIC_CURSOR_ATTRIBUTES2.

See Also:
Constant Field Values

SQL_CA2_SIMULATE_TRY_UNIQUE

public static final long SQL_CA2_SIMULATE_TRY_UNIQUE
Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates the driver tries to guarantee that simulated positioned update or delete statements will affect only one row when the cursor is a dynamic cursor. The driver always executes such statements, even if they might affect more than one row, such as when there is no unique key. To set this behavior, the application calls SQLSetStmtAttr with the SQL_ATTR_SIMULATE_CURSOR attribute set to SQL_SC_TRY_UNIQUE. Used for DSI_DYNAMIC_CURSOR_ATTRIBUTES2.

See Also:
Constant Field Values

SQL_CA2_SIMULATE_UNIQUE

public static final long SQL_CA2_SIMULATE_UNIQUE
Bitmask enumerating the attributes of a dynamic cursor that are supported by the driver, indicates the driver guarantees that simulated positioned update or delete statements will affect only one row when the cursor is a dynamic cursor. If the driver cannot guarantee this for a given statement, SQLExecDirect or SQLPrepare return SQLSTATE 01001 (Cursor operation conflict). To set this behavior, the application calls SQLSetStmtAttr with the SQL_ATTR_SIMULATE_CURSOR attribute set to SQL_SC_UNIQUE. Used for DSI_DYNAMIC_CURSOR_ATTRIBUTES2.

See Also:
Constant Field Values

SQL_FILE_NOT_SUPPORTED

public static final char SQL_FILE_NOT_SUPPORTED
A constant specifying how a single-tier driver directly treats files in a data source, indicates driver is not a single-tier driver. Used for DSI_FILE_USAGE.

See Also:
Constant Field Values

SQL_FILE_TABLE

public static final char SQL_FILE_TABLE
A constant specifying how a single-tier driver directly treats files in a data source, indicates single-tier driver treats files in a data source as tables. Used for DSI_FILE_USAGE.

See Also:
Constant Field Values

SQL_FILE_CATALOG

public static final char SQL_FILE_CATALOG
A constant specifying how a single-tier driver directly treats files in a data source, indicates single-tier driver treats files in a data source as a catalog. Used for DSI_FILE_USAGE.

See Also:
Constant Field Values

SQL_ISV_ASSERTIONS

public static final long SQL_ISV_ASSERTIONS
Bitmask enumerating the views in the INFORMATION_SCHEMA that are supported by the driver, indicates the catalog's assertions that are owned by a given user. The views in, and the contents of, INFORMATION_SCHEMA are as defined in SQL-92. Used for DSI_INFO_SCHEMA_VIEWS.

See Also:
Constant Field Values

SQL_ISV_CHARACTER_SETS

public static final long SQL_ISV_CHARACTER_SETS
Bitmask enumerating the views in the INFORMATION_SCHEMA that are supported by the driver, indicates the catalog's character sets that can be accessed by a given user. The views in, and the contents of, INFORMATION_SCHEMA are as defined in SQL-92. Used for DSI_INFO_SCHEMA_VIEWS.

See Also:
Constant Field Values

SQL_ISV_CHECK_CONSTRAINTS

public static final long SQL_ISV_CHECK_CONSTRAINTS
Bitmask enumerating the views in the INFORMATION_SCHEMA that are supported by the driver, indicates the CHECK constraints that are owned by a given user. The views in, and the contents of, INFORMATION_SCHEMA are as defined in SQL-92. Used for DSI_INFO_SCHEMA_VIEWS.

See Also:
Constant Field Values

SQL_ISV_COLLATIONS

public static final long SQL_ISV_COLLATIONS
Bitmask enumerating the views in the INFORMATION_SCHEMA that are supported by the driver, indicates the character collations for the catalog that can be accessed by a given user. The views in, and the contents of, INFORMATION_SCHEMA are as defined in SQL-92. Used for DSI_INFO_SCHEMA_VIEWS.

See Also:
Constant Field Values

SQL_ISV_COLUMN_DOMAIN_USAGE

public static final long SQL_ISV_COLUMN_DOMAIN_USAGE
Bitmask enumerating the views in the INFORMATION_SCHEMA that are supported by the driver, indicates columns for the catalog that depend on domains defined in the catalog and are owned by a given user. The views in, and the contents of, INFORMATION_SCHEMA are as defined in SQL-92. Used for DSI_INFO_SCHEMA_VIEWS.

See Also:
Constant Field Values

SQL_ISV_COLUMN_PRIVILEGES

public static final long SQL_ISV_COLUMN_PRIVILEGES
Bitmask enumerating the views in the INFORMATION_SCHEMA that are supported by the driver, indicates the privileges on columns of persistent tables that are available to or granted by a given user. The views in, and the contents of, INFORMATION_SCHEMA are as defined in SQL-92. Used for DSI_INFO_SCHEMA_VIEWS.

See Also:
Constant Field Values

SQL_ISV_COLUMNS

public static final long SQL_ISV_COLUMNS
Bitmask enumerating the views in the INFORMATION_SCHEMA that are supported by the driver, indicates the columns of persistent tables that can be accessed by a given user. The views in, and the contents of, INFORMATION_SCHEMA are as defined in SQL-92. Used for DSI_INFO_SCHEMA_VIEWS.

See Also:
Constant Field Values

SQL_ISV_CONSTRAINT_COLUMN_USAGE

public static final long SQL_ISV_CONSTRAINT_COLUMN_USAGE
Bitmask enumerating the views in the INFORMATION_SCHEMA that are supported by the driver, indicates columns are identified for the various constraints that are owned by a given user. The views in, and the contents of, INFORMATION_SCHEMA are as defined in SQL-92. Used for DSI_INFO_SCHEMA_VIEWS.

See Also:
Constant Field Values

SQL_ISV_CONSTRAINT_TABLE_USAGE

public static final long SQL_ISV_CONSTRAINT_TABLE_USAGE
Bitmask enumerating the views in the INFORMATION_SCHEMA that are supported by the driver, indicates the tables that are used by constraints (referential, unique, and assertions), and are owned by a given user. The views in, and the contents of, INFORMATION_SCHEMA are as defined in SQL-92. Used for DSI_INFO_SCHEMA_VIEWS.

See Also:
Constant Field Values

SQL_ISV_DOMAIN_CONSTRAINTS

public static final long SQL_ISV_DOMAIN_CONSTRAINTS
Bitmask enumerating the views in the INFORMATION_SCHEMA that are supported by the driver, indicates the domain constraints (of the domains in the catalog) that can be accessed by a given user. The views in, and the contents of, INFORMATION_SCHEMA are as defined in SQL-92. Used for DSI_INFO_SCHEMA_VIEWS.

See Also:
Constant Field Values

SQL_ISV_DOMAINS

public static final long SQL_ISV_DOMAINS
Bitmask enumerating the views in the INFORMATION_SCHEMA that are supported by the driver, indicates the domains defined in a catalog that can be accessed by the user. The views in, and the contents of, INFORMATION_SCHEMA are as defined in SQL-92. Used for DSI_INFO_SCHEMA_VIEWS.

See Also:
Constant Field Values

SQL_ISV_KEY_COLUMN_USAGE

public static final long SQL_ISV_KEY_COLUMN_USAGE
Bitmask enumerating the views in the INFORMATION_SCHEMA that are supported by the driver, indicates columns defined in the catalog that are constrained as keys by a given user. The views in, and the contents of, INFORMATION_SCHEMA are as defined in SQL-92. Used for DSI_INFO_SCHEMA_VIEWS.

See Also:
Constant Field Values

SQL_ISV_REFERENTIAL_CONSTRAINTS

public static final long SQL_ISV_REFERENTIAL_CONSTRAINTS
Bitmask enumerating the views in the INFORMATION_SCHEMA that are supported by the driver, indicates the referential constraints that are owned by a given user. The views in, and the contents of, INFORMATION_SCHEMA are as defined in SQL-92. Used for DSI_INFO_SCHEMA_VIEWS.

See Also:
Constant Field Values

SQL_ISV_SCHEMATA

public static final long SQL_ISV_SCHEMATA
Bitmask enumerating the views in the INFORMATION_SCHEMA that are supported by the driver, indicates the schemas that are owned by a given user. The views in, and the contents of, INFORMATION_SCHEMA are as defined in SQL-92. Used for DSI_INFO_SCHEMA_VIEWS.

See Also:
Constant Field Values

SQL_ISV_SQL_LANGUAGES

public static final long SQL_ISV_SQL_LANGUAGES
Bitmask enumerating the views in the INFORMATION_SCHEMA that are supported by the driver, indicates the SQL conformance levels, options, and dialects supported by the SQL implementation. The views in, and the contents of, INFORMATION_SCHEMA are as defined in SQL-92. Used for DSI_INFO_SCHEMA_VIEWS.

See Also:
Constant Field Values

SQL_ISV_TABLE_CONSTRAINTS

public static final long SQL_ISV_TABLE_CONSTRAINTS
Bitmask enumerating the views in the INFORMATION_SCHEMA that are supported by the driver, indicates the table constraints that are owned by a given user. The views in, and the contents of, INFORMATION_SCHEMA are as defined in SQL-92. Used for DSI_INFO_SCHEMA_VIEWS.

See Also:
Constant Field Values

SQL_ISV_TABLE_PRIVILEGES

public static final long SQL_ISV_TABLE_PRIVILEGES
Bitmask enumerating the views in the INFORMATION_SCHEMA that are supported by the driver, indicates the privileges on persistent tables that are available to or granted by a given user. The views in, and the contents of, INFORMATION_SCHEMA are as defined in SQL-92. Used for DSI_INFO_SCHEMA_VIEWS.

See Also:
Constant Field Values

SQL_ISV_TABLES

public static final long SQL_ISV_TABLES
Bitmask enumerating the views in the INFORMATION_SCHEMA that are supported by the driver, indicates the persistent tables defined in a catalog that can be accessed by a given user. The views in, and the contents of, INFORMATION_SCHEMA are as defined in SQL-92. Used for DSI_INFO_SCHEMA_VIEWS.

See Also:
Constant Field Values

SQL_ISV_TRANSLATIONS

public static final long SQL_ISV_TRANSLATIONS
Bitmask enumerating the views in the INFORMATION_SCHEMA that are supported by the driver, indicates character translations for the catalog that can be accessed by a given user. The views in, and the contents of, INFORMATION_SCHEMA are as defined in SQL-92. Used for DSI_INFO_SCHEMA_VIEWS.

See Also:
Constant Field Values

SQL_ISV_USAGE_PRIVILEGES

public static final long SQL_ISV_USAGE_PRIVILEGES
Bitmask enumerating the views in the INFORMATION_SCHEMA that are supported by the driver, indicates the USAGE privileges on catalog objects that are available to or owned by a given user. The views in, and the contents of, INFORMATION_SCHEMA are as defined in SQL-92. Used for DSI_INFO_SCHEMA_VIEWS.

See Also:
Constant Field Values

SQL_ISV_VIEW_COLUMN_USAGE

public static final long SQL_ISV_VIEW_COLUMN_USAGE
Bitmask enumerating the views in the INFORMATION_SCHEMA that are supported by the driver, indicates the columns on which the catalog's views that are owned by a given user are dependent. The views in, and the contents of, INFORMATION_SCHEMA are as defined in SQL-92. Used for DSI_INFO_SCHEMA_VIEWS.

See Also:
Constant Field Values

SQL_ISV_VIEW_TABLE_USAGE

public static final long SQL_ISV_VIEW_TABLE_USAGE
Bitmask enumerating the views in the INFORMATION_SCHEMA that are supported by the driver, indicates the tables on which the catalog's views that are owned by a given user are dependent. The views in, and the contents of, INFORMATION_SCHEMA are as defined in SQL-92. Used for DSI_INFO_SCHEMA_VIEWS.

See Also:
Constant Field Values

SQL_ISV_VIEWS

public static final long SQL_ISV_VIEWS
Bitmask enumerating the views in the INFORMATION_SCHEMA that are supported by the driver, indicates the viewed tables defined in this catalog that can be accessed by a given user. The views in, and the contents of, INFORMATION_SCHEMA are as defined in SQL-92. Used for DSI_INFO_SCHEMA_VIEWS.

See Also:
Constant Field Values

SQL_OIC_CORE

public static final long SQL_OIC_CORE
A constant specifying the level of the ODBC 3.x interface that the driver complies with, indicates minimum level that all ODBC drivers are expected to comply with. This level includes basic interface elements such as connection functions, functions for preparing and executing an SQL statement, basic result set metadata functions, basic catalog functions, and so on. Used for DSI_ODBC_INTERFACE_CONFORMANCE.

See Also:
Constant Field Values

SQL_OIC_LEVEL1

public static final long SQL_OIC_LEVEL1
A constant specifying the level of the ODBC 3.x interface that the driver complies with, indicates level including the core standards compliance level functionality, plus scrollable cursors, bookmarks, positioned updates and deletes, and so on. Used for DSI_ODBC_INTERFACE_CONFORMANCE.

See Also:
Constant Field Values

SQL_OIC_LEVEL2

public static final long SQL_OIC_LEVEL2
A constant specifying the level of the ODBC 3.x interface that the driver complies with, indicates level including level 1 standards compliance level functionality, plus advanced features such as sensitive cursors; update, delete, and refresh by bookmarks; stored procedure support; catalog functions for primary and foreign keys; multi-catalog support; and so on. Used for DSI_ODBC_INTERFACE_CONFORMANCE.

See Also:
Constant Field Values

SQL_PARC_BATCH

public static final long SQL_PARC_BATCH
A constant specifying the driver's properties regarding the availability of row counts in a parameterized execution, indicates individual row counts are available for each set of parameters. This is conceptually equivalent to the driver generating a batch of SQL statements, one for each parameter set in the array. Extended error information can be retrieved by using the SQL_PARAM_STATUS_PTR descriptor field. Used for DSI_PARAM_ARRAY_ROW_COUNTS.

See Also:
Constant Field Values

SQL_PARC_NO_BATCH

public static final long SQL_PARC_NO_BATCH
A constant specifying the driver's properties regarding the availability of row counts in a parameterized execution, indicates there is only one row count available, which is the cumulative row count resulting from the execution of the statement for the entire array of parameters. This is conceptually equivalent to treating the statement together with the complete parameter array as one atomic unit. Errors are handled the same as if one statement were executed. Used for DSI_PARAM_ARRAY_ROW_COUNTS.

See Also:
Constant Field Values

SQL_PAS_BATCH

public static final long SQL_PAS_BATCH
A constant specifying the driver's properties regarding the availability of result sets in a parameterized execution, indicates there is one result set available per set of parameters. This is conceptually equivalent to the driver generating a batch of SQL statements, one for each parameter set in the array. Used for DSI_PARAM_ARRAY_SELECTS.

See Also:
Constant Field Values

SQL_PAS_NO_BATCH

public static final long SQL_PAS_NO_BATCH
A constant specifying the driver's properties regarding the availability of result sets in a parameterized execution, indicates there is only one result set available, which represents the cumulative result set resulting from the execution of the statement for the complete array of parameters. This is conceptually equivalent to treating the statement together with the complete parameter array as one atomic unit. Used for DSI_PARAM_ARRAY_SELECTS.

See Also:
Constant Field Values

SQL_PAS_NO_SELECT

public static final long SQL_PAS_NO_SELECT
A constant specifying the driver's properties regarding the availability of result sets in a parameterized execution, indicates driver does not allow a result-set generating statement to be executed with an array of parameters. Used for DSI_PARAM_ARRAY_SELECTS.

See Also:
Constant Field Values

SQL_RC_INSERT_SINGLE_ROWID

public static final long SQL_RC_INSERT_SINGLE_ROWID
A valid bitmask for SQL_CONN_RETURN_ESCAPE_CLAUSE. This driver supports returning SQL_BEST_ROWID columns from a single-row INSERT statement of the form 'INSERT INTO T1 VALUES(...)'

See Also:
Constant Field Values

SQL_RC_INSERT_SINGLE_ANY

public static final long SQL_RC_INSERT_SINGLE_ANY
A valid bitmask for SQL_CONN_RETURN_ESCAPE_CLAUSE. This driver supports returning any columns from a single-row INSERT statement of the form 'INSERT INTO T1 VALUES(...)'

See Also:
Constant Field Values

SQL_RC_INSERT_MULTIPLE_ROWID

public static final long SQL_RC_INSERT_MULTIPLE_ROWID
A valid bitmask for SQL_CONN_RETURN_ESCAPE_CLAUSE. This driver supports returning SQL_BEST_ROWID columns from a multi-row INSERT statement of the form 'INSERT INTO T1 VALUES (...), (...), ..., (...)'

See Also:
Constant Field Values

SQL_RC_INSERT_MULTIPLE_ANY

public static final long SQL_RC_INSERT_MULTIPLE_ANY
A valid bitmask for SQL_CONN_RETURN_ESCAPE_CLAUSE. This driver supports returning any columns from a multi-row INSERT statement of the form 'INSERT INTO T1 VALUES (...), (...), ..., (...)'

See Also:
Constant Field Values

SQL_RC_INSERT_SELECT_ROWID

public static final long SQL_RC_INSERT_SELECT_ROWID
A valid bitmask for SQL_CONN_RETURN_ESCAPE_CLAUSE. This driver supports returning SQL_BEST_ROWID columns from a 'INSERT INTO ... SELECT ...' statement.

See Also:
Constant Field Values

SQL_RC_INSERT_SELECT_ANY

public static final long SQL_RC_INSERT_SELECT_ANY
A valid bitmask for SQL_CONN_RETURN_ESCAPE_CLAUSE. This driver supports returning any columns from a 'INSERT INTO ... SELECT ...' statement.

See Also:
Constant Field Values

SQL_RC_UPDATE_ROWID

public static final long SQL_RC_UPDATE_ROWID
A valid bitmask for SQL_CONN_RETURN_ESCAPE_CLAUSE. This driver supports returning SQL_BEST_ROWID columns from an UPDATE statement.

See Also:
Constant Field Values

SQL_RC_UPDATE_ANY

public static final long SQL_RC_UPDATE_ANY
A valid bitmask for SQL_CONN_RETURN_ESCAPE_CLAUSE. This driver supports returning any columns from an UPDATE statement.

See Also:
Constant Field Values

SQL_RC_DELETE_ROWID

public static final long SQL_RC_DELETE_ROWID
A valid bitmask for SQL_CONN_RETURN_ESCAPE_CLAUSE. This driver supports returning SQL_BEST_ROWID columns from a DELETE statement.

See Also:
Constant Field Values

SQL_RC_DELETE_ANY

public static final long SQL_RC_DELETE_ANY
A valid bitmask for SQL_CONN_RETURN_ESCAPE_CLAUSE. This driver supports returning any columns from a DELETE statement.

See Also:
Constant Field Values

SQL_RC_SELECT_INTO_ROWID

public static final long SQL_RC_SELECT_INTO_ROWID
A valid bitmask for SQL_CONN_RETURN_ESCAPE_CLAUSE. This driver supports returning SQL_BEST_ROWID columns from a SELECT INTO statement.

See Also:
Constant Field Values

SQL_RC_SELECT_INTO_ANY

public static final long SQL_RC_SELECT_INTO_ANY
A valid bitmask for SQL_CONN_RETURN_ESCAPE_CLAUSE. This driver supports returning any columns from a SELECT INTO statement.

See Also:
Constant Field Values

SQL_SDF_CURRENT_DATE

public static final long SQL_SDF_CURRENT_DATE
Bitmask enumerating the datetime scalar functions that are supported by the driver and the associated data source, as defined in SQL-92. Used for DSI_SQL92_DATETIME_FUNCTIONS.

See Also:
Constant Field Values

SQL_SDF_CURRENT_TIME

public static final long SQL_SDF_CURRENT_TIME
Bitmask enumerating the datetime scalar functions that are supported by the driver and the associated data source, as defined in SQL-92. Used for DSI_SQL92_DATETIME_FUNCTIONS.

See Also:
Constant Field Values

SQL_SDF_CURRENT_TIMESTAMP

public static final long SQL_SDF_CURRENT_TIMESTAMP
Bitmask enumerating the datetime scalar functions that are supported by the driver and the associated data source, as defined in SQL-92. Used for DSI_SQL92_DATETIME_FUNCTIONS.

See Also:
Constant Field Values

SQL_SFKD_CASCADE

public static final long SQL_SFKD_CASCADE
Bitmask enumerating the rules supported for a foreign key in a DELETE statement, as defined in SQL-92. Used for DSI_SQL92_FOREIGN_KEY_DELETE_RULE.

See Also:
Constant Field Values

SQL_SFKD_NO_ACTION

public static final long SQL_SFKD_NO_ACTION
Bitmask enumerating the rules supported for a foreign key in a DELETE statement, as defined in SQL-92. Used for DSI_SQL92_FOREIGN_KEY_DELETE_RULE.

See Also:
Constant Field Values

SQL_SFKD_SET_DEFAULT

public static final long SQL_SFKD_SET_DEFAULT
Bitmask enumerating the rules supported for a foreign key in a DELETE statement, as defined in SQL-92. Used for DSI_SQL92_FOREIGN_KEY_DELETE_RULE.

See Also:
Constant Field Values

SQL_SFKD_SET_NULL

public static final long SQL_SFKD_SET_NULL
Bitmask enumerating the rules supported for a foreign key in a DELETE statement, as defined in SQL-92. Used for DSI_SQL92_FOREIGN_KEY_DELETE_RULE.

See Also:
Constant Field Values

SQL_SFKU_CASCADE

public static final long SQL_SFKU_CASCADE
Bitmask enumerating the rules supported for a foreign key in an UPDATE statement, as defined in SQL-92. Used for DSI_SQL92_FOREIGN_KEY_UPDATE_RULE.

See Also:
Constant Field Values

SQL_SFKU_NO_ACTION

public static final long SQL_SFKU_NO_ACTION
Bitmask enumerating the rules supported for a foreign key in an UPDATE statement, as defined in SQL-92. Used for DSI_SQL92_FOREIGN_KEY_UPDATE_RULE.

See Also:
Constant Field Values

SQL_SFKU_SET_DEFAULT

public static final long SQL_SFKU_SET_DEFAULT
Bitmask enumerating the rules supported for a foreign key in an UPDATE statement, as defined in SQL-92. Used for DSI_SQL92_FOREIGN_KEY_UPDATE_RULE.

See Also:
Constant Field Values

SQL_SFKU_SET_NULL

public static final long SQL_SFKU_SET_NULL
Bitmask enumerating the rules supported for a foreign key in an UPDATE statement, as defined in SQL-92. Used for DSI_SQL92_FOREIGN_KEY_UPDATE_RULE.

See Also:
Constant Field Values

SQL_SNVF_BIT_LENGTH

public static final long SQL_SNVF_BIT_LENGTH
Bitmask enumerating the numeric value scalar functions that are supported by the driver and the associated data source, as defined in SQL-92. Used for DSI_SQL92_NUMERIC_VALUE_FUNCTIONS.

See Also:
Constant Field Values

SQL_SNVF_CHAR_LENGTH

public static final long SQL_SNVF_CHAR_LENGTH
Bitmask enumerating the numeric value scalar functions that are supported by the driver and the associated data source, as defined in SQL-92. Used for DSI_SQL92_NUMERIC_VALUE_FUNCTIONS.

See Also:
Constant Field Values

SQL_SNVF_CHARACTER_LENGTH

public static final long SQL_SNVF_CHARACTER_LENGTH
Bitmask enumerating the numeric value scalar functions that are supported by the driver and the associated data source, as defined in SQL-92. Used for DSI_SQL92_NUMERIC_VALUE_FUNCTIONS.

See Also:
Constant Field Values

SQL_SNVF_EXTRACT

public static final long SQL_SNVF_EXTRACT
Bitmask enumerating the numeric value scalar functions that are supported by the driver and the associated data source, as defined in SQL-92. Used for DSI_SQL92_NUMERIC_VALUE_FUNCTIONS.

See Also:
Constant Field Values

SQL_SNVF_OCTET_LENGTH

public static final long SQL_SNVF_OCTET_LENGTH
Bitmask enumerating the numeric value scalar functions that are supported by the driver and the associated data source, as defined in SQL-92. Used for DSI_SQL92_NUMERIC_VALUE_FUNCTIONS.

See Also:
Constant Field Values

SQL_SNVF_POSITION

public static final long SQL_SNVF_POSITION
Bitmask enumerating the numeric value scalar functions that are supported by the driver and the associated data source, as defined in SQL-92. Used for DSI_SQL92_NUMERIC_VALUE_FUNCTIONS.

See Also:
Constant Field Values

SQL_SP_BETWEEN

public static final long SQL_SP_BETWEEN
Bitmask enumerating the predicates supported in a SELECT statement, as defined in SQL-92. Used for DSI_SQL92_PREDICATES.

See Also:
Constant Field Values

SQL_SP_COMPARISON

public static final long SQL_SP_COMPARISON
Bitmask enumerating the predicates supported in a SELECT statement, as defined in SQL-92. Used for DSI_SQL92_PREDICATES.

See Also:
Constant Field Values

SQL_SP_EXISTS

public static final long SQL_SP_EXISTS
Bitmask enumerating the predicates supported in a SELECT statement, as defined in SQL-92. Used for DSI_SQL92_PREDICATES.

See Also:
Constant Field Values

SQL_SP_IN

public static final long SQL_SP_IN
Bitmask enumerating the predicates supported in a SELECT statement, as defined in SQL-92. Used for DSI_SQL92_PREDICATES.

See Also:
Constant Field Values

SQL_SP_ISNOTNULL

public static final long SQL_SP_ISNOTNULL
Bitmask enumerating the predicates supported in a SELECT statement, as defined in SQL-92. Used for DSI_SQL92_PREDICATES.

See Also:
Constant Field Values

SQL_SP_ISNULL

public static final long SQL_SP_ISNULL
Bitmask enumerating the predicates supported in a SELECT statement, as defined in SQL-92. Used for DSI_SQL92_PREDICATES.

See Also:
Constant Field Values

SQL_SP_LIKE

public static final long SQL_SP_LIKE
Bitmask enumerating the predicates supported in a SELECT statement, as defined in SQL-92. Used for DSI_SQL92_PREDICATES.

See Also:
Constant Field Values

SQL_SP_MATCH_FULL

public static final long SQL_SP_MATCH_FULL
Bitmask enumerating the predicates supported in a SELECT statement, as defined in SQL-92. Used for DSI_SQL92_PREDICATES.

See Also:
Constant Field Values

SQL_SP_MATCH_PARTIAL

public static final long SQL_SP_MATCH_PARTIAL
Bitmask enumerating the predicates supported in a SELECT statement, as defined in SQL-92. Used for DSI_SQL92_PREDICATES.

See Also:
Constant Field Values

SQL_SP_MATCH_UNIQUE_FULL

public static final long SQL_SP_MATCH_UNIQUE_FULL
Bitmask enumerating the predicates supported in a SELECT statement, as defined in SQL-92. Used for DSI_SQL92_PREDICATES.

See Also:
Constant Field Values

SQL_SP_MATCH_UNIQUE_PARTIAL

public static final long SQL_SP_MATCH_UNIQUE_PARTIAL
Bitmask enumerating the predicates supported in a SELECT statement, as defined in SQL-92. Used for DSI_SQL92_PREDICATES.

See Also:
Constant Field Values

SQL_SP_OVERLAPS

public static final long SQL_SP_OVERLAPS
Bitmask enumerating the predicates supported in a SELECT statement, as defined in SQL-92. Used for DSI_SQL92_PREDICATES.

See Also:
Constant Field Values

SQL_SP_QUANTIFIED_COMPARISON

public static final long SQL_SP_QUANTIFIED_COMPARISON
Bitmask enumerating the predicates supported in a SELECT statement, as defined in SQL-92. Used for DSI_SQL92_PREDICATES.

See Also:
Constant Field Values

SQL_SP_UNIQUE

public static final long SQL_SP_UNIQUE
Bitmask enumerating the predicates supported in a SELECT statement, as defined in SQL-92. Used for DSI_SQL92_PREDICATES.

See Also:
Constant Field Values

SQL_SG_DELETE_TABLE

public static final long SQL_SG_DELETE_TABLE
Bitmask enumerating the clauses supported in the GRANT statement, as defined in SQL-92. Used for DSI_SQL92_GRANT.

See Also:
Constant Field Values

SQL_SG_INSERT_COLUMN

public static final long SQL_SG_INSERT_COLUMN
Bitmask enumerating the clauses supported in the GRANT statement, as defined in SQL-92. Used for DSI_SQL92_GRANT.

See Also:
Constant Field Values

SQL_SG_INSERT_TABLE

public static final long SQL_SG_INSERT_TABLE
Bitmask enumerating the clauses supported in the GRANT statement, as defined in SQL-92. Used for DSI_SQL92_GRANT.

See Also:
Constant Field Values

SQL_SG_REFERENCES_TABLE

public static final long SQL_SG_REFERENCES_TABLE
Bitmask enumerating the clauses supported in the GRANT statement, as defined in SQL-92. Used for DSI_SQL92_GRANT.

See Also:
Constant Field Values

SQL_SG_REFERENCES_COLUMN

public static final long SQL_SG_REFERENCES_COLUMN
Bitmask enumerating the clauses supported in the GRANT statement, as defined in SQL-92. Used for DSI_SQL92_GRANT.

See Also:
Constant Field Values

SQL_SG_SELECT_TABLE

public static final long SQL_SG_SELECT_TABLE
Bitmask enumerating the clauses supported in the GRANT statement, as defined in SQL-92. Used for DSI_SQL92_GRANT.

See Also:
Constant Field Values

SQL_SG_UPDATE_COLUMN

public static final long SQL_SG_UPDATE_COLUMN
Bitmask enumerating the clauses supported in the GRANT statement, as defined in SQL-92. Used for DSI_SQL92_GRANT.

See Also:
Constant Field Values

SQL_SG_UPDATE_TABLE

public static final long SQL_SG_UPDATE_TABLE
Bitmask enumerating the clauses supported in the GRANT statement, as defined in SQL-92. Used for DSI_SQL92_GRANT.

See Also:
Constant Field Values

SQL_SG_USAGE_ON_DOMAIN

public static final long SQL_SG_USAGE_ON_DOMAIN
Bitmask enumerating the clauses supported in the GRANT statement, as defined in SQL-92. Used for DSI_SQL92_GRANT.

See Also:
Constant Field Values

SQL_SG_USAGE_ON_CHARACTER_SET

public static final long SQL_SG_USAGE_ON_CHARACTER_SET
Bitmask enumerating the clauses supported in the GRANT statement, as defined in SQL-92. Used for DSI_SQL92_GRANT.

See Also:
Constant Field Values

SQL_SG_USAGE_ON_COLLATION

public static final long SQL_SG_USAGE_ON_COLLATION
Bitmask enumerating the clauses supported in the GRANT statement, as defined in SQL-92. Used for DSI_SQL92_GRANT.

See Also:
Constant Field Values

SQL_SG_USAGE_ON_TRANSLATION

public static final long SQL_SG_USAGE_ON_TRANSLATION
Bitmask enumerating the clauses supported in the GRANT statement, as defined in SQL-92. Used for DSI_SQL92_GRANT.

See Also:
Constant Field Values

SQL_SG_WITH_GRANT_OPTION

public static final long SQL_SG_WITH_GRANT_OPTION
Bitmask enumerating the clauses supported in the GRANT statement, as defined in SQL-92. Used for DSI_SQL92_GRANT.

See Also:
Constant Field Values

SQL_SRJO_CORRESPONDING_CLAUSE

public static final long SQL_SRJO_CORRESPONDING_CLAUSE
Bitmask enumerating the relational join operators supported in a SELECT statement, as defined in SQL-92. Used for DSI_SQL92_RELATIONAL_JOIN_OPERATORS.

See Also:
Constant Field Values

SQL_SRJO_CROSS_JOIN

public static final long SQL_SRJO_CROSS_JOIN
Bitmask enumerating the relational join operators supported in a SELECT statement, as defined in SQL-92. Used for DSI_SQL92_RELATIONAL_JOIN_OPERATORS.

See Also:
Constant Field Values

SQL_SRJO_EXCEPT_JOIN

public static final long SQL_SRJO_EXCEPT_JOIN
Bitmask enumerating the relational join operators supported in a SELECT statement, as defined in SQL-92. Used for DSI_SQL92_RELATIONAL_JOIN_OPERATORS.

See Also:
Constant Field Values

SQL_SRJO_FULL_OUTER_JOIN

public static final long SQL_SRJO_FULL_OUTER_JOIN
Bitmask enumerating the relational join operators supported in a SELECT statement, as defined in SQL-92. Used for DSI_SQL92_RELATIONAL_JOIN_OPERATORS.

See Also:
Constant Field Values

SQL_SRJO_INNER_JOIN

public static final long SQL_SRJO_INNER_JOIN
Bitmask enumerating the relational join operators supported in a SELECT statement, as defined in SQL-92. Used for DSI_SQL92_RELATIONAL_JOIN_OPERATORS.

See Also:
Constant Field Values

SQL_SRJO_INTERSECT_JOIN

public static final long SQL_SRJO_INTERSECT_JOIN
Bitmask enumerating the relational join operators supported in a SELECT statement, as defined in SQL-92. Used for DSI_SQL92_RELATIONAL_JOIN_OPERATORS.

See Also:
Constant Field Values

SQL_SRJO_LEFT_OUTER_JOIN

public static final long SQL_SRJO_LEFT_OUTER_JOIN
Bitmask enumerating the relational join operators supported in a SELECT statement, as defined in SQL-92. Used for DSI_SQL92_RELATIONAL_JOIN_OPERATORS.

See Also:
Constant Field Values

SQL_SRJO_NATURAL_JOIN

public static final long SQL_SRJO_NATURAL_JOIN
Bitmask enumerating the relational join operators supported in a SELECT statement, as defined in SQL-92. Used for DSI_SQL92_RELATIONAL_JOIN_OPERATORS.

See Also:
Constant Field Values

SQL_SRJO_RIGHT_OUTER_JOIN

public static final long SQL_SRJO_RIGHT_OUTER_JOIN
Bitmask enumerating the relational join operators supported in a SELECT statement, as defined in SQL-92. Used for DSI_SQL92_RELATIONAL_JOIN_OPERATORS.

See Also:
Constant Field Values

SQL_SRJO_UNION_JOIN

public static final long SQL_SRJO_UNION_JOIN
Bitmask enumerating the relational join operators supported in a SELECT statement, as defined in SQL-92. Used for DSI_SQL92_RELATIONAL_JOIN_OPERATORS.

See Also:
Constant Field Values

SQL_SR_CASCADE

public static final long SQL_SR_CASCADE
Bitmask enumerating the clauses supported in the REVOKE statement, as defined in SQL-92, supported by the data source. Used for DSI_SQL92_REVOKE.

See Also:
Constant Field Values

SQL_SR_DELETE_TABLE

public static final long SQL_SR_DELETE_TABLE
Bitmask enumerating the clauses supported in the REVOKE statement, as defined in SQL-92, supported by the data source. Used for DSI_SQL92_REVOKE.

See Also:
Constant Field Values

SQL_SR_GRANT_OPTION_FOR

public static final long SQL_SR_GRANT_OPTION_FOR
Bitmask enumerating the clauses supported in the REVOKE statement, as defined in SQL-92, supported by the data source. Used for DSI_SQL92_REVOKE.

See Also:
Constant Field Values

SQL_SR_INSERT_COLUMN

public static final long SQL_SR_INSERT_COLUMN
Bitmask enumerating the clauses supported in the REVOKE statement, as defined in SQL-92, supported by the data source. Used for DSI_SQL92_REVOKE.

See Also:
Constant Field Values

SQL_SR_INSERT_TABLE

public static final long SQL_SR_INSERT_TABLE
Bitmask enumerating the clauses supported in the REVOKE statement, as defined in SQL-92, supported by the data source. Used for DSI_SQL92_REVOKE.

See Also:
Constant Field Values

SQL_SR_REFERENCES_COLUMN

public static final long SQL_SR_REFERENCES_COLUMN
Bitmask enumerating the clauses supported in the REVOKE statement, as defined in SQL-92, supported by the data source. Used for DSI_SQL92_REVOKE.

See Also:
Constant Field Values

SQL_SR_REFERENCES_TABLE

public static final long SQL_SR_REFERENCES_TABLE
Bitmask enumerating the clauses supported in the REVOKE statement, as defined in SQL-92, supported by the data source. Used for DSI_SQL92_REVOKE.

See Also:
Constant Field Values

SQL_SR_RESTRICT

public static final long SQL_SR_RESTRICT
Bitmask enumerating the clauses supported in the REVOKE statement, as defined in SQL-92, supported by the data source. Used for DSI_SQL92_REVOKE.

See Also:
Constant Field Values

SQL_SR_SELECT_TABLE

public static final long SQL_SR_SELECT_TABLE
Bitmask enumerating the clauses supported in the REVOKE statement, as defined in SQL-92, supported by the data source. Used for DSI_SQL92_REVOKE.

See Also:
Constant Field Values

SQL_SR_UPDATE_COLUMN

public static final long SQL_SR_UPDATE_COLUMN
Bitmask enumerating the clauses supported in the REVOKE statement, as defined in SQL-92, supported by the data source. Used for DSI_SQL92_REVOKE.

See Also:
Constant Field Values

SQL_SR_UPDATE_TABLE

public static final long SQL_SR_UPDATE_TABLE
Bitmask enumerating the clauses supported in the REVOKE statement, as defined in SQL-92, supported by the data source. Used for DSI_SQL92_REVOKE.

See Also:
Constant Field Values

SQL_SR_USAGE_ON_DOMAIN

public static final long SQL_SR_USAGE_ON_DOMAIN
Bitmask enumerating the clauses supported in the REVOKE statement, as defined in SQL-92, supported by the data source. Used for DSI_SQL92_REVOKE.

See Also:
Constant Field Values

SQL_SR_USAGE_ON_CHARACTER_SET

public static final long SQL_SR_USAGE_ON_CHARACTER_SET
Bitmask enumerating the clauses supported in the REVOKE statement, as defined in SQL-92, supported by the data source. Used for DSI_SQL92_REVOKE.

See Also:
Constant Field Values

SQL_SR_USAGE_ON_COLLATION

public static final long SQL_SR_USAGE_ON_COLLATION
Bitmask enumerating the clauses supported in the REVOKE statement, as defined in SQL-92, supported by the data source. Used for DSI_SQL92_REVOKE.

See Also:
Constant Field Values

SQL_SR_USAGE_ON_TRANSLATION

public static final long SQL_SR_USAGE_ON_TRANSLATION
Bitmask enumerating the clauses supported in the REVOKE statement, as defined in SQL-92, supported by the data source. Used for DSI_SQL92_REVOKE.

See Also:
Constant Field Values

SQL_SRVC_VALUE_EXPRESSION

public static final long SQL_SRVC_VALUE_EXPRESSION
Bitmask enumerating the row value constructor expressions supported in a SELECT statement, as defined in SQL-92. Used for DSI_SQL92_ROW_VALUE_CONSTRUCTOR.

See Also:
Constant Field Values

SQL_SRVC_NULL

public static final long SQL_SRVC_NULL
Bitmask enumerating the row value constructor expressions supported in a SELECT statement, as defined in SQL-92. Used for DSI_SQL92_ROW_VALUE_CONSTRUCTOR.

See Also:
Constant Field Values

SQL_SRVC_DEFAULT

public static final long SQL_SRVC_DEFAULT
Bitmask enumerating the row value constructor expressions supported in a SELECT statement, as defined in SQL-92. Used for DSI_SQL92_ROW_VALUE_CONSTRUCTOR.

See Also:
Constant Field Values

SQL_SRVC_ROW_SUBQUERY

public static final long SQL_SRVC_ROW_SUBQUERY
Bitmask enumerating the row value constructor expressions supported in a SELECT statement, as defined in SQL-92. Used for DSI_SQL92_ROW_VALUE_CONSTRUCTOR.

See Also:
Constant Field Values

SQL_SSF_CONVERT

public static final long SQL_SSF_CONVERT
Bitmask enumerating the string scalar functions that are supported by the driver and the associated data source, as defined in SQL-92. Used for DSI_SQL92_STRING_FUNCTIONS.

See Also:
Constant Field Values

SQL_SSF_LOWER

public static final long SQL_SSF_LOWER
Bitmask enumerating the string scalar functions that are supported by the driver and the associated data source, as defined in SQL-92. Used for DSI_SQL92_STRING_FUNCTIONS.

See Also:
Constant Field Values

SQL_SSF_UPPER

public static final long SQL_SSF_UPPER
Bitmask enumerating the string scalar functions that are supported by the driver and the associated data source, as defined in SQL-92. Used for DSI_SQL92_STRING_FUNCTIONS.

See Also:
Constant Field Values

SQL_SSF_SUBSTRING

public static final long SQL_SSF_SUBSTRING
Bitmask enumerating the string scalar functions that are supported by the driver and the associated data source, as defined in SQL-92. Used for DSI_SQL92_STRING_FUNCTIONS.

See Also:
Constant Field Values

SQL_SSF_TRANSLATE

public static final long SQL_SSF_TRANSLATE
Bitmask enumerating the string scalar functions that are supported by the driver and the associated data source, as defined in SQL-92. Used for DSI_SQL92_STRING_FUNCTIONS.

See Also:
Constant Field Values

SQL_SSF_TRIM_BOTH

public static final long SQL_SSF_TRIM_BOTH
Bitmask enumerating the string scalar functions that are supported by the driver and the associated data source, as defined in SQL-92. Used for DSI_SQL92_STRING_FUNCTIONS.

See Also:
Constant Field Values

SQL_SSF_TRIM_LEADING

public static final long SQL_SSF_TRIM_LEADING
Bitmask enumerating the string scalar functions that are supported by the driver and the associated data source, as defined in SQL-92. Used for DSI_SQL92_STRING_FUNCTIONS.

See Also:
Constant Field Values

SQL_SSF_TRIM_TRAILING

public static final long SQL_SSF_TRIM_TRAILING
Bitmask enumerating the string scalar functions that are supported by the driver and the associated data source, as defined in SQL-92. Used for DSI_SQL92_STRING_FUNCTIONS.

See Also:
Constant Field Values

SQL_SVE_CASE

public static final long SQL_SVE_CASE
Bitmask enumerating the value expressions supported, as defined in SQL-92. Used for DSI_SQL92_VALUE_EXPRESSIONS.

See Also:
Constant Field Values

SQL_SVE_CAST

public static final long SQL_SVE_CAST
Bitmask enumerating the value expressions supported, as defined in SQL-92. Used for DSI_SQL92_VALUE_EXPRESSIONS.

See Also:
Constant Field Values

SQL_SVE_COALESCE

public static final long SQL_SVE_COALESCE
Bitmask enumerating the value expressions supported, as defined in SQL-92. Used for DSI_SQL92_VALUE_EXPRESSIONS.

See Also:
Constant Field Values

SQL_SVE_NULLIF

public static final long SQL_SVE_NULLIF
Bitmask enumerating the value expressions supported, as defined in SQL-92. Used for DSI_SQL92_VALUE_EXPRESSIONS.

See Also:
Constant Field Values

SQL_SCC_XOPEN_CLI_VERSION1

public static final long SQL_SCC_XOPEN_CLI_VERSION1
Bitmask enumerating the CLI standard or standards to which the driver conforms, indicates driver complies with the X/Open CLI version 1. Used for DSI_STANDARD_CLI_CONFORMANCE.

See Also:
Constant Field Values

SQL_SCC_ISO92_CLI

public static final long SQL_SCC_ISO92_CLI
Bitmask enumerating the CLI standard or standards to which the driver conforms, indicates driver complies with the ISO 92 CLI. Used for DSI_STANDARD_CLI_CONFORMANCE.

See Also:
Constant Field Values

SQL_REFRESH_NOW

public static final short SQL_REFRESH_NOW
SQL Value to indicate what type of OAuth token refreshing should happen. Indicates that the token should be refreshed immediately.

See Also:
Constant Field Values

SQL_REFRESH_AUTO

public static final short SQL_REFRESH_AUTO
SQL Value to indicate what type of OAuth token refreshing should happen. Indicates that the token should be refreshed whenever it expires.

See Also:
Constant Field Values

SQL_REFRESH_MANUAL

public static final short SQL_REFRESH_MANUAL
SQL Value to indicate what type of OAuth token refreshing should happen. Indicates that the token should not be refreshed.

See Also:
Constant Field Values

SQL_MAX_LENGTH_DEFAULT

public static final long SQL_MAX_LENGTH_DEFAULT
A constant specifying the default maximum amount of data that the driver returns from a character or binary column, which is defined to be 0 for the driver to return all data. Used for DSI_STMT_MAX_LENGTH.

See Also:
Constant Field Values

SQL_MAX_ROWS_DEFAULT

public static final long SQL_MAX_ROWS_DEFAULT
A constant specifying the default maximum number of rows to return to the application for a SELECT statement, which is defined to be 0 for driver to return all rows. Used for DSI_STMT_MAX_ROWS.

See Also:
Constant Field Values

SQL_QUERY_TIMEOUT_DEFAULT

public static final long SQL_QUERY_TIMEOUT_DEFAULT
A constant specifying the default number of seconds to wait for an SQL statement to execute before returning to the application, which is defined to be 0 for no timeout. Used for DSI_STMT_QUERY_TIMEOUT.

See Also:
Constant Field Values

SQL_RD_ON

public static final long SQL_RD_ON
A constant specifying the that the cursor retrieves data after it is positioned.

See Also:
Constant Field Values

SQL_RD_OFF

public static final long SQL_RD_OFF
A constant specifying the that the cursor does not retrieve data after it is positioned.

See Also:
Constant Field Values

SQL_NS_ON

public static final long SQL_NS_ON
A constant specifying that the driver does not scan SQL strings for escape sequences. Instead, the driver sends the statement directly to the data source.

See Also:
Constant Field Values

SQL_NS_OFF

public static final long SQL_NS_OFF
A constant specifying that the driver scans SQL strings for escape sequences.

See Also:
Constant Field Values
Constructor Detail

SqlConstants

public SqlConstants()


Copyright © 2006-2014 Simba Technologies Incorporated. All Rights Reserved.