com.simba.dsi.core.utilities
Class ConnPropertyKey

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

public class ConnPropertyKey
extends java.lang.Object

Constants of connection property keys supported by DSI.


Field Summary
static int DSI_ACCESSIBLE_PROCEDURES
          A String: "Y" if the user can execute all procedures returned by SQLProcedures; "N" if there may be procedures returned that the user cannot execute.
static int DSI_ACCESSIBLE_TABLES
          A String: "Y" if the user is guaranteed SELECT privileges to all tables returned by SQLTables; "N" if there may be tables returned that the user cannot access.
static int DSI_ADVANCED_CURSOR_TYPES
          A UINT16 bitmask indicating the advanced types of cursor that are supported by the DSI.
static int DSI_AGGREGATE_FUNCTIONS
          A UINT32 bitmask enumerating the driver's support for aggregation functions.
static int DSI_ALTER_DOMAIN
          A UINT32 bitmask enumerating the behavior of the driver with respect to the ALTER DOMAIN operation.
static int DSI_ALTER_TABLE
          A UINT32 bitmask enumerating the behavior of the driver with respect to the ALTER TABLE statement.
static int DSI_BATCH_ROW_COUNT
          A UINT32 bitmask enumerating the behaviour of the driver with respect to the availability of row counts.
static int DSI_BATCH_SUPPORT
          A UINT32 bitmask enumerating the driver's support for batches.
static int DSI_BOOKMARK_PERSISTENCE
          A UINT32 bitmask enumerating the operations through which bookmarks persist.
static int DSI_CATALOG_LOCATION
          A UINT16 specifying the position of the catalog in a qualified table name.
static int DSI_CATALOG_NAME
          A String: "Y" if the server supports catalog names "N" if the server does not support catalog names default: "Y"
static int DSI_CATALOG_NAME_SEPARATOR
          A String indicating the character or characters that the data source defines as the separator between a catalog name and the qualified name element that follows or precedes it.
static int DSI_CATALOG_TERM
          A String containing the data source vendor's name for a catalog.
static int DSI_CATALOG_USAGE
          A UINT32 bitmask enumerating the statements in which catalogs can be used.
static int DSI_COLLATION_SEQ
          A String that indicates the name of the default collation for the default character set for this server (e.g.
static int DSI_COLUMN_ALIAS
          A String indicating driver support for column aliasing.
static int DSI_CONCAT_NULL_BEHAVIOR
          A UINT16 indicating how the data source handles the concatenation of NULL valued character data type columns with non-NULL valued character data type columns.
static int DSI_CONN_ACCESS_MODE
          A UINT32 value indicating whether the connection is required to support SQL statements that cause updates to occur.
static int DSI_CONN_ALL
          All connection properties; used to cache values for all driver properties.
static int DSI_CONN_ANSI_APP
          An INT32 set by the ODBC Driver Manager to a unicode driver when the application is an ANSI application.
static int DSI_CONN_APP_CHAR_ENCODING
          MAINTENACE NOTE: In C++ DSI, DSI_CONN_APP_CHAR_ENCODING is a simba_int16 indicating which character encoding to convert to/from for SQL_C_CHAR data for each connection.
static int DSI_CONN_AUTO_IPD
          A read-only UINT32 value that specifies whether automatic population of the IPD after a call to SQLPrepare is supported.
static int DSI_CONN_AUTOCOMMIT
          A UINT32 value that specifies whether to use autocommit or manual-commit mode.
static int DSI_CONN_CONNECTION_DEAD
          A UINT32 value that specifies whether the connection is still active or not.
static int DSI_CONN_CONNECTION_STRING
          A string containing a connection string which can be used to achieve a valid connection.
static int DSI_CONN_CONNECTION_TIMEOUT
          A UINT32 value that specifies the number of seconds to wait for any request on the connection before returning to application.
static int DSI_CONN_CURRENT_CATALOG
          A character string containing the name of the catalog to be used by the data source.
static int DSI_CONN_CURRENT_SCHEMA
          A character string containing the name of the schema to be used by the data source.
static int DSI_CONN_DRIVER_NAME
          A string providing the name of the driver.
static int DSI_CONN_DRIVER_VER
          A string with the version of the driver and optionally, a description of the driver.
static int DSI_CONN_LOGIN_TIMEOUT
          A UINT32 value corresponding to the number of seconds to wait for a login request to complete before returning to the application.
static int DSI_CONN_PACKET_SIZE
          A UINT32 value specifying the network packet size in bytes.
static int DSI_CONN_QUIET_MODE
          A UINT32 window handle, parent window handle of the application used to display dialog boxes.
static int DSI_CONN_REFRESH_MODEL
          A UINT16 indicating what behaviour the driver should have around refreshing OAuth 1.0 or 2.0 access tokens.
static int DSI_CONN_RETURN_ESCAPE_CLAUSE
          A UINT32 bitmask describing this connection's support for the ODBC 4.0 'return' escape clause.
static int DSI_CONN_SAVEPOINT_IMPLICIT_BEGIN_TXN
          An INT32 value specifying the implicit begin of the transaction
static int DSI_CONN_SHOULD_COMPRESS
          ODBC only property.
static int DSI_CONN_TRANSACTION_ISOLATION
          A UINT32 bitmask that sets the transaction isolation level for the current connection.
static int DSI_CONVERT_FUNCTIONS
          A UINT32 bitmask enumerating the scalar conversion functions supported by the datasource.
static int DSI_CORRELATION_NAME
          A UINT16 indicating whether table correlation names are supported.
static int DSI_CREATE_ASSERTION
          A UINT32 bitmask enumerating the supported CREATE ASSERTION clauses.
static int DSI_CREATE_CHARACTER_SET
          A UINT32 bitmask enumerating the clauses in the CREATE CHARACTER SET statement.
static int DSI_CREATE_COLLATION
          A UINT32 bitmask enumerating the clauses in the CREATE COLLATION statement.
static int DSI_CREATE_DOMAIN
          A UINT32 bitmask enumerating the clauses in the CREATE DOMAIN statement.
static int DSI_CREATE_SCHEMA
          A UINT32 bitmask enumerating the clauses in the CREATE SCHEMA statement.
static int DSI_CREATE_TABLE
          A UINT32 bitmask enumerating the clauses in the CREATE TABLE statement.
static int DSI_CREATE_TRANSLATION
          A UINT32 bitmask enumerating the clauses in the CREATE TRANSLATION statement.
static int DSI_CREATE_VIEW
          A UINT32 bitmask enumerating the clauses in the CREATE VIEW statement.
static int DSI_CURSOR_COMMIT_BEHAVIOR
          A UINT16 indicating how a COMMIT operation affects cursors and prepared statements in the data source.
static int DSI_CURSOR_ROLLBACK_BEHAVIOR
          A UINT16 indicating how a ROLLBACK operation affects cursors and prepared statements in the data source.
static int DSI_CURSOR_SENSITIVITY
          A UINT32 indicating the support for cursor sensitivity.
static int DSI_DATA_SOURCE_READ_ONLY
          A String indicating the data source (NOT Driver level) read only characteristic.
static int DSI_DATETIME_LITERALS
          A UINT32 bitmask enumerating the SQL-92 datetime literals supported by the data source.
static int DSI_DBMS_NAME
          A String with the name of the DBMS product accessed by the driver.
static int DSI_DBMS_VER
          A String indicating the version of the DBMS product accessed by the driver.
static int DSI_DDL_INDEX
          A UINT32 indicating the support for creation and dropping of indexes.
static int DSI_DEFAULT_TXN_ISOLATION
          A UINT32 indicating the default transaction isolation level supported by the driver or data source A return value of "0" is given if transactions are not supported.
static int DSI_DESCRIBE_PARAMETER
          A String indicating whether parameters can be described.
static int DSI_DROP_ASSERTION
          A UINT32 bitmask enumerating the clauses in the DROP ASSERTION statement.
static int DSI_DROP_CHARACTER_SET
          A UINT32 bitmask enumerating the clauses in the DROP CHARACTER SET statement.
static int DSI_DROP_COLLATION
          A UINT32 bitmask enumerating the clauses in the DROP COLLATION statement.
static int DSI_DROP_DOMAIN
          A UINT32 bitmask enumerating the clauses in the DROP DOMAIN statement.
static int DSI_DROP_SCHEMA
          A UINT32 bitmask enumerating the clauses in the DROP SCHEMA statement.
static int DSI_DROP_TABLE
          A UINT32 bitmask enumerating the clauses in the DROP TABLE statement.
static int DSI_DROP_TRANSLATION
          A UINT32 bitmask enumerating the clauses in the DROP TRANSLATION statement.
static int DSI_DROP_VIEW
          A UINT32 bitmask enumerating the clauses in the DROP VIEW statement.
static int DSI_DYNAMIC_CURSOR_ATTRIBUTES1
          A UINT32 bitmask describes the attributes of a dynamic cursor that are supported by the driver.
static int DSI_DYNAMIC_CURSOR_ATTRIBUTES2
          A UINT32 bitmask that describes the attributes of a dynamic cursor that are supported by the driver.
static int DSI_EXPRESSIONS_IN_ORDERBY
          A String indicating if the data source supports expressions in the ORDER BY list.
static int DSI_FORWARD_ONLY_CURSOR_ATTRIBUTES1
          A UINT32 bitmask that describes the attributes of a forward-only cursor that are supported by the driver.
static int DSI_FORWARD_ONLY_CURSOR_ATTRIBUTES2
          A UINT32 bitmask that describes the attributes of a forward-only cursor that are supported by the driver.
static int DSI_GET_GENERATED_KEYS
          A String indicating if the data source supports getGeneratedKeys.
static int DSI_GROUP_BY
          A UINT16 indicating the relationship between the columns in the GROUP BY clause and the nonaggregated columns in the select list.
static int DSI_IDENTIFIER_CASE
          A UINT16 indicating the case sensitivity of identifiers stored in the system catalogue.
static int DSI_IDENTIFIER_QUOTE_CHAR
          A String indicating the starting and ending delimiter of a quoted (delimited) identifier in SQL statements.
static int DSI_INDEX_KEYWORDS
          A UINT32 bitmask enumerating the supported keywords in the CREATE INDEX statement.
static int DSI_INFO_SCHEMA_VIEWS
          A UINT32 bitmask enumerating the views in the INFORMATION_SCHEMA that are supported by the driver.
static int DSI_INSERT_STATEMENT
          A UINT32 bitmask that indicates support for INSERT statements.
static int DSI_INTEGRITY
          A String indicating if the data source supports the Integrity Enhancement Facility.
static int DSI_KEYSET_CURSOR_ATTRIBUTES1
          A UINT32 bitmask that describes the attributes of a keyset cursor that are supported by the driver.
static int DSI_KEYSET_CURSOR_ATTRIBUTES2
          A UINT32 bitmask that describes the attributes of a keyset cursor that are supported by the driver.
static int DSI_KEYWORDS
          A String containing a comma-separated list of all data source-specific keywords.
static int DSI_LIKE_ESCAPE_CLAUSE
          A String indicating if the data source supports an escape character for the percent character (%) and underscore character (_) in a LIKE predicate and the driver supports the ODBC syntax for defining a LIKE predicate escape character.
static int DSI_MAX_ASYNC_CONCURRENT_STATEMENTS
          A UINT32 value specifying the maximum number of active concurrent statements in asynchronous mode that the driver can support on a given connection.
static int DSI_MAX_BINARY_LITERAL_LEN
          A UINT32 value specifying the maximum length (number of hexadecimal characters of a binary literal in an SQL statement.
static int DSI_MAX_CATALOG_NAME_LEN
          A UINT16 value specifying the maximum length of a catalog name in the data source.
static int DSI_MAX_CHAR_LITERAL_LEN
          A UINT32 value specifying the maximum length (number of characters) of a character literal in an SQL statement.
static int DSI_MAX_COLUMN_NAME_LEN
          A UINT16 value specifying the maximum length of a column name in the data source.
static int DSI_MAX_COLUMNS_IN_GROUP_BY
          A UINT16 value specifying the maximum number of columns allowed in a GROUP BY clause.
static int DSI_MAX_COLUMNS_IN_INDEX
          A UINT16 value specifying the maximum number of columns allowed in an index.
static int DSI_MAX_COLUMNS_IN_ORDER_BY
          A UINT16 value specifying the maximum number of columns allowed in an ORDER BY clause.
static int DSI_MAX_COLUMNS_IN_SELECT
          A UINT16 value specifying the maximum number of columns allowed in a select list.
static int DSI_MAX_COLUMNS_IN_TABLE
          A UINT16 value specifying the maximum number of columns allowed in a table.
static int DSI_MAX_CONCURRENT_ACTIVITIES
          A UINT16 value specifying the maximum number of active statements that the driver can support for a connection.
static int DSI_MAX_CURSOR_NAME_LEN
          A UINT16 value specifying the maximum length of a cursor name in the data source.
static int DSI_MAX_IDENTIFIER_LEN
          A UINT16 that indicates the maximum size in characters that the data source supports for user-defined names
static int DSI_MAX_INDEX_SIZE
          A UINT32 value specifying the maximum number of bytes allowed in the combined fields of an index.
static int DSI_MAX_PARAMSET_COUNT
          A UINT32 indicating the maximum number of parameter sets that can be set to execute a query.
static int DSI_MAX_PROCEDURE_NAME_LEN
          A UINT16 value specifying the maximum length of a procedure name in the data source.
static int DSI_MAX_ROW_SIZE
          A UINT32 value specifying the maximum length of a single row in a table.
static int DSI_MAX_ROW_SIZE_INCLUDES_LONG
          A String indicating if the maximum row size returned for the SQL_MAX_ROW_SIZE information type includes the length of all SQL_LONGVARCHAR and SQL_LONGVARBINARY columns in the row.
static int DSI_MAX_SCHEMA_NAME_LEN
          A UINT16 value specifying the maximum length of a schema name in the data source.
static int DSI_MAX_STATEMENT_LEN
          A UINT32 value specifying the maximum length (number of characters, including white space) of an SQL statement.
static int DSI_MAX_TABLE_NAME_LEN
          A UINT16 value specifying the maximum length of a table name in the data source.
static int DSI_MAX_TABLES_IN_SELECT
          A UINT16 value specifying the maximum number of tables allowed in the FROM clause of a SELECT statement.
static int DSI_MAX_USER_NAME_LEN
          A UINT16 value specifying the maximum length of a user name in the data source.
static int DSI_MAX_VARBINARY_LEN
          An INT32 value specifying the maximum length of a VARBINARY type.
static int DSI_MAX_VARCHAR_LEN
          An INT32 value specifying the maximum length of a VARCHAR type.
static int DSI_MULT_RESULT_SETS
          A String indicating driver support for multiple result sets.
static int DSI_MULTIPLE_ACTIVE_TXN
          A String indicating driver support for more than one active transaction at a time.
static int DSI_NON_NULLABLE_COLUMNS
          A UINT16 indicating whether the data source supports NOT NULL in columns.
static int DSI_NULL_COLLATION
          A UINT16 value specifying where NULLs are sorted in a result set.
static int DSI_NUMERIC_FUNCTIONS
          A UINT32 bitmask enumerating the scalar numeric functions supported by the driver and associated data source.
static int DSI_ODBC_SQL_CONFORMANCE
          An INT16 value indicating SQL grammar supported by the driver.
static int DSI_OJ_CAPABILITIES
          A UINT32 bitmask enumerating the types of outer joins supported by the driver and data source.
static int DSI_ORDER_BY_COLUMNS_IN_SELECT
          A String indicating if the columns in the ORDER BY clause must be in the select list.
static int DSI_OUTER_JOINS
          A String indicating if OUTER JOINS are supported.
static int DSI_PARAM_ARRAY_ROW_COUNTS
          A UINT32 indicating if a parameterized statement using parameter arrays will return a row count for each parameter set or if an aggregate row count is returned.
static int DSI_PARAM_ARRAY_SELECTS
          A UINT32 enumerating the driver's properties regarding the availability of result sets in a parameterized execution.
static int DSI_PROCEDURE_TERM
          A String with the data source vendor's name for a procedure.
static int DSI_PROCEDURES
          A String indicating if the data source supports procedures and the driver supports the ODBC procedure invocation syntax.
static int DSI_QUOTED_IDENTIFIER_CASE
          A UINT16 value specifying the case sensitivity of quoted identifiers.
static int DSI_RESULT_SET_CHANGES_DETECTED
          An UINT32 bitmask indicating the level of support for detecting changes in result sets.
static int DSI_ROW_UPDATES
          A String: "Y" if a keyset-driven or mixed cursor maintains row versions or values for all fetched rows and therefore can detect any updates made to a row by any user since the row was last fetched.
static int DSI_SCHEMA_TERM
          A String containing the data source vendor's name for a schema.
static int DSI_SCHEMA_USAGE
          A UINT32 bitmask enumerating the statements in which schemas can be used.
static int DSI_SEARCH_PATTERN_ESCAPE
          A String specifying what the driver supports as an escape character that permits the use of the pattern match metacharacters underscore (_) and percent sign (%) as valid characters in search patterns.
static int DSI_SERVER_NAME
          A String containing the actual data source-specific server name.
static int DSI_SPECIAL_CHARACTERS
          A String containing all special characters that can be used in an identifier name on the data source.
static int DSI_SQL_CONFORMANCE
          A UINT32 value specifying the case sensitivity of quoted identifiers.
static int DSI_SQL92_DATETIME_FUNCTIONS
          A UINT32 bitmask enumerating the datetime scalar functions that are supported by the driver and the associated data source, as defined in SQL-92.
static int DSI_SQL92_FOREIGN_KEY_DELETE_RULE
          A UINT32 bitmask enumerating the rules supported for a foreign key in a DELETE statement, as defined in SQL-92.
static int DSI_SQL92_FOREIGN_KEY_UPDATE_RULE
          A UINT32 bitmask enumerating the rules supported for a foreign key in an UPDATE statement, as defined in SQL-92.
static int DSI_SQL92_GRANT
          A UINT32 bitmask enumerating the clauses supported in the GRANT statement, as defined in SQL-92.
static int DSI_SQL92_NUMERIC_VALUE_FUNCTIONS
          A UINT32 bitmask enumerating the numeric value scalar functions that are supported by the driver and the associated data source, as defined in SQL-92.
static int DSI_SQL92_PREDICATES
          A UINT32 bitmask enumerating the predicates supported in a SELECT statement, as defined in SQL-92.
static int DSI_SQL92_RELATIONAL_JOIN_OPERATORS
          A UINT32 bitmask enumerating the relational join operators supported in a SELECT statement, as defined in SQL-92.
static int DSI_SQL92_REVOKE
          A UINT32 bitmask enumerating the clauses supported in the REVOKE statement, as defined in SQL-92, supported by the data source.
static int DSI_SQL92_ROW_VALUE_CONSTRUCTOR
          A UINT32 bitmask enumerating the row value constructor expressions supported in a SELECT statement, as defined in SQL-92.
static int DSI_SQL92_STRING_FUNCTIONS
          A UINT32 bitmask enumerating the string scalar functions that are supported by the driver and the associated data source, as defined in SQL-92.
static int DSI_SQL92_VALUE_EXPRESSIONS
          A UINT32 bitmask enumerating the value expressions supported, as defined in SQL-92.
static int DSI_STATIC_CURSOR_ATTRIBUTES1
          A UINT32 bitmask that describes the attributes of a static cursor that are supported by the driver.
static int DSI_STATIC_CURSOR_ATTRIBUTES2
          A UINT32 bitmask that describes the attributes of a static cursor that are supported by the driver.
static int DSI_STREAM_BUFFER_SIZE
          An INT32 value specifying the chunk size used to retrieve data from the DSII for output streams (i.e.
static int DSI_STRING_FUNCTIONS
          A UINT32 bitmask enumerating the scalar string functions supported by the driver and associated data source.
static int DSI_SUBQUERIES
          A UINT32 bitmask enumerating the predicates that support subqueries.
static int DSI_SUPPORTED_SQL_BIGINT_CONVERSIONS
          A UINT32 bitmask indicates the conversions supported by the data source with the CONVERT scalar function.
static int DSI_SUPPORTED_SQL_BINARY_CONVERSIONS
          A UINT32 bitmask indicates the conversions supported by the data source with the CONVERT scalar function.
static int DSI_SUPPORTED_SQL_BIT_CONVERSIONS
          A UINT32 bitmask indicates the conversions supported by the data source with the CONVERT scalar function.
static int DSI_SUPPORTED_SQL_CHAR_CONVERSIONS
          A UINT32 bitmask indicates the conversions supported by the data source with the CONVERT scalar function.
static int DSI_SUPPORTED_SQL_DATE_CONVERSIONS
          A UINT32 bitmask indicates the conversions supported by the data source with the CONVERT scalar function.
static int DSI_SUPPORTED_SQL_DECIMAL_CONVERSIONS
          A UINT32 bitmask indicates the conversions supported by the data source with the CONVERT scalar function.
static int DSI_SUPPORTED_SQL_DOUBLE_CONVERSIONS
          A UINT32 bitmask indicates the conversions supported by the data source with the CONVERT scalar function.
static int DSI_SUPPORTED_SQL_FLOAT_CONVERSIONS
          A UINT32 bitmask indicates the conversions supported by the data source with the CONVERT scalar function.
static int DSI_SUPPORTED_SQL_GUID_CONVERSIONS
          A UINT32 bitmask indicates the conversions supported by the data source with the CONVERT scalar function.
static int DSI_SUPPORTED_SQL_INTEGER_CONVERSIONS
          A UINT32 bitmask indicates the conversions supported by the data source with the CONVERT scalar function.
static int DSI_SUPPORTED_SQL_INTERVAL_DAY_TIME_CONVERSIONS
          A UINT32 bitmask indicates the conversions supported by the data source with the CONVERT scalar function.
static int DSI_SUPPORTED_SQL_INTERVAL_YEAR_MONTH_CONVERSIONS
          A UINT32 bitmask indicates the conversions supported by the data source with the CONVERT scalar function.
static int DSI_SUPPORTED_SQL_LONGVARBINARY_CONVERSIONS
          A UINT32 bitmask indicates the conversions supported by the data source with the CONVERT scalar function.
static int DSI_SUPPORTED_SQL_LONGVARCHAR_CONVERSIONS
          A UINT32 bitmask indicates the conversions supported by the data source with the CONVERT scalar function.
static int DSI_SUPPORTED_SQL_NUMERIC_CONVERSIONS
          A UINT32 bitmask indicates the conversions supported by the data source with the CONVERT scalar function.
static int DSI_SUPPORTED_SQL_REAL_CONVERSIONS
          A UINT32 bitmask indicates the conversions supported by the data source with the CONVERT scalar function.
static int DSI_SUPPORTED_SQL_SMALLINT_CONVERSIONS
          A UINT32 bitmask indicates the conversions supported by the data source with the CONVERT scalar function.
static int DSI_SUPPORTED_SQL_TIME_CONVERSIONS
          A UINT32 bitmask indicates the conversions supported by the data source with the CONVERT scalar function.
static int DSI_SUPPORTED_SQL_TIMESTAMP_CONVERSIONS
          A UINT32 bitmask indicates the conversions supported by the data source with the CONVERT scalar function.
static int DSI_SUPPORTED_SQL_TINYINT_CONVERSIONS
          A UINT32 bitmask indicates the conversions supported by the data source with the CONVERT scalar function.
static int DSI_SUPPORTED_SQL_VARBINARY_CONVERSIONS
          A UINT32 bitmask indicates the conversions supported by the data source with the CONVERT scalar function.
static int DSI_SUPPORTED_SQL_VARCHAR_CONVERSIONS
          A UINT32 bitmask indicates the conversions supported by the data source with the CONVERT scalar function.
static int DSI_SUPPORTED_SQL_WCHAR_CONVERSIONS
          A UINT32 bitmask indicates the conversions supported by the data source with the CONVERT scalar function.
static int DSI_SUPPORTED_SQL_WLONGVARCHAR_CONVERSIONS
          A UINT32 bitmask indicates the conversions supported by the data source with the CONVERT scalar function.
static int DSI_SUPPORTED_SQL_WVARCHAR_CONVERSIONS
          A UINT32 bitmask indicates the conversions supported by the data source with the CONVERT scalar function.
static int DSI_SUPPORTS_SAVEPOINTS
          An INT16 value indicating if Savepoints are supported or not.
static int DSI_SUPPORTS_STORED_FUNCTIONS_USING_CALL_SYNTAX
          An INT16 value indicating if stored function calls are supported or not.
static int DSI_SUPPORTS_STREAMED_BATCH_PREPARED_STMTS
          A String: "Y" if streaming batched data is supported.
static int DSI_SUPPORTS_UPDATABLE_RESULT_SETS
          An UINT32 bitmask indicating the level of support for updatable result sets.
static int DSI_SYSTEM_FUNCTIONS
          A UINT32 bitmask enumerating the scalar system functions supported by the driver and associated data source.
static int DSI_TABLE_TERM
          A String containing the data source vendor's name for a table.
static int DSI_TIMEDATE_ADD_INTERVALS
          A UINT32 bitmask enumerating the timestamp intervals supported by the driver and associated data source for the TIMESTAMPADD scalar function.
static int DSI_TIMEDATE_DIFF_INTERVALS
          A UINT32 bitmask enumerating the timestamp intervals supported by the driver and associated data source for the TIMESTAMPDIFF scalar function.
static int DSI_TIMEDATE_FUNCTIONS
          A UINT32 bitmask enumerating the scalar date and time functions supported by the driver and associated data source.
static int DSI_TRANSLATE_LIB
          A simba_wstring corresponding to the SQL_ATTR_TRANSLATE_LIB connection attribute.
static int DSI_TRANSLATE_OPTION
          A simba_uint32 corresponding to the SQL_ATTR_TRANSLATE_OPTION connection attribute.
static int DSI_TXN_CAPABLE
          A UINT16 value describing the transaction support in the driver or data source.
static int DSI_TXN_ISOLATION_OPTION
          A UINT32 bitmask enumerating the transaction isolation levels available from the driver or data source.
static int DSI_UNION
          A UINT32 bitmask enumerating the support for the UNION clause.
static int DSI_USER_NAME
          A String containing the name used in a particular database, which can be different from the login name.
 
Constructor Summary
ConnPropertyKey()
           
 
Method Summary
static java.util.Set<java.lang.Integer> keySet()
          Get an unmodifiable set containing all of the ConnPropertyKey literals.
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

DSI_CONN_ALL

public static final int DSI_CONN_ALL
All connection properties; used to cache values for all driver properties.

See Also:
Constant Field Values

DSI_ACCESSIBLE_PROCEDURES

public static final int DSI_ACCESSIBLE_PROCEDURES
A String:

default: "Y"

See Also:
Constant Field Values

DSI_ACCESSIBLE_TABLES

public static final int DSI_ACCESSIBLE_TABLES
A String:

default: "Y"

See Also:
Constant Field Values

DSI_ADVANCED_CURSOR_TYPES

public static final int DSI_ADVANCED_CURSOR_TYPES
A UINT16 bitmask indicating the advanced types of cursor that are supported by the DSI. It is assumed that all data sources support forward-only cursors. This property covers the other sorts of ODBC cursors.

The bitmask is composed of OR'ing 0 or more of the following values:

default: 0

This bitmask defines the valid set of cursor types as defined in ConnPropertyValues that will be used when executing a query.

See Also:
Constant Field Values

DSI_AGGREGATE_FUNCTIONS

public static final int DSI_AGGREGATE_FUNCTIONS
A UINT32 bitmask enumerating the driver's support for aggregation functions.

The bitmask is composed of OR'ing 0 or more of the following values.

default:

See Also:
Constant Field Values

DSI_ALTER_DOMAIN

public static final int DSI_ALTER_DOMAIN
A UINT32 bitmask enumerating the behavior of the driver with respect to the ALTER DOMAIN operation.

The bitmask is composed of OR'ing 0 or more of the following values.

default:

See Also:
Constant Field Values

DSI_ALTER_TABLE

public static final int DSI_ALTER_TABLE
A UINT32 bitmask enumerating the behavior of the driver with respect to the ALTER TABLE statement.

The bitmask is composed of OR'ing 0 or more of the following values.

default:

See Also:
Constant Field Values

DSI_BOOKMARK_PERSISTENCE

public static final int DSI_BOOKMARK_PERSISTENCE
A UINT32 bitmask enumerating the operations through which bookmarks persist.

The bitmask is composed of OR'ing 0 or more of the following values.

default: 0

See Also:
Constant Field Values

DSI_CATALOG_LOCATION

public static final int DSI_CATALOG_LOCATION
A UINT16 specifying the position of the catalog in a qualified table name.

Possible values are:

default: DSI_CL_START

See Also:
Constant Field Values

DSI_CATALOG_NAME

public static final int DSI_CATALOG_NAME
A String: default: "Y"

See Also:
Constant Field Values

DSI_CATALOG_NAME_SEPARATOR

public static final int DSI_CATALOG_NAME_SEPARATOR
A String indicating the character or characters that the data source defines as the separator between a catalog name and the qualified name element that follows or precedes it. An empty string is returned if catalogs are not supported by the data source.

default: "."

See Also:
Constant Field Values

DSI_CATALOG_TERM

public static final int DSI_CATALOG_TERM
A String containing the data source vendor's name for a catalog. This string can be in upper, lower, or mixed case. An empty string is returned if catalogs are not supported.

default: "catalog"

See Also:
Constant Field Values

DSI_CATALOG_USAGE

public static final int DSI_CATALOG_USAGE
A UINT32 bitmask enumerating the statements in which catalogs can be used. A value of 0 is returned if catalogs are not supported.

The bitmask is composed of OR'ing 0 or more of the following values.

default:

See Also:
Constant Field Values

DSI_COLLATION_SEQ

public static final int DSI_COLLATION_SEQ
A String that indicates the name of the default collation for the default character set for this server (e.g. 'ISO 8859-1'). If this is unknown, an empty string will be returned.

default: ""

See Also:
Constant Field Values

DSI_COLUMN_ALIAS

public static final int DSI_COLUMN_ALIAS
A String indicating driver support for column aliasing. default: "Y"

See Also:
Constant Field Values

DSI_CONCAT_NULL_BEHAVIOR

public static final int DSI_CONCAT_NULL_BEHAVIOR
A UINT16 indicating how the data source handles the concatenation of NULL valued character data type columns with non-NULL valued character data type columns.

Possible values are:

default: DSI_CB_NULL

See Also:
Constant Field Values

DSI_CONN_ACCESS_MODE

public static final int DSI_CONN_ACCESS_MODE
A UINT32 value indicating whether the connection is 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 behaviour 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.

Possible values are:

default: DSI_MODE_READ_WRITE

See Also:
Constant Field Values

DSI_CONN_ANSI_APP

public static final int DSI_CONN_ANSI_APP
An INT32 set by the ODBC Driver Manager to a unicode driver when the application is an ANSI application. This is write-only and application does not set this attribute. This attribute was introduced because some unicode driver's some APIs may need to behave differently on ANSI or Unicode applications. A unicode driver, which has same behaviour for both ANSI or Unicode applications, should return error when the driver manager sets this connection attribute. When a unicode driver returns success on this attribute, the driver manager treats ANSI and Unicode connections differently in connection pooling.

Possible values are:

default: DSI_PROP_AA_FALSE

See Also:
Constant Field Values

DSI_CONN_AUTO_IPD

public static final int DSI_CONN_AUTO_IPD
A read-only UINT32 value that specifies whether automatic population of the IPD after a call to SQLPrepare is supported.

Possible values are:

default: DSI_PROP_AUTO_IPD_ON

See Also:
Constant Field Values

DSI_CONN_AUTOCOMMIT

public static final int DSI_CONN_AUTOCOMMIT
A UINT32 value that specifies whether to use autocommit or manual-commit mode.

Possible values are:

default: DSI_PROP_AUTOCOMMIT_ON

See Also:
Constant Field Values

DSI_CONN_CONNECTION_DEAD

public static final int DSI_CONN_CONNECTION_DEAD
A UINT32 value that specifies whether the connection is still active or not.

Possible values are:

default: DSI_PROP_CD_FALSE

See Also:
Constant Field Values

DSI_CONN_CONNECTION_TIMEOUT

public static final int DSI_CONN_CONNECTION_TIMEOUT
A UINT32 value that specifies the number of seconds to wait for any request on the connection before returning to application. If timeout value is 0, then the timeout is disabled and the connection waits indefinitely.

default: 0

See Also:
Constant Field Values

DSI_CONN_CURRENT_CATALOG

public static final int DSI_CONN_CURRENT_CATALOG
A character string containing the name of the catalog to be used by the data source.

default: ""

See Also:
Constant Field Values

DSI_CONN_LOGIN_TIMEOUT

public static final int DSI_CONN_LOGIN_TIMEOUT
A UINT32 value corresponding to the number of seconds to wait for a login request to complete before returning to the application. If timeout value is 0, the timeout is disabled and a connection attempt will wait indefinitely.

default: 0

See Also:
Constant Field Values

DSI_CONN_PACKET_SIZE

public static final int DSI_CONN_PACKET_SIZE
A UINT32 value specifying the network packet size in bytes.

default: 1024

See Also:
Constant Field Values

DSI_CONN_QUIET_MODE

public static final int DSI_CONN_QUIET_MODE
A UINT32 window handle, parent window handle of the application used to display dialog boxes. If the handle is a null pointer, then the driver doesn't display dialog boxes.

default: null

See Also:
Constant Field Values

DSI_CONN_TRANSACTION_ISOLATION

public static final int DSI_CONN_TRANSACTION_ISOLATION
A UINT32 bitmask that sets the transaction isolation level for the current connection.

Possible values are:

default:

See Also:
Constant Field Values

DSI_CONVERT_FUNCTIONS

public static final int DSI_CONVERT_FUNCTIONS
A UINT32 bitmask enumerating the scalar conversion functions supported by the datasource.

The bitmask is composed of OR'ing 0 or more of the following values.

default:

See Also:
Constant Field Values

DSI_CORRELATION_NAME

public static final int DSI_CORRELATION_NAME
A UINT16 indicating whether table correlation names are supported.

Possible values are:

default: DSI_CN_ANY

See Also:
Constant Field Values

DSI_CREATE_ASSERTION

public static final int DSI_CREATE_ASSERTION
A UINT32 bitmask enumerating the supported CREATE ASSERTION clauses.

The bitmask is composed of OR'ing 0 or more of the following values.

default: 0

See Also:
Constant Field Values

DSI_CREATE_CHARACTER_SET

public static final int DSI_CREATE_CHARACTER_SET
A UINT32 bitmask enumerating the clauses in the CREATE CHARACTER SET statement. A return value of "0" means that the CREATE CHARACTER SET statement is not supported.

The bitmask is composed of OR'ing 0 or more of the following values.

default: 0

See Also:
Constant Field Values

DSI_CREATE_COLLATION

public static final int DSI_CREATE_COLLATION
A UINT32 bitmask enumerating the clauses in the CREATE COLLATION statement. A return value of "0" means that the CREATE CHARACTER SET statement is not supported.

The bitmask is composed of OR'ing 0 or more of the following values.

default: 0

See Also:
Constant Field Values

DSI_CREATE_DOMAIN

public static final int DSI_CREATE_DOMAIN
A UINT32 bitmask enumerating the clauses in the CREATE DOMAIN statement. A return value of "0" means that the CREATE CHARACTER SET statement is not supported.

The bitmask is composed of OR'ing 0 or more of the following values.

Additionally, if DSI_CDO_DEFAULT is set, the following constraints may also be specified

default: 0

See Also:
Constant Field Values

DSI_CREATE_SCHEMA

public static final int DSI_CREATE_SCHEMA
A UINT32 bitmask enumerating the clauses in the CREATE SCHEMA statement.

The bitmask is composed of OR'ing 0 or more of the following values.

default: 0

See Also:
Constant Field Values

DSI_CREATE_TABLE

public static final int DSI_CREATE_TABLE
A UINT32 bitmask enumerating the clauses in the CREATE TABLE statement.

The bitmask is composed of OR'ing 0 or more of the following values.

Additionally, if specifying column or table constraints is supported, the following constrains may also be specified

default:

See Also:
Constant Field Values

DSI_CREATE_TRANSLATION

public static final int DSI_CREATE_TRANSLATION
A UINT32 bitmask enumerating the clauses in the CREATE TRANSLATION statement. A return value of "0" means that the CREATE TRANSLATION statement is not supported.

The bitmask is composed of OR'ing 0 or more of the following values.

default: 0

See Also:
Constant Field Values

DSI_CREATE_VIEW

public static final int DSI_CREATE_VIEW
A UINT32 bitmask enumerating the clauses in the CREATE VIEW statement. A return value of "0" means that the CREATE VIEW statement is not supported.

The bitmask is composed of OR'ing 0 or more of the following values.

default: 0

See Also:
Constant Field Values

DSI_CURSOR_COMMIT_BEHAVIOR

public static final int DSI_CURSOR_COMMIT_BEHAVIOR
A UINT16 indicating how a COMMIT operation affects cursors and prepared statements in the data source.

Possible values are:

default:

See Also:
Constant Field Values

DSI_CURSOR_ROLLBACK_BEHAVIOR

public static final int DSI_CURSOR_ROLLBACK_BEHAVIOR
A UINT16 indicating how a ROLLBACK operation affects cursors and prepared statements in the data source.

Possible values are:

default:

See Also:
Constant Field Values

DSI_CURSOR_SENSITIVITY

public static final int DSI_CURSOR_SENSITIVITY
A UINT32 indicating the support for cursor sensitivity.

Possible values are:

default:

See Also:
Constant Field Values

DSI_DATA_SOURCE_READ_ONLY

public static final int DSI_DATA_SOURCE_READ_ONLY
A String indicating the data source (NOT Driver level) read only characteristic. default: "Y"

See Also:
Constant Field Values

DSI_DBMS_NAME

public static final int DSI_DBMS_NAME
A String with the name of the DBMS product accessed by the driver.

default: "TEXT"

See Also:
Constant Field Values

DSI_DBMS_VER

public static final int DSI_DBMS_VER
A String indicating the version of the DBMS product accessed by the driver. The version is of the form ##.##.####, where the first two digits are the major version, the next two digits are the minor version, and the last four digits are the release version. The driver must render the DBMS product version in this form but can also append the DBMS product-specific version as well.

default: "00.00.0000"

See Also:
Constant Field Values

DSI_DATETIME_LITERALS

public static final int DSI_DATETIME_LITERALS
A UINT32 bitmask enumerating the SQL-92 datetime literals supported by the data source. Note that these are the datetime literals listed in the SQL-92 specification and are separate from the datetime literal escape clauses defined by ODBC.

Possible values:

default:

See Also:
Constant Field Values

DSI_DDL_INDEX

public static final int DSI_DDL_INDEX
A UINT32 indicating the support for creation and dropping of indexes.

Possible values are:

default: 0

See Also:
Constant Field Values

DSI_DEFAULT_TXN_ISOLATION

public static final int DSI_DEFAULT_TXN_ISOLATION
A UINT32 indicating the default transaction isolation level supported by the driver or data source A return value of "0" is given if transactions are not supported.

Possible values are:

default: 0

See Also:
Constant Field Values

DSI_DESCRIBE_PARAMETER

public static final int DSI_DESCRIBE_PARAMETER
A String indicating whether parameters can be described. default: "N"

See Also:
Constant Field Values

DSI_DROP_ASSERTION

public static final int DSI_DROP_ASSERTION
A UINT32 bitmask enumerating the clauses in the DROP ASSERTION statement.

The bitmask is composed of OR'ing 0 or more of the following values.

default: 0

See Also:
Constant Field Values

DSI_DROP_CHARACTER_SET

public static final int DSI_DROP_CHARACTER_SET
A UINT32 bitmask enumerating the clauses in the DROP CHARACTER SET statement.

The bitmask is composed of OR'ing 0 or more of the following values.

default: 0

See Also:
Constant Field Values

DSI_DROP_COLLATION

public static final int DSI_DROP_COLLATION
A UINT32 bitmask enumerating the clauses in the DROP COLLATION statement.

The bitmask is composed of OR'ing 0 or more of the following values.

default: 0

See Also:
Constant Field Values

DSI_DROP_DOMAIN

public static final int DSI_DROP_DOMAIN
A UINT32 bitmask enumerating the clauses in the DROP DOMAIN statement.

The bitmask is composed of OR'ing 0 or more of the following values.

default: 0

See Also:
Constant Field Values

DSI_DROP_SCHEMA

public static final int DSI_DROP_SCHEMA
A UINT32 bitmask enumerating the clauses in the DROP SCHEMA statement.

The bitmask is composed of OR'ing 0 or more of the following values.

default:

See Also:
Constant Field Values

DSI_DROP_TABLE

public static final int DSI_DROP_TABLE
A UINT32 bitmask enumerating the clauses in the DROP TABLE statement.

The bitmask is composed of OR'ing 0 or more of the following values.

default:

See Also:
Constant Field Values

DSI_DROP_TRANSLATION

public static final int DSI_DROP_TRANSLATION
A UINT32 bitmask enumerating the clauses in the DROP TRANSLATION statement.

The bitmask is composed of OR'ing 0 or more of the following values.

default: 0

See Also:
Constant Field Values

DSI_DROP_VIEW

public static final int DSI_DROP_VIEW
A UINT32 bitmask enumerating the clauses in the DROP VIEW statement.

The bitmask is composed of OR'ing 0 or more of the following values.

default: 0

See Also:
Constant Field Values

DSI_EXPRESSIONS_IN_ORDERBY

public static final int DSI_EXPRESSIONS_IN_ORDERBY
A String indicating if the data source supports expressions in the ORDER BY list. default: "Y"

See Also:
Constant Field Values

DSI_GROUP_BY

public static final int DSI_GROUP_BY
A UINT16 indicating the relationship between the columns in the GROUP BY clause and the nonaggregated columns in the select list.

Possible values are:

default: DSI_GB_GROUP_BY_CONTAINS_SELECT

See Also:
Constant Field Values

DSI_IDENTIFIER_CASE

public static final int DSI_IDENTIFIER_CASE
A UINT16 indicating the case sensitivity of identifiers stored in the system catalogue.

Possible values are:

default: DSI_IC_SENSITIVE

See Also:
Constant Field Values

DSI_IDENTIFIER_QUOTE_CHAR

public static final int DSI_IDENTIFIER_QUOTE_CHAR
A String indicating the starting and ending delimiter of a quoted (delimited) identifier in SQL statements. A return value of "" is given if the data source does not support quoted identifiers.

default: "\""

See Also:
Constant Field Values

DSI_INDEX_KEYWORDS

public static final int DSI_INDEX_KEYWORDS
A UINT32 bitmask enumerating the supported keywords in the CREATE INDEX statement. An application calls SQLGetInfo with the SQL_DLL_INDEX information type to see if the CREATE INDEX statement is supported.

The bitmask is composed of OR'ing 0 or more of the following values.

default:

See Also:
Constant Field Values

DSI_INSERT_STATEMENT

public static final int DSI_INSERT_STATEMENT
A UINT32 bitmask that indicates support for INSERT statements.

The bitmask is composed of OR'ing 0 or more of the following values.

default:

See Also:
Constant Field Values

DSI_INTEGRITY

public static final int DSI_INTEGRITY
A String indicating if the data source supports the Integrity Enhancement Facility. default: "N"

See Also:
Constant Field Values

DSI_KEYWORDS

public static final int DSI_KEYWORDS
A String containing a comma-separated list of all data source-specific keywords. This list does not contain keywords specific to ODBC or keywords used by both the data source and ODBC. This list represents all the reserved keywords; interoperable applications should not use these words in object names.

default: ""

See Also:
Constant Field Values

DSI_LIKE_ESCAPE_CLAUSE

public static final int DSI_LIKE_ESCAPE_CLAUSE
A String indicating if the data source supports an escape character for the percent character (%) and underscore character (_) in a LIKE predicate and the driver supports the ODBC syntax for defining a LIKE predicate escape character. default: "Y"

See Also:
Constant Field Values

DSI_MAX_ASYNC_CONCURRENT_STATEMENTS

public static final int DSI_MAX_ASYNC_CONCURRENT_STATEMENTS
A UINT32 value specifying the maximum number of active concurrent statements in asynchronous mode that the driver can support on a given connection. A return value of "0" means that the limit is not set or unknown.

default: 0

See Also:
Constant Field Values

DSI_MAX_BINARY_LITERAL_LEN

public static final int DSI_MAX_BINARY_LITERAL_LEN
A UINT32 value specifying the maximum length (number of hexadecimal characters of a binary literal in an SQL statement. A return value of "0" means that the limit is not set or unknown.

default: 1000

See Also:
Constant Field Values

DSI_MAX_CATALOG_NAME_LEN

public static final int DSI_MAX_CATALOG_NAME_LEN
A UINT16 value specifying the maximum length of a catalog name in the data source. A return value of "0" means that the limit is not set or unknown.

default: 255

See Also:
Constant Field Values

DSI_MAX_CHAR_LITERAL_LEN

public static final int DSI_MAX_CHAR_LITERAL_LEN
A UINT32 value specifying the maximum length (number of characters) of a character literal in an SQL statement. A return value of "0" means that the limit is not set or unknown.

default: 1000

See Also:
Constant Field Values

DSI_MAX_COLUMN_NAME_LEN

public static final int DSI_MAX_COLUMN_NAME_LEN
A UINT16 value specifying the maximum length of a column name in the data source. A return value of "0" means that the limit is not set or unknown.

default: 255

See Also:
Constant Field Values

DSI_MAX_COLUMNS_IN_GROUP_BY

public static final int DSI_MAX_COLUMNS_IN_GROUP_BY
A UINT16 value specifying the maximum number of columns allowed in a GROUP BY clause. A return value of "0" means that the limit is not set or unknown.

default: 255

See Also:
Constant Field Values

DSI_MAX_COLUMNS_IN_INDEX

public static final int DSI_MAX_COLUMNS_IN_INDEX
A UINT16 value specifying the maximum number of columns allowed in an index. A return value of "0" means that the limit is not set or unknown.

default: 255

See Also:
Constant Field Values

DSI_MAX_COLUMNS_IN_ORDER_BY

public static final int DSI_MAX_COLUMNS_IN_ORDER_BY
A UINT16 value specifying the maximum number of columns allowed in an ORDER BY clause. A return value of "0" means that the limit is not set or unknown.

default: 255

See Also:
Constant Field Values

DSI_MAX_COLUMNS_IN_SELECT

public static final int DSI_MAX_COLUMNS_IN_SELECT
A UINT16 value specifying the maximum number of columns allowed in a select list. A return value of "0" means that the limit is not set or unknown.

default: 256

See Also:
Constant Field Values

DSI_MAX_COLUMNS_IN_TABLE

public static final int DSI_MAX_COLUMNS_IN_TABLE
A UINT16 value specifying the maximum number of columns allowed in a table. A return value of "0" means that the limit is not set or unknown.

default: 256

See Also:
Constant Field Values

DSI_MAX_CONCURRENT_ACTIVITIES

public static final int DSI_MAX_CONCURRENT_ACTIVITIES
A UINT16 value specifying the maximum number of active statements that the driver can support for a connection. A return value of "0" means that the limit is not set or unknown.

default: 0

See Also:
Constant Field Values

DSI_MAX_CURSOR_NAME_LEN

public static final int DSI_MAX_CURSOR_NAME_LEN
A UINT16 value specifying the maximum length of a cursor name in the data source. A return value of "0" means that the limit is not set or unknown.

default: 18

See Also:
Constant Field Values

DSI_MAX_IDENTIFIER_LEN

public static final int DSI_MAX_IDENTIFIER_LEN
A UINT16 that indicates the maximum size in characters that the data source supports for user-defined names

default: 0

See Also:
Constant Field Values

DSI_MAX_INDEX_SIZE

public static final int DSI_MAX_INDEX_SIZE
A UINT32 value specifying the maximum number of bytes allowed in the combined fields of an index. A return value of "0" means that the limit is not set or unknown.

default: 0

See Also:
Constant Field Values

DSI_MAX_PROCEDURE_NAME_LEN

public static final int DSI_MAX_PROCEDURE_NAME_LEN
A UINT16 value specifying the maximum length of a procedure name in the data source. A return value of "0" means that the limit is not set or unknown.

default: 255

See Also:
Constant Field Values

DSI_MAX_ROW_SIZE

public static final int DSI_MAX_ROW_SIZE
A UINT32 value specifying the maximum length of a single row in a table. A return value of "0" means that the limit is not set or unknown.

default: 0

See Also:
Constant Field Values

DSI_MAX_ROW_SIZE_INCLUDES_LONG

public static final int DSI_MAX_ROW_SIZE_INCLUDES_LONG
A String indicating if the maximum row size returned for the SQL_MAX_ROW_SIZE information type includes the length of all SQL_LONGVARCHAR and SQL_LONGVARBINARY columns in the row. default: "N"

See Also:
Constant Field Values

DSI_MAX_SCHEMA_NAME_LEN

public static final int DSI_MAX_SCHEMA_NAME_LEN
A UINT16 value specifying the maximum length of a schema name in the data source. A return value of "0" means that the limit is not set or unknown.

default: 255

See Also:
Constant Field Values

DSI_MAX_STATEMENT_LEN

public static final int DSI_MAX_STATEMENT_LEN
A UINT32 value specifying the maximum length (number of characters, including white space) of an SQL statement. A return value of "0" means that the limit is not set or unknown.

default: 16384

See Also:
Constant Field Values

DSI_MAX_TABLE_NAME_LEN

public static final int DSI_MAX_TABLE_NAME_LEN
A UINT16 value specifying the maximum length of a table name in the data source. A return value of "0" means that the limit is not set or unknown.

default: 255

See Also:
Constant Field Values

DSI_MAX_TABLES_IN_SELECT

public static final int DSI_MAX_TABLES_IN_SELECT
A UINT16 value specifying the maximum number of tables allowed in the FROM clause of a SELECT statement. A return value of "0" means that the limit is not set or unknown.

default: 0

See Also:
Constant Field Values

DSI_MAX_USER_NAME_LEN

public static final int DSI_MAX_USER_NAME_LEN
A UINT16 value specifying the maximum length of a user name in the data source. A return value of "0" means that the limit is not set or unknown.

default: 128

See Also:
Constant Field Values

DSI_MULT_RESULT_SETS

public static final int DSI_MULT_RESULT_SETS
A String indicating driver support for multiple result sets. "Y" if the driver supports multiple result sets. "N" if the driver does not support multiple result sets. default: "N"

See Also:
Constant Field Values

DSI_MULTIPLE_ACTIVE_TXN

public static final int DSI_MULTIPLE_ACTIVE_TXN
A String indicating driver support for more than one active transaction at a time. default: "N"

See Also:
Constant Field Values

DSI_NON_NULLABLE_COLUMNS

public static final int DSI_NON_NULLABLE_COLUMNS
A UINT16 indicating whether the data source supports NOT NULL in columns.

Possible values are:

default: DSI_NNC_NULL

See Also:
Constant Field Values

DSI_NULL_COLLATION

public static final int DSI_NULL_COLLATION
A UINT16 value specifying where NULLs are sorted in a result set.

Possible values are:

default: DSI_NC_LOW

See Also:
Constant Field Values

DSI_NUMERIC_FUNCTIONS

public static final int DSI_NUMERIC_FUNCTIONS
A UINT32 bitmask enumerating the scalar numeric functions supported by the driver and associated data source.

The bitmask is composed of OR'ing 0 or more of the following values.

default:

See Also:
Constant Field Values

DSI_ODBC_SQL_CONFORMANCE

public static final int DSI_ODBC_SQL_CONFORMANCE
An INT16 value indicating SQL grammar supported by the driver.

Possible values are:

default: SQL_OSC_CORE

See Also:
Constant Field Values

DSI_OJ_CAPABILITIES

public static final int DSI_OJ_CAPABILITIES
A UINT32 bitmask enumerating the types of outer joins supported by the driver and data source.

The bitmask is composed of OR'ing 0 or more of the following values.

default:

See Also:
Constant Field Values

DSI_ORDER_BY_COLUMNS_IN_SELECT

public static final int DSI_ORDER_BY_COLUMNS_IN_SELECT
A String indicating if the columns in the ORDER BY clause must be in the select list. default: "N"

See Also:
Constant Field Values

DSI_OUTER_JOINS

public static final int DSI_OUTER_JOINS
A String indicating if OUTER JOINS are supported. default: "F"

See Also:
Constant Field Values

DSI_PARAM_ARRAY_ROW_COUNTS

public static final int DSI_PARAM_ARRAY_ROW_COUNTS
A UINT32 indicating if a parameterized statement using parameter arrays will return a row count for each parameter set or if an aggregate row count is returned.

Possible values are:

default: DSI_PARC_NO_BATCH

See Also:
Constant Field Values

DSI_PROCEDURE_TERM

public static final int DSI_PROCEDURE_TERM
A String with the data source vendor's name for a procedure.

default: "procedure"

See Also:
Constant Field Values

DSI_PROCEDURES

public static final int DSI_PROCEDURES
A String indicating if the data source supports procedures and the driver supports the ODBC procedure invocation syntax. default: "Y"

See Also:
Constant Field Values

DSI_QUOTED_IDENTIFIER_CASE

public static final int DSI_QUOTED_IDENTIFIER_CASE
A UINT16 value specifying the case sensitivity of quoted identifiers.

Possible values are:

default: DSI_IC_SENSITIVE

See Also:
Constant Field Values

DSI_SCHEMA_TERM

public static final int DSI_SCHEMA_TERM
A String containing the data source vendor's name for a schema.

default: "schema"

See Also:
Constant Field Values

DSI_SCHEMA_USAGE

public static final int DSI_SCHEMA_USAGE
A UINT32 bitmask enumerating the statements in which schemas can be used.

The bitmask is composed of OR'ing 0 or more of the following values.

default:

See Also:
Constant Field Values

DSI_SERVER_NAME

public static final int DSI_SERVER_NAME
A String containing the actual data source-specific server name.

default: ""

See Also:
Constant Field Values

DSI_SPECIAL_CHARACTERS

public static final int DSI_SPECIAL_CHARACTERS
A String containing all special characters that can be used in an identifier name on the data source.

default: ""

See Also:
Constant Field Values

DSI_SQL_CONFORMANCE

public static final int DSI_SQL_CONFORMANCE
A UINT32 value specifying the case sensitivity of quoted identifiers.

Possible values are:

default: SC_SQL92_ENTRY

See Also:
Constant Field Values

DSI_STRING_FUNCTIONS

public static final int DSI_STRING_FUNCTIONS
A UINT32 bitmask enumerating the scalar string functions supported by the driver and associated data source.

The bitmask is composed of OR'ing 0 or more of the following values.

default:

See Also:
Constant Field Values

DSI_SUBQUERIES

public static final int DSI_SUBQUERIES
A UINT32 bitmask enumerating the predicates that support subqueries.

The bitmask is composed of OR'ing 0 or more of the following values.

default:

See Also:
Constant Field Values

DSI_SUPPORTED_SQL_BIGINT_CONVERSIONS

public static final int DSI_SUPPORTED_SQL_BIGINT_CONVERSIONS
A UINT32 bitmask indicates the conversions supported by the data source with the CONVERT scalar function.

The bitmask is composed of OR'ing 0 or more of the following values.

default:

See Also:
Constant Field Values

DSI_SUPPORTED_SQL_BINARY_CONVERSIONS

public static final int DSI_SUPPORTED_SQL_BINARY_CONVERSIONS
A UINT32 bitmask indicates the conversions supported by the data source with the CONVERT scalar function.

The bitmask is composed of OR'ing 0 or more of the following values.

default:

See Also:
Constant Field Values

DSI_SUPPORTED_SQL_BIT_CONVERSIONS

public static final int DSI_SUPPORTED_SQL_BIT_CONVERSIONS
A UINT32 bitmask indicates the conversions supported by the data source with the CONVERT scalar function.

The bitmask is composed of OR'ing 0 or more of the following values.

default:

See Also:
Constant Field Values

DSI_SUPPORTED_SQL_CHAR_CONVERSIONS

public static final int DSI_SUPPORTED_SQL_CHAR_CONVERSIONS
A UINT32 bitmask indicates the conversions supported by the data source with the CONVERT scalar function.

The bitmask is composed of OR'ing 0 or more of the following values.

default:

See Also:
Constant Field Values

DSI_SUPPORTED_SQL_GUID_CONVERSIONS

public static final int DSI_SUPPORTED_SQL_GUID_CONVERSIONS
A UINT32 bitmask indicates the conversions supported by the data source with the CONVERT scalar function.

The bitmask is composed of OR'ing 0 or more of the following values.

default:

See Also:
Constant Field Values

DSI_SUPPORTED_SQL_DATE_CONVERSIONS

public static final int DSI_SUPPORTED_SQL_DATE_CONVERSIONS
A UINT32 bitmask indicates the conversions supported by the data source with the CONVERT scalar function.

The bitmask is composed of OR'ing 0 or more of the following values.

default:

See Also:
Constant Field Values

DSI_SUPPORTED_SQL_DECIMAL_CONVERSIONS

public static final int DSI_SUPPORTED_SQL_DECIMAL_CONVERSIONS
A UINT32 bitmask indicates the conversions supported by the data source with the CONVERT scalar function.

The bitmask is composed of OR'ing 0 or more of the following values.

default:

See Also:
Constant Field Values

DSI_SUPPORTED_SQL_DOUBLE_CONVERSIONS

public static final int DSI_SUPPORTED_SQL_DOUBLE_CONVERSIONS
A UINT32 bitmask indicates the conversions supported by the data source with the CONVERT scalar function.

The bitmask is composed of OR'ing 0 or more of the following values.

default:

See Also:
Constant Field Values

DSI_SUPPORTED_SQL_FLOAT_CONVERSIONS

public static final int DSI_SUPPORTED_SQL_FLOAT_CONVERSIONS
A UINT32 bitmask indicates the conversions supported by the data source with the CONVERT scalar function.

The bitmask is composed of OR'ing 0 or more of the following values.

default:

See Also:
Constant Field Values

DSI_SUPPORTED_SQL_INTEGER_CONVERSIONS

public static final int DSI_SUPPORTED_SQL_INTEGER_CONVERSIONS
A UINT32 bitmask indicates the conversions supported by the data source with the CONVERT scalar function.

The bitmask is composed of OR'ing 0 or more of the following values.

default:

See Also:
Constant Field Values

DSI_SUPPORTED_SQL_INTERVAL_YEAR_MONTH_CONVERSIONS

public static final int DSI_SUPPORTED_SQL_INTERVAL_YEAR_MONTH_CONVERSIONS
A UINT32 bitmask indicates the conversions supported by the data source with the CONVERT scalar function.

The bitmask is composed of OR'ing 0 or more of the following values.

default:

See Also:
Constant Field Values

DSI_SUPPORTED_SQL_INTERVAL_DAY_TIME_CONVERSIONS

public static final int DSI_SUPPORTED_SQL_INTERVAL_DAY_TIME_CONVERSIONS
A UINT32 bitmask indicates the conversions supported by the data source with the CONVERT scalar function.

The bitmask is composed of OR'ing 0 or more of the following values.

default:

See Also:
Constant Field Values

DSI_SUPPORTED_SQL_LONGVARBINARY_CONVERSIONS

public static final int DSI_SUPPORTED_SQL_LONGVARBINARY_CONVERSIONS
A UINT32 bitmask indicates the conversions supported by the data source with the CONVERT scalar function.

The bitmask is composed of OR'ing 0 or more of the following values.

default:

See Also:
Constant Field Values

DSI_SUPPORTED_SQL_LONGVARCHAR_CONVERSIONS

public static final int DSI_SUPPORTED_SQL_LONGVARCHAR_CONVERSIONS
A UINT32 bitmask indicates the conversions supported by the data source with the CONVERT scalar function.

The bitmask is composed of OR'ing 0 or more of the following values.

default:

See Also:
Constant Field Values

DSI_SUPPORTED_SQL_NUMERIC_CONVERSIONS

public static final int DSI_SUPPORTED_SQL_NUMERIC_CONVERSIONS
A UINT32 bitmask indicates the conversions supported by the data source with the CONVERT scalar function.

The bitmask is composed of OR'ing 0 or more of the following values.

default:

See Also:
Constant Field Values

DSI_SUPPORTED_SQL_REAL_CONVERSIONS

public static final int DSI_SUPPORTED_SQL_REAL_CONVERSIONS
A UINT32 bitmask indicates the conversions supported by the data source with the CONVERT scalar function.

The bitmask is composed of OR'ing 0 or more of the following values.

default:

See Also:
Constant Field Values

DSI_SUPPORTED_SQL_SMALLINT_CONVERSIONS

public static final int DSI_SUPPORTED_SQL_SMALLINT_CONVERSIONS
A UINT32 bitmask indicates the conversions supported by the data source with the CONVERT scalar function.

The bitmask is composed of OR'ing 0 or more of the following values.

default:

See Also:
Constant Field Values

DSI_SUPPORTED_SQL_TIME_CONVERSIONS

public static final int DSI_SUPPORTED_SQL_TIME_CONVERSIONS
A UINT32 bitmask indicates the conversions supported by the data source with the CONVERT scalar function.

The bitmask is composed of OR'ing 0 or more of the following values.

default:

See Also:
Constant Field Values

DSI_SUPPORTED_SQL_TIMESTAMP_CONVERSIONS

public static final int DSI_SUPPORTED_SQL_TIMESTAMP_CONVERSIONS
A UINT32 bitmask indicates the conversions supported by the data source with the CONVERT scalar function.

The bitmask is composed of OR'ing 0 or more of the following values.

default:

See Also:
Constant Field Values

DSI_SUPPORTED_SQL_TINYINT_CONVERSIONS

public static final int DSI_SUPPORTED_SQL_TINYINT_CONVERSIONS
A UINT32 bitmask indicates the conversions supported by the data source with the CONVERT scalar function.

The bitmask is composed of OR'ing 0 or more of the following values.

default:

See Also:
Constant Field Values

DSI_SUPPORTED_SQL_VARBINARY_CONVERSIONS

public static final int DSI_SUPPORTED_SQL_VARBINARY_CONVERSIONS
A UINT32 bitmask indicates the conversions supported by the data source with the CONVERT scalar function.

The bitmask is composed of OR'ing 0 or more of the following values.

default:

See Also:
Constant Field Values

DSI_SUPPORTED_SQL_VARCHAR_CONVERSIONS

public static final int DSI_SUPPORTED_SQL_VARCHAR_CONVERSIONS
A UINT32 bitmask indicates the conversions supported by the data source with the CONVERT scalar function.

The bitmask is composed of OR'ing 0 or more of the following values.

default:

See Also:
Constant Field Values

DSI_SUPPORTED_SQL_WCHAR_CONVERSIONS

public static final int DSI_SUPPORTED_SQL_WCHAR_CONVERSIONS
A UINT32 bitmask indicates the conversions supported by the data source with the CONVERT scalar function.

The bitmask is composed of OR'ing 0 or more of the following values.

default:

See Also:
Constant Field Values

DSI_SUPPORTED_SQL_WLONGVARCHAR_CONVERSIONS

public static final int DSI_SUPPORTED_SQL_WLONGVARCHAR_CONVERSIONS
A UINT32 bitmask indicates the conversions supported by the data source with the CONVERT scalar function.

The bitmask is composed of OR'ing 0 or more of the following values.

default:

See Also:
Constant Field Values

DSI_SUPPORTED_SQL_WVARCHAR_CONVERSIONS

public static final int DSI_SUPPORTED_SQL_WVARCHAR_CONVERSIONS
A UINT32 bitmask indicates the conversions supported by the data source with the CONVERT scalar function.

The bitmask is composed of OR'ing 0 or more of the following values.

default:

See Also:
Constant Field Values

DSI_SYSTEM_FUNCTIONS

public static final int DSI_SYSTEM_FUNCTIONS
A UINT32 bitmask enumerating the scalar system functions supported by the driver and associated data source.

The bitmask is composed of OR'ing 0 or more of the following values.

default:

See Also:
Constant Field Values

DSI_TABLE_TERM

public static final int DSI_TABLE_TERM
A String containing the data source vendor's name for a table.

default: "table"

See Also:
Constant Field Values

DSI_TIMEDATE_ADD_INTERVALS

public static final int DSI_TIMEDATE_ADD_INTERVALS
A UINT32 bitmask enumerating the timestamp intervals supported by the driver and associated data source for the TIMESTAMPADD scalar function.

The bitmask is composed of OR'ing 0 or more of the following values:

default:

See Also:
Constant Field Values

DSI_TIMEDATE_DIFF_INTERVALS

public static final int DSI_TIMEDATE_DIFF_INTERVALS
A UINT32 bitmask enumerating the timestamp intervals supported by the driver and associated data source for the TIMESTAMPDIFF scalar function.

The bitmask is composed of OR'ing 0 or more of the following values:

default:

See Also:
Constant Field Values

DSI_TIMEDATE_FUNCTIONS

public static final int DSI_TIMEDATE_FUNCTIONS
A UINT32 bitmask enumerating the scalar date and time functions supported by the driver and associated data source.

The bitmask is composed of OR'ing 0 or more of the following values.

default:

See Also:
Constant Field Values

DSI_TXN_CAPABLE

public static final int DSI_TXN_CAPABLE
A UINT16 value describing the transaction support in the driver or data source.

Possible values are:

default: DSI_TC_NONE

See Also:
Constant Field Values

DSI_TXN_ISOLATION_OPTION

public static final int DSI_TXN_ISOLATION_OPTION
A UINT32 bitmask enumerating the transaction isolation levels available from the driver or data source.

The bitmask is composed of OR'ing 0 or more of the following values.

default:

See Also:
Constant Field Values

DSI_UNION

public static final int DSI_UNION
A UINT32 bitmask enumerating the support for the UNION clause.

The bitmask is composed of OR'ing 0 or more of the following values.

default:

See Also:
Constant Field Values

DSI_USER_NAME

public static final int DSI_USER_NAME
A String containing the name used in a particular database, which can be different from the login name.

default: ""

See Also:
Constant Field Values

DSI_BATCH_ROW_COUNT

public static final int DSI_BATCH_ROW_COUNT
A UINT32 bitmask enumerating the behaviour of the driver with respect to the availability of row counts.

The bitmask is composed of OR'ing 0 or more of the following values.

default: 0

See Also:
Constant Field Values

DSI_BATCH_SUPPORT

public static final int DSI_BATCH_SUPPORT
A UINT32 bitmask enumerating the driver's support for batches.

The bitmask is composed of OR'ing 0 or more of the following values.

default: 0

See Also:
Constant Field Values

DSI_DYNAMIC_CURSOR_ATTRIBUTES1

public static final int DSI_DYNAMIC_CURSOR_ATTRIBUTES1
A UINT32 bitmask describes the attributes of a dynamic cursor that are supported by the driver. This bitmask contains the first subset of attributes; for the second see DSI_DYNAMIC_CURSOR_ATTRIBUTES2.

The bitmask is composed of OR'ing 0 or more of the following values.

default: 0

See Also:
Constant Field Values

DSI_DYNAMIC_CURSOR_ATTRIBUTES2

public static final int DSI_DYNAMIC_CURSOR_ATTRIBUTES2
A UINT32 bitmask that describes the attributes of a dynamic cursor that are supported by the driver. This bitmask contains the second subset of attributes; for the first subset, see SQL_DYNAMIC_CURSOR_ATTRIBUTES1.

This bitmask is composed of OR'ing 0 or more of the following values.

default: 0

See Also:
Constant Field Values

DSI_FORWARD_ONLY_CURSOR_ATTRIBUTES1

public static final int DSI_FORWARD_ONLY_CURSOR_ATTRIBUTES1
A UINT32 bitmask that describes the attributes of a forward-only cursor that are supported by the driver. This bitmask contains the first subset of attributes; for the second subset, see SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES2.

This bitmask is composed of OR'ing 0 or more of the following values.

default: 0

See Also:
Constant Field Values

DSI_FORWARD_ONLY_CURSOR_ATTRIBUTES2

public static final int DSI_FORWARD_ONLY_CURSOR_ATTRIBUTES2
A UINT32 bitmask that describes the attributes of a forward-only cursor that are supported by the driver. This bitmask contains the second subset of attributes; for the first subset, see SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES1.

This bitmask is composed of OR'ing 0 or more of the following values.

default: 0

See Also:
Constant Field Values

DSI_INFO_SCHEMA_VIEWS

public static final int DSI_INFO_SCHEMA_VIEWS
A UINT32 bitmask enumerating the views in the INFORMATION_SCHEMA that are supported by the driver. The views in, and the contents of, INFORMATION_SCHEMA are as defined in SQL-92. The SQL-92 or FIPS conformance level at which this feature needs to be supported is shown in parentheses next to each bitmask.

This bitmask is composed of OR'ing 0 or more of the following values.

default: 0

See Also:
Constant Field Values

DSI_KEYSET_CURSOR_ATTRIBUTES1

public static final int DSI_KEYSET_CURSOR_ATTRIBUTES1
A UINT32 bitmask that describes the attributes of a keyset cursor that are supported by the driver. This bitmask contains the first subset of attributes; for the second subset, see SQL_KEYSET_CURSOR_ATTRIBUTES2.

This bitmask is composed of OR'ing 0 or more of the following values.

default: 0

See Also:
Constant Field Values

DSI_KEYSET_CURSOR_ATTRIBUTES2

public static final int DSI_KEYSET_CURSOR_ATTRIBUTES2
A UINT32 bitmask that describes the attributes of a keyset cursor that are supported by the driver. This bitmask contains the second subset of attributes; for the first subset, see SQL_KEYSET_CURSOR_ATTRIBUTES1.

This bitmask is composed of OR'ing 0 or more of the following values.

default: 0

See Also:
Constant Field Values

DSI_PARAM_ARRAY_SELECTS

public static final int DSI_PARAM_ARRAY_SELECTS
A UINT32 enumerating the driver's properties regarding the availability of result sets in a parameterized execution.

Set to one of the following:

default: DSI_PAS_NO_SELECT

See Also:
Constant Field Values

DSI_ROW_UPDATES

public static final int DSI_ROW_UPDATES
A String: default: "N"

See Also:
Constant Field Values

DSI_SEARCH_PATTERN_ESCAPE

public static final int DSI_SEARCH_PATTERN_ESCAPE
A String specifying what the driver supports as an escape character that permits the use of the pattern match metacharacters underscore (_) and percent sign (%) as valid characters in search patterns. This escape character applies only for those catalog function arguments that support search strings. If this string is empty, the driver does not support a search-pattern escape character. Because this information type does not indicate general support of the escape character in the LIKE predicate, SQL-92 does not include requirements for this character string.

default: "\\"

See Also:
Constant Field Values

DSI_STATIC_CURSOR_ATTRIBUTES1

public static final int DSI_STATIC_CURSOR_ATTRIBUTES1
A UINT32 bitmask that describes the attributes of a static cursor that are supported by the driver. This bitmask contains the first subset of attributes; for the second subset, see SQL_STATIC_CURSOR_ATTRIBUTES2.

This bitmask is composed of OR'ing 0 or more of the following values.

default: 0

See Also:
Constant Field Values

DSI_STATIC_CURSOR_ATTRIBUTES2

public static final int DSI_STATIC_CURSOR_ATTRIBUTES2
A UINT32 bitmask that describes the attributes of a static cursor that are supported by the driver. This bitmask contains the second subset of attributes; for the first subset, see SQL_STATIC_CURSOR_ATTRIBUTES1.

This bitmask is composed of OR'ing 0 or more of the following values.

default: 0

See Also:
Constant Field Values

DSI_SQL92_DATETIME_FUNCTIONS

public static final int DSI_SQL92_DATETIME_FUNCTIONS
A UINT32 bitmask enumerating the datetime scalar functions that are supported by the driver and the associated data source, as defined in SQL-92.

This bitmask is composed of OR'ing 0 or more of the following values:

default:

See Also:
Constant Field Values

DSI_SQL92_FOREIGN_KEY_DELETE_RULE

public static final int DSI_SQL92_FOREIGN_KEY_DELETE_RULE
A UINT32 bitmask enumerating the rules supported for a foreign key in a DELETE statement, as defined in SQL-92.

Set to one of the following: This bitmask is composed of OR'ing 0 or more of the following values.

default: 0

See Also:
Constant Field Values

DSI_SQL92_FOREIGN_KEY_UPDATE_RULE

public static final int DSI_SQL92_FOREIGN_KEY_UPDATE_RULE
A UINT32 bitmask enumerating the rules supported for a foreign key in an UPDATE statement, as defined in SQL-92.

This bitmask is composed of OR'ing 0 or more of the following values.

default: 0

See Also:
Constant Field Values

DSI_SQL92_NUMERIC_VALUE_FUNCTIONS

public static final int DSI_SQL92_NUMERIC_VALUE_FUNCTIONS
A UINT32 bitmask enumerating the numeric value scalar functions that are supported by the driver and the associated data source, as defined in SQL-92.

This bitmask is composed of OR'ing 0 or more of the following values.

default: 0

See Also:
Constant Field Values

DSI_SQL92_PREDICATES

public static final int DSI_SQL92_PREDICATES
A UINT32 bitmask enumerating the predicates supported in a SELECT statement, as defined in SQL-92. The SQL-92 or FIPS conformance level at which this feature needs to be supported is shown in parentheses next to each bitmask.

This bitmask is composed of OR'ing 0 or more of the following values.

default: DSI_SP_EXISTS | DSI_SP_ISNOTNULL | DSI_SP_ISNULL

See Also:
Constant Field Values

DSI_SQL92_GRANT

public static final int DSI_SQL92_GRANT
A UINT32 bitmask enumerating the clauses supported in the GRANT statement, as defined in SQL-92. The SQL-92 or FIPS conformance level at which this feature needs to be supported is shown in parentheses next to each bitmask.

This bitmask is composed of OR'ing 0 or more of the following values.

default: DSI_SG_WITH_GRANT_OPTION

See Also:
Constant Field Values

DSI_SQL92_RELATIONAL_JOIN_OPERATORS

public static final int DSI_SQL92_RELATIONAL_JOIN_OPERATORS
A UINT32 bitmask enumerating the relational join operators supported in a SELECT statement, as defined in SQL-92. The SQL-92 or FIPS conformance level at which this feature needs to be supported is shown in parentheses next to each bitmask.

This bitmask is composed of OR'ing 0 or more of the following values.

default: DSI_SRJO_CROSS_JOIN | DSI_SRJO_FULL_OUTER_JOIN | DSI_SRJO_INNER_JOIN | DSI_SRJO_LEFT_OUTER_JOIN | DSI_SRJO_RIGHT_OUTER_JOIN

See Also:
Constant Field Values

DSI_SQL92_REVOKE

public static final int DSI_SQL92_REVOKE
A UINT32 bitmask enumerating the clauses supported in the REVOKE statement, as defined in SQL-92, supported by the data source. The SQL-92 or FIPS conformance level at which this feature needs to be supported is shown in parentheses next to each bitmask.

This bitmask is composed of OR'ing 0 or more of the following values.

default: DSI_SR_GRANT_OPTION_FOR

See Also:
Constant Field Values

DSI_SQL92_ROW_VALUE_CONSTRUCTOR

public static final int DSI_SQL92_ROW_VALUE_CONSTRUCTOR
A UINT32 bitmask enumerating the row value constructor expressions supported in a SELECT statement, as defined in SQL-92.

This bitmask is composed of OR'ing 0 or more of the following values.

default: DSI_SRVC_VALUE_EXPRESSION

See Also:
Constant Field Values

DSI_SQL92_STRING_FUNCTIONS

public static final int DSI_SQL92_STRING_FUNCTIONS
A UINT32 bitmask enumerating the string scalar functions that are supported by the driver and the associated data source, as defined in SQL-92.

This bitmask is composed of OR'ing 0 or more of the following values.

default: DSI_SSF_LOWER | DSI_SSF_UPPER

See Also:
Constant Field Values

DSI_SQL92_VALUE_EXPRESSIONS

public static final int DSI_SQL92_VALUE_EXPRESSIONS
A UINT32 bitmask enumerating the value expressions supported, as defined in SQL-92. The SQL-92 or FIPS conformance level at which this feature needs to be supported is shown in parentheses next to each bitmask.

This bitmask is composed of OR'ing 0 or more of the following values.

default: DSI_SVE_CASE | DSI_SVE_CAST | DSI_SVE_COALESCE | DSI_SVE_NULLIF

See Also:
Constant Field Values

DSI_MAX_PARAMSET_COUNT

public static final int DSI_MAX_PARAMSET_COUNT
A UINT32 indicating the maximum number of parameter sets that can be set to execute a query. Default: 0 (No Limit)

See Also:
Constant Field Values

DSI_CONN_SHOULD_COMPRESS

public static final int DSI_CONN_SHOULD_COMPRESS
ODBC only property. A UINT16 indicating whether the SQLEngine should compress data internally. This should be enabled if the data can be compressed, and if the queries that are run often cause the SQLEngine to reach its memory limit, and swap to disk. Default: 0 (No compression)

See Also:
Constant Field Values

DSI_CONN_CONNECTION_STRING

public static final int DSI_CONN_CONNECTION_STRING
A string containing a connection string which can be used to achieve a valid connection.

See Also:
Constant Field Values

DSI_CONN_REFRESH_MODEL

public static final int DSI_CONN_REFRESH_MODEL
A UINT16 indicating what behaviour the driver should have around refreshing OAuth 1.0 or 2.0 access tokens.

See Also:
Constant Field Values

DSI_CONN_DRIVER_NAME

public static final int DSI_CONN_DRIVER_NAME
A string providing the name of the driver. By default, the driver name is inherited from driver properties of the driver singleton. It can be overridden at connection level. default: same value as the one set for the DSI_DRIVER_DRIVER_NAME property in DSIDriverProperties when the connection is created.

See Also:
Constant Field Values

DSI_CONN_DRIVER_VER

public static final int DSI_CONN_DRIVER_VER
A string with the version of the driver and optionally, a description of the driver. At a minimum, the version is of the form ##.##.####, where the first two digits are the major version, the next two digits are the minor version, and the last four digits are the release version. By default, the driver version is inherited from driver properties of the driver singleton. It can be overridden at connection level. default: same value as the one set for the DSI_DRIVER_VER property in DSIDriverProperties when the connection is created.

See Also:
Constant Field Values

DSI_TRANSLATE_LIB

public static final int DSI_TRANSLATE_LIB
A simba_wstring corresponding to the SQL_ATTR_TRANSLATE_LIB connection attribute. This contains the full path of the SQL translation shared library if one needs to be used. Default: L"" (empty string).

See Also:
Constant Field Values

DSI_TRANSLATE_OPTION

public static final int DSI_TRANSLATE_OPTION
A simba_uint32 corresponding to the SQL_ATTR_TRANSLATE_OPTION connection attribute. This contains the option that should be passed to calls to the SQL translation shared library. Default: 0

See Also:
Constant Field Values

DSI_CONN_APP_CHAR_ENCODING

public static final int DSI_CONN_APP_CHAR_ENCODING
MAINTENACE NOTE: In C++ DSI, DSI_CONN_APP_CHAR_ENCODING is a simba_int16 indicating which character encoding to convert to/from for SQL_C_CHAR data for each connection. However, the JVM on the Java side doesn't require this property. Therefore, to preserve the correspondence of property ID's between C++ and Java, The ID number 171 is intentionally skipped. Default: Determines the platform or environment default from simba_wstring::GetAppCharEncoding.

See Also:
Constant Field Values

DSI_CONN_RETURN_ESCAPE_CLAUSE

public static final int DSI_CONN_RETURN_ESCAPE_CLAUSE
A UINT32 bitmask describing this connection's support for the ODBC 4.0 'return' escape clause. For example, {RETURN Id1, Id2 FROM 'INSERT INTO T1 (C1, C2) VALUES (''Hello'', ''World'')'} Note that DSI_RC_XXX_ANY implies DSI_RC_XXX_ROWID. This bitmask is composed of OR'ing 0 or more of the following values: Default: 0

See Also:
Constant Field Values

DSI_SUPPORTS_SAVEPOINTS

public static final int DSI_SUPPORTS_SAVEPOINTS
An INT16 value indicating if Savepoints are supported or not.

The possible values are:

Default: DSI_SUPPORTS_SAVEPOINTS_FALSE

See Also:
Constant Field Values

DSI_SUPPORTS_UPDATABLE_RESULT_SETS

public static final int DSI_SUPPORTS_UPDATABLE_RESULT_SETS
An UINT32 bitmask indicating the level of support for updatable result sets.

The possible values are:

Default: DSI_SUPPORTS_URS_NONE

See Also:
Constant Field Values

DSI_RESULT_SET_CHANGES_DETECTED

public static final int DSI_RESULT_SET_CHANGES_DETECTED
An UINT32 bitmask indicating the level of support for detecting changes in result sets.

The possible values are:

See Also:
Constant Field Values

DSI_SUPPORTS_STORED_FUNCTIONS_USING_CALL_SYNTAX

public static final int DSI_SUPPORTS_STORED_FUNCTIONS_USING_CALL_SYNTAX
An INT16 value indicating if stored function calls are supported or not.

The possible values are:

Default: DSI_SUPPORTS_STORED_FUNCTIONS_FALSE

See Also:
Constant Field Values

DSI_MAX_VARBINARY_LEN

public static final int DSI_MAX_VARBINARY_LEN
An INT32 value specifying the maximum length of a VARBINARY type. This property can be set to bypass a call to the TYPE_INFO metadata table when a prepared statement is created. A return value of "0" means that the limit is not set or unknown and should be infered from type metadata. Default: 0 (Unknown)

See Also:
Constant Field Values

DSI_MAX_VARCHAR_LEN

public static final int DSI_MAX_VARCHAR_LEN
An INT32 value specifying the maximum length of a VARCHAR type. This property can be set to bypass a call to the TYPE_INFO metadata table when a prepared statement is created. A return value of "0" means that the limit is not set or unknown and should be infered from type metadata. Default: 0 (Unknown)

See Also:
Constant Field Values

DSI_SUPPORTS_STREAMED_BATCH_PREPARED_STMTS

public static final int DSI_SUPPORTS_STREAMED_BATCH_PREPARED_STMTS
A String:

default: "N"

See Also:
Constant Field Values

DSI_STREAM_BUFFER_SIZE

public static final int DSI_STREAM_BUFFER_SIZE
An INT32 value specifying the chunk size used to retrieve data from the DSII for output streams (i.e. the streams returned from SForwardResultSet.getBinaryStream() and similar methods.) Default: DSI_DEFAULT_STREAM_BUFFER_SIZE

See Also:
Constant Field Values

DSI_CONN_CURRENT_SCHEMA

public static final int DSI_CONN_CURRENT_SCHEMA
A character string containing the name of the schema to be used by the data source.

default: ""

See Also:
Constant Field Values

DSI_CONN_SAVEPOINT_IMPLICIT_BEGIN_TXN

public static final int DSI_CONN_SAVEPOINT_IMPLICIT_BEGIN_TXN
An INT32 value specifying the implicit begin of the transaction

default: 0 (Unknown)

See Also:
Constant Field Values

DSI_GET_GENERATED_KEYS

public static final int DSI_GET_GENERATED_KEYS
A String indicating if the data source supports getGeneratedKeys. default: "N"

See Also:
Constant Field Values
Constructor Detail

ConnPropertyKey

public ConnPropertyKey()
Method Detail

keySet

public static java.util.Set<java.lang.Integer> keySet()
Get an unmodifiable set containing all of the ConnPropertyKey literals.

Returns:
an unmodifiable set containing all of the ConnPropertyKey literals.


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