Progress
ODBC Driver Guide
SQLGetInfo
This appendix shows information the Progress SQL-92 ODBC Driver returns to SQLGetInfo.
Table A–1 describes return values to SQLGetInfo from the Progress SQL-92 ODBC driver.
Table A–1: Information the Progress SQL-92 ODBC Driver Returns to SQLGetInfo Description fInfoType Argument Returns Guaranteed execute privileges on all procedures returned by SQLProcedures SQL_ACCESSIBLE
_PROCEDURES N Guaranteed read access to all table names returned by SQLTables SQL_ACCESSIBLE_TABLES N Maximum number of active connections SQL_ACTIVE_
CONNECTIONS 0 Maximum number of active statements supported for an active connection SQL_ACTIVE_STATEMENTS 0 Maximum number of active environments SQL_ACTIVE_
ENVIRONMENTS 0 Support for ALTER DOMAIN statement SQL_ALTER_DOMAIN 0x00000000 Support for ALTER TABLE clauses SQL_ALTER_TABLE 0x00000000 SQL Conformance SQL_SQL_CONFORMANCE SQL_SC_SQL92_ENTRY Support for datetime literals SQL_DATETIME_LITERALS 0x00000000 Level of asynchronous mode support SQL_ASYNC_MODE SQL_AM_NONE Behavior with respect to the availability of row counts in batches SQL_BATCH_ROW_COUNT 0x00000000 Support for batches SQL_BATCH_SUPPORT 0x00000000 Support for bookmarks SQL_BOOKMARK_
PERSISTENCE SQL_BP_UPDATE SQL_BP_SCROLL Position of qualifier in a qualified table name SQL_CATALOG_LOCATION 0 (does not support) Support for catalog names SQL_CATALOG_NAME N Character used to separate table, column qualifiers SQL_CATALOG_NAME_
SEPARATOR “ ” Term for object that qualifies table names SQL_CATALOG_TERM “ ” Statements that support qualifiers SQL_CATALOG_USAGE 0x00000000 Default collation sequence name for the default character set SQL_COLLATION_SEQ “ ” Support for column aliases SQL_COLUMN_ALIAS Y Result of concatenation of NULL character column with non-NULL column SQL_CONCAT_NULL_
BEHAVIOR SQL_CB_NULL = 0 Conversion from BIGINT SQL_CONVERT_BIGINT SQL_CVT_CHAR
SQL_CVT_BIGINT
SQL_CVT_TINYINT
SQL_CVT_SMALLINT
SQL_CVT_INTEGER
SQL_CVT_FLOAT
SQL_CVT_DOUBLE Conversion from BINARY SQL_CONVERT_BINARY 0x00000000 Conversion from BIT SQL_CONVERT_BIT 0x00000000 Conversion from CHAR SQL_CONVERT_CHAR SQL_CVT_CHAR
SQL_CVT_NUMERIC
SQL_CVT_DECIMAL
SQL_CVT_INTEGER
SQL_CVT_SMALLINT
SQL_CVT_FLOAT
SQL_CVT_REAL
SQL_CVT_DOUBLE
SQL_CVT_VARCHAR
SQL_CVT_TINYINT
SQL_CVT_BIGINT
SQL_CVT_DATE
SQL_CVT_TIME
SQL_CVT_TIMESTAMP Conversion from DATE SQL_CONVERT_DATE SQL_CVT_CHAR
SQL_CVT_VARCHAR
SQL_CVT_DATE
SQL_CVT_TIMESTAMP Conversion from DECIMAL SQL_CONVERT_DECIMAL SQL_CVT_CHAR
SQL_CVT_NUMERIC
SQL_CVT_DECIMAL
SQL_CVT_INTEGER
SQL_CVT_SMALLINT
SQL_CVT_FLOAT
SQL_CVT_REAL
SQL_CVT_DOUBLE
SQL_CVT_VARCHAR
SQL_CVT_TINYINT
SQL_CVT_BIGINT Conversion from DOUBLE SQL_CONVERT_DOUBLE SQL_CVT_CHAR
SQL_CVT_NUMERIC
SQL_CVT_DECIMAL
SQL_CVT_INTEGER
SQL_CVT_SMALLINT
SQL_CVT_FLOAT
SQL_CVT_REAL
SQL_CVT_DOUBLE
SQL_CVT_VARCHAR
SQL_CVT_TINYINT
SQL_CVT_BIGINT Conversion from FLOAT SQL_CONVERT_FLOAT SQL_CVT_CHAR
SQL_CVT_NUMERIC
SQL_CVT_DECIMAL
SQL_CVT_INTEGER
SQL_CVT_SMALLINT
SQL_CVT_FLOAT
SQL_CVT_REAL
SQL_CVT_DOUBLE
SQL_CVT_VARCHAR
SQL_CVT_TINYINT
SQL_CVT_BIGINT Support for conversion functions SQL_CONVERT_FUNCTIONS SQL_FN_CVT_CONVERT Conversion from INTEGER SQL_CONVERT_INTEGER SQL_CVT_CHAR
SQL_CVT_NUMERIC
SQL_CVT_DECIMAL
SQL_CVT_INTEGER
SQL_CVT_SMALLINT
SQL_CVT_FLOAT
SQL_CVT_REAL
SQL_CVT_DOUBLE
SQL_CVT_VARCHAR
SQL_CVT_TINYINT
SQL_CVT_BIGINT Conversion from INTERVAL_DAY_TIME SQL_CONVERT_INTERVAL_
DAY_TIME 0x00000000 Conversion from INTERVAL_YEAR_MONTH SQL_CONVERT_INTERVAL_
YEAR_MONTH 0x00000000 Conversion from LONGVARBINARY SQL_CONVERT
_LONGVARBINARY 0x00000000 Conversion from LONGVARCHAR SQL_CONVERT_
LONGVARCHAR 0x00000000 Conversion from NUMERIC SQL_CONVERT_NUMERIC SQL_CVT_CHAR
SQL_CVT_NUMERIC
SQL_CVT_DECIMAL
SQL_CVT_INTEGER
SQL_CVT_SMALLINT
SQL_CVT_FLOAT
SQL_CVT_REAL
SQL_CVT_DOUBLE
SQL_CVT_VARCHAR
SQL_CVT_TINYINT
SQL_CVT_BIGINT Conversion from REAL SQL_CONVERT_REAL SQL_CVT_CHAR
SQL_CVT_NUMERIC
SQL_CVT_DECIMAL
SQL_CVT_INTEGER
SQL_CVT_SMALLINT
SQL_CVT_FLOAT
SQL_CVT_REAL
SQL_CVT_DOUBLE
SQL_CVT_VARCHAR
SQL_CVT_TINYINT
SQL_CVT_BIGINT Conversion from SMALLINT SQL_CONVERT_SMALLINT SQL_CVT_CHAR
SQL_CVT_NUMERIC
SQL_CVT_DECIMAL
SQL_CVT_INTEGER
SQL_CVT_SMALLINT
SQL_CVT_FLOAT
SQL_CVT_REAL
SQL_CVT_DOUBLE
SQL_CVT_VARCHAR
SQL_CVT_TINYINT
SQL_CVT_BIGINT Conversion from TIME SQL_CONVERT_TIME SQL_CVT_CHAR
SQL_CVT_TIME
SQL_CVT_TIMESTAMP Conversion from TIMESTAMP SQL_CONVERT_TIMESTAMP SQL_CVT_CHAR
SQL_CVT_VARCHAR
SQL_CVT_DATE
SQL_CVT_TIME
SQL_CVT_TIMESTAMP Conversion from TINYINT SQL_CONVERT_TINYINT SQL_CVT_CHAR
SQL_CVT_NUMERIC
SQL_CVT_DECIMAL
SQL_CVT_INTEGER
SQL_CVT_SMALLINT
SQL_CVT_FLOAT
SQL_CVT_REAL
SQL_CVT_DOUBLE
SQL_CVT_VARCHAR
SQL_CVT_TINYINT
SQL_CVT_BIGINT Conversion from VARBINARY SQL_CONVERT_
VARBINARY 0x00000000 Conversion from VARCHAR SQL_CONVERT_VARCHAR SQL_CVT_CHAR
SQL_CVT_NUMERIC
SQL_CVT_DECIMAL
SQL_CVT_INTEGER
SQL_CVT_SMALLINT
SQL_CVT_FLOAT
SQL_CVT_REAL
SQL_CVT_DOUBLE
SQL_CVT_VARCHAR
SQL_CVT_TINYINT
SQL_CVT_BIGINT SQL_CVT_DATE
SQL_CVT_TIME SQL_CVT_TIMESTAMP Conversion from WCHAR SQL_CONVERT_WCHAR 0x00000000 Conversion from WLONGVAR
CHAR SQL_CONVERT_
WLONGVARCHAR 0x00000000 Conversion from WVARCHAR SQL_CONVERT_WVARCHAR 0x00000000 Support for table correlation names SQL_CORRELATION_NAME SQL_CN_DIFFERENT Support for CREATE ASSERTION statement SQL_CREATE_ASSERTION 0x00000000 Support for CREATE CHARACTER SET statement SQL_CREATE_
CHARACTER SET 0x00000000 Support for CREATE COLLATION statement SQL_CREATE_COLLATION 0x00000000 Support for CREATE DOMAIN statement SQL_CREATE_DOMAIN 0x00000000 Support for CREATE SCHEMA statement SQL_CREATE_SCHEMA 0x00000000 Support for CREATE TABLE statement SQL_CREATE_TABLE SQL_CT_CREATE_
TABLE
SQL_CT_COLUMN
_CONSTRAINT
SQL_CT_TABLE
_CONSTRAINT Support for CREATE TRANSLATION statement SQL_CREATE_
TRANSLATION 0x00000000 Support for CREATE VIEW statement SQL_CREATE_VIEW SQL_CV_CREATE_VIEW
SQL_CV_CHECK_OPTION Effect of COMMIT operation on cursors and prepared statements SQL_CURSOR_COMMIT_
BEHAVIOR SQL_CB_PRESERVE Effect of ROLLBACK operation on cursors and prepared statements SQL_CURSOR_ROLLBACK
_BEHAVIOR 0x00000000 Support for cursor sensitivity SQL_CURSOR_SENSITIVITY SQL_INSENSITIVE Name of the data source as specified to the ODBC Administrator SQL_DATA_SOURCE_NAME (string containing the name) Access limited to read-only SQL_DATA_SOURCE_READ_
ONLY N (read-write access) Name of the Progress SQL-92 ODBC data source on the server system SQL_DATABASE_NAME (string containing the name) Name of the database product supporting the data source SQL_DBMS_NAME PROGRESS Version of the database product SQL_DBMS_VER 09.1A Default transaction isolation level SQL_DEFAULT_TXN_
ISOLATION SQL_TXN_REPEATABLE_
READ Support for describing parameters via DESCRIBE INPUT statement SQL_DESCRIBE_
PARAMETER Y (supports) Version of the driver manager SQL_DM_VER 03.51.37110.0000 Connection handle determined by the argument InfoType SQL_DRIVER_HDBC 0x0013EBE0 Driver’s descriptor handle determined by the Driver Manager’s descriptor handle SQL_DRIVER_HDESC 0x0013F820 Environment handle determined by the argument InfoType SQL_DRIVER_HENV 0x0013C8A0 Handle library from the load library returned to the Driver Manager when it loaded the driver DLL SQL_DRIVER_HLIB 0x28660000 Driver’s statement handle determined by the Driver Manager’s statement handle SQL_DRIVER_HSTMT 0x001427E0 Name of the dynamic link library file for the ODBC Driver SQL_DRIVER_NAME PGPRO915.DLL Supported ODBC version SQL_DRIVER_ODBC_VER 03.51 Current version of the ODBC Driver SQL_DRIVER_VER 03.60.0000 Support for DROP ASSERTION statement SQL_DROP_ASSERTION 0x00000000 Support for DROP CHARACTER SET statement SQL_DROP_CHARACTER_
SET 0x00000000 Support for DROP COLLATION statement SQL_DROP_COLLATION 0x00000000 Support for DROP DOMAIN statement SQL_DROP_DOMAIN 0x00000000 Support for DROP SCHEMA statement SQL_DROP_SCHEMA 0x00000000 Support for DROP TABLE statement SQL_DROP_TABLE SQL_DT_DROP_TABLE Support for DROP TRANSLATION statement SQL_DROP_TRANSLATION 0x00000000 Support for DROP VIEW statement SQL_DROP_VIEW SQL_DT_DROP_VIEW Supported attributes of a dynamic cursor: subset 1 SQL_DYNAMIC_CURSOR_
ATTRIBUTES1 0x00000000 Supported attributes of a dynamic cursor: subset 2 SQL_DYNAMIC_CURSOR_
ATTRIBUTES2 0x00000000 Support for expressions in ORDER BY clause SQL_EXPRESSIONS_IN_
ORDERBY Y Supported fetch direction options SQL_FETCH_DIRECTION SQL_FD_FETCH_NEXT
SQL_FD_FETCH_FIRST
SQL_FD_FETCH_LAST
SQL_FD_FETCH_PRIOR
SQL_FD_FETCH_
ABSOLUTE
SQL_FD_FETCH_
RELATIVE
SQL_FD_FETCH_
BOOKMARK Single-tier driver behavior SQL_FILE_USAGE SQL_FILE_NOT
_SUPPORTED Supported attributes of a forward-only cursor: subset 1 SQL_FORWARD_ONLY_
CURSOR_ATTRIBUTES1 SQL_CA1_NEXT
SQL_CA1_BULK_ADD Supported attributes of a forward-only cursor: subset 2 SQL_FORWARD_ONLY_
CURSOR_ATTRIBUTES2 SQL_CA2_MAX_ROWS_
SELECT
SQL_CA2_MAX_ROWS_
CATALOG Supported extensions to SQLGetData SQL_GETDATA_
EXTENSIONS SQL_GD_ANY_COLUMN
SQL_GD_ANY_ORDER
SQL_GD_BOUND Relationship between GROUP BY clause and columns in the select list SQL_GROUP_BY SQL_GB_GROUP_BY
_CONTAINS_SELECT Case sensitivity of user-supplied names SQL_IDENTIFIER_CASE SQL_IC_UPPER Character used to enclose delimited identifiers SQL_IDENTIFIER_QUOTE_
CHAR " (double quotation mark) Keywords supported in the CREATE INDEX statement SQL_INDEX_KEYWORDS SQL_IK_ASC |
SQL_IK_DESC Supported views in INFORMATION_SCHEMA SQL_INFO_SCHEMA_VIEWS 0x00000000 Support for Integrity Enhancement Facility SQL_INTEGRITY Y Supported attributes of a keyset cursor: subset 1 SQL_KEYSET_CURSOR_
ATTRIBUTES1 SQL_CA1_NEXT
SQL_CA1_ABSOLUTE SQL_CA1_RELATIVE SQL_CA1_BOOKMAR K
SQL_CA1_LOCK_NO_
CHANGE
SQL_CA1_POS_POSITION SQL_CA1_POS_UPDATE
SQL_CA1_POS_DELETE SQL_CA1_POS_REFRESH
SQL_CA1_POSITIONED
_UPDATE SQL_CA1_POSITIONED
_DELETE
SQL_CA1_SELECT_FOR
_UPDATE
SQL_CA1_BULK_ADD Supported attributes of a keyset cursor: subset 2 SQL_KEYSET_CURSOR_
ATTRIBUTES2 SQL_CA2_READ_ONLY_
CONCURRENCY
SQL_CA2_OPT_VALUES
_CONCURRENCY
SQL_CA2_SENSITIVITY
_DELETIONS
SQL_CA2_SENSITIVITY
_UPDATES SQL_CA2_MAX_ROWS
_SELECT
SQL_CA2_CRC_EXACT
SQL_CA2_SIMULATE
_TRY_UNIQUE Data source specific keywords SQL_KEYWORDS See the Progress SQL-92 Guide and Reference for a list of SQL Keywords. Support for escape clause in LIKE predicates SQL_LIKE_ESCAPE_CLAUSE Y Support for lock types SQL_LOCK_TYPES SQL_LCK_NO_CHANGE Maximum number of active concurrent statements in asynchronous mode SQL_MAX_ASYNC
_CONCURRENT_
STATEMENTS 0 Maximum length in hexadecimal characters of binary literals SQL_MAX_BINARY_
LITERAL_LEN 31995 Maximum length of a table or column qualifier SQL_MAX_CATALOG_NAME
_LEN 0 Maximum length in characters of character string literals SQL_MAX_CHAR_LITERAL_LEN 31995 Maximum length of a column name SQL_MAX_COLUMN_NAME
_LEN 32 Maximum number of columns allowed in GROUP BY clause SQL_MAX_COLUMNS_IN
_GROUP_BY 499 Maximum number of columns allowed in an index SQL_MAX_COLUMNS_IN
_INDEX 16 Maximum number of columns allowed in ORDER BY clause SQL_MAX_COLUMNS_IN
_ORDER_BY 0 Maximum number of columns allowed in a select list SQL_MAX_COLUMNS_IN
_SELECT 500 Maximum number of columns allowed in a table SQL_MAX_COLUMNS_IN
_TABLE 500 Maximum number of active SQL statements SQL_MAX_CONCURRENT
_ACTIVITIES 0 (no maximum) Maximum length of a cursor name SQL_MAX_CURSOR_NAME
_LEN 18 Maximum number of active connections SQL_MAX_DRIVER
_CONNECTIONS 0 Maximum length of user-defined names SQL_MAX_IDENTIFIER_LEN 32 Maximum number of bytes allowed in the combined fields of an index SQL_MAX_INDEX_SIZE 115 Maximum length of a procedure name SQL_MAX_PROCEDURE_
NAME_LEN 32 Maximum length in bytes of a table row SQL_MAX_ROW_SIZE 0 Whether maximum row size includes LONGVARCHAR and LONGVARBINARY SQL_MAX_ROW_SIZE
_INCLUDES_LONG N Maximum length of an owner name SQL_MAX_SCHEMA_NAME
_LEN 32 Maximum number of characters in an SQL statement SQL_MAX_STATEMENT_
LEN 131000 Maximum length of a table name SQL_MAX_TABLE_NAME_
LEN 32 Maximum number of tables allowed in FROM clause SQL_MAX_TABLES_IN_
SELECT 250 Maximum length of a user name SQL_MAX_USER_NAME_
LEN 32 Maximum length of owner name SQL_MAX_OWNER_NAME_
LEN 32 Maximum length of a qualifier name SQL_MAX_QUALIFIER_
NAME_LEN 0 Support for multiple result sets SQL_MULT_RESULT_SETS N Support for active transactions on multiple connections SQL_MULTIPLE_ACTIVE
_TXN Y Whether data source requires length of LONGVARCHAR and LONGVARBINARY data SQL_NEED_LONG_DATA
_LEN Y Support for NOT NULL clause in CREATE TABLE statement SQL_NON_NULLABLE
_COLUMNS SQL_NNC_NON_NULL Where null values are sorted in a list SQL_NULL_COLLATION SQL_NC_LOW Numeric functions supported SQL_NUMERIC_FUNCTIONS SQL_FN_NUM_ABS
SQL_FN_NUM_ACOS
SQL_FN_NUM_ASIN
SQL_FN_NUM_ATAN
SQL_FN_NUM_ATAN2
SQL_FN_NUM_CEILING
SQL_FN_NUM_COS
SQL_FN_NUM_EXP
SQL_FN_NUM_FLOOR
SQL_FN_NUM_MOD
SQL_FN_NUM_PI
SQL_FN_NUM_POWER
SQL_FN_NUM_RADIANS
SQL_FN_NUM_RAND
SQL_FN_NUM_ROUND
SQL_FN_NUM_SIGN
SQL_FN_NUM_SIN
SQL_FN_NUM_SQRT
SQL_FN_NUM_TAN SQL_FN_NUM_DEGREES SQL_FN_NUM_LOG10 Level of ODBC conformance SQL_ODBC_API
_CONFORMANCE SQL_OAC_LEVEL1 Level of ODBC 3.x interface conformance SQL_ODBC_INTERFACE
_CONFORMANCE SQL_OIC_CORE SQL Access Group (SAG) conformance SQL_ODBC_SAG_CLI
_CONFORMANCE SQL_OSCC_COMPLIANT Level of SQL conformance SQL_ODBC_SQL
_CONFORMANCE SQL_OSC_EXTENDED Referential integrity syntax support SQL_ODBC_SQL_OPT_IEF Y ODBC version supported by driver manager SQL_ODBC_VER 03.51.0000 Types of outer joins supported SQL_OJ_CAPABILITIES SQL_OJ_LEFT
SQL_OJ_RIGHT
SQL_OJ_NOT_ORDERED
SQL_OJ_INNER
SQL_OJ_ALL
_COMPARISON_OPS Whether columns in ORDER BY clause must also be in select list SQL_ORDER_BY_COLUMNS
_IN_SELECT N Support for outer joins SQL_OUTER_JOINS Y Name for an owner SQL_OWNER_TERM owner Statements in which owner may be used SQL_OWNER_USAGE SQL_OU_DML
_STATEMENTS
SQL_OU_PROCEDURE
_INVOCATION
SQL_OU_TABLE
_DEFINITION
SQL_OU_INDEX
_DEFINITION
SQL_OU_PRIVILEGE
_DEFINITION Characteristics of row counts available in a parameterized execution SQL_PARAM_ARRAY_ROW
_COUNTS SQL_PARC_NO_BATCH Characteristics of result sets available in a parameterized execution SQL_PARAM_ARRAY_
SELECTS SQL_PAS_NO_SELECT Supported operations in SQLSetPos SQL_POS_OPERATIONS SQL_POS_POSITION
SQL_POS_REFRESH
SQL_POS_UPDATE
SQL_POS_DELETE
SQL_POS_ADD Supported positioned SQL statements SQL_POSITIONED_
STATEMENTS SQL_PS_POSITIONED
_DELETE
SQL_PS_POSITIONED
_UPDATE
SQL_PS_SELECT_FOR
_UPDATE Term for procedures SQL_PROCEDURE_TERM procedure SQL procedures support SQL_PROCEDURES Y Support for qualifiers SQL_QUALIFIER_USAGE 0x00000000 Case sensitivity of quoted user-supplied names SQL_QUOTED_IDENTIFIER
_CASE SQL_IC_MIXED Separator character used between qualifier name and element SQL_QUALIFIER_NAME
_SEPARATOR “ ” Term used for a qualifier SQL_QUALIFIER_TERM “ ” Position of the qualifier in a qualified table name SQL_QUALIFIER_LOCATION 0 (does not support) Detect changes to any row in mixed-cursor operations SQL_ROW_UPDATES Y Term for entity that has owner privileges on objects SQL_SCHEMA_TERM owner Statements that support use of owner qualifiers SQL_SCHEMA_USAGE SQL_OU_DML_
STATEMENTS
SQL_OU_PROCEDURE
_INVOCATION
SQL_OU_TABLE
_DEFINITION
SQL_OU_INDEX
_DEFINITION
SQL_OU_PRIVILEGE
_DEFINITION Options supported for scrollable cursors SQL_SCROLL_OPTIONS SQL_SO_FORWARD
_ONLY
SQL_SO_STATIC
SQL_SO_KEYSET_DRIVEN Support for scrollable cursors SQL_SCROLL_
CONCURRENCY SQL_SCCO_READ_ONLY
SQL_SCCO_OPT_VALUES Character to permit wildcard characters in search strings SQL_SEARCH_PATTERN
_ESCAPE \ (backslash) Name of the system where the Progress SQL-92 ODBC data source resides SQL_SERVER_NAME (string containing the name) Special characters allowed in user-supplied names SQL_SPECIAL_
CHARACTERS “_”, “%” Datetime scalar functions supported SQL_SQL92_DATETIME
_FUNCTIONS 0x00000000 Behavior of DELETE statement that refers to a foreign key SQL_SQL92_FOREIGN_KEY
_DELETE_RULE 0x00000000 Behavior of UPDATE statement that refers to a foreign key SQL_SQL92_FOREIGN_KEY
_UPDATE_RULE 0x00000000 GRANT statement clauses supported SQL_SQL92_GRANT SQL_SG_DELETE_TABLE
SQL_SG_INSERT_TABLE SQL_SG_INSERT
_COLUMN
SQL_SG_REFERENCES
_TABLE SQL_SG_REFERENCES
_COLUMN SQL_SG_SELECT_TABLE SQL_SG_UPDATE
_TABLE SQL_SG_UPDATE
_COLUMN Numeric scalar functions supported SQL_SQL92_NUMERIC_
VALUE_FUNCTIONS SQL_SNVF_CHAR
_LENGTH
SQL_SNVF_CHARACTER
_LENGTH Predicates supported SQL_SQL92_PREDICATES SP_EXISTS SQL_SP_ISNOTNULL SQL_SP_ISNULL SQL_SP_UNIQUE SQL_SP_LIKE
SQL_SP_IN SQL_SP_BETWEEN Relational join operators supported SQL_SQL92_RELATIONAL
_JOIN_OPERATORS 0x00000000 REVOKE statement clauses supported SQL_SQL92_REVOKE SQL_SR_GRANT_
OPTION_FOR SQL_SR_CASCADE SQL_SR_DELETE_TABLE
SQL_SR_INSERT_TABLE SQL_SR_INSERT
_COLUMN SQL_SR_REFERENCES
_TABLE SQL_SR_REFERENCES
_COLUMN SQL_SR_SELECT_TABLE SQL_SR_UPDATE
_TABLE SQL_SR_UPDATE
_COLUMN Row value constructor expressions supported SQL_SQL92_ROW_VALUE
_CONSTRUCTOR 0x00000000 String scalar functions supported SQL_SQL92_STRING
_FUNCTIONS SQL_SSF_CONVERT
SQL_SSF_LOWER SQL_SSF_UPPER SQL_SSF_SUBSTRING SQL_SSF_TRANSLATE SQL_SSF_TRIM
_LEADING SQL_SSF_TRIM_TRAILING Value expressions supported SQL_SQL92_VALUE
_EXPRESSIONS SQL_SVE_COALESCE SQL_SVE_NULLIF CLI standards to which the driver conforms SQL_STANDARD_CLI
_CONFORMANCE SQL_SCC_XOPEN_CLI
_VERSION1 Supported attributes of a static cursor: subset 1 SQL_STATIC_CURSOR
_ATTRIBUTES1 SQL_CA1_NEXT
SQL_CA1_ABSOLUTE SQL_CA1_RELATIVE SQL_CA1_BOOKMARK
SQL_CA1_LOCK_NO
_CHANGE
SQL_CA1_POS_POSITION SQL_CA1_POS_UPDATE
SQL_CA1_POS_DELETE SQL_CA1_POS_REFRESH
SQL_CA1_POSITIONED
_UPDATE SQL_CA1_POSITIONED
_DELETE
SQL_CA1_SELECT_FOR
_UPDATE
SQL_CA1_BULK_ADD Supported attributes of a static cursor: subset 2 SQL_STATIC_CURSOR
_ATTRIBUTES2 SQL_CA2_READ_ONLY
_CONCURRENCY
SQL_CA2_OPT_VALUES
_CONCURRENCY SQL_CA2_CRC_EXACT
SQL_CA2_SIMULATE
_TRY_UNIQUE Support for detection of changes made to a static or key-set driven cursor through SQLSetPos SQL_STATIC_SENSITIVITY 0x00000000 String functions supported SQL_STRING_FUNCTIONS SQL_FN_STR_CONCAT SQL_FN_STR_INSERT SQL_FN_STR_LEFT SQL_FN_STR_LTRIM SQL_FN_STR_LENGTH SQL_FN_STR_LOCATE SQL_FN_STR_LCASE SQL_FN_STR_REPEAT SQL_FN_STR_REPLACE SQL_FN_STR_RIGHT SQL_FN_STR_RTRIM SQL_FN_STR
_SUBSTRING SQL_FN_STR_UCASE SQL_FN_STR_ASCII SQL_FN_STR_CHAR SQL_FN_STR
_DIFFERENCE SQL_FN_STR_LOCATE_2 SQL_FN_STR_SPACE SQL_FN_STR_CHAR
_LENGTH
SQL_FN_STR
_CHARACTER_LENGTH Predicates that support subqueries SQL_SUBQUERIES SQL_SQ_COMPARISON SQL_SQ_EXISTS
SQL_SQ_IN SQL_SQ_QUANTIFIED System functions supported SQL_SYSTEM_FUNCTIONS SQL_FN_SYS
_USERNAME Term for tables SQL_TABLE_TERM table Timestamp intervals supported for TIMESTAMPADD function SQL_TIMEDATE_ADD
_INTERVALS 0x00000000 Timestamp intervals supported for TIMESTAMPDIFF function SQL_TIMEDATE_DIFF
_INTERVALS 0x00000000 Date-time functions supported SQL_TIMEDATE_
FUNCTIONS SQL_FN_TD_NOW
SQL_FN_CURDATE
SQL_FN_TD
_DAYOFMONTH SQL_FN_TD
_DAYOFWEEK
SQL_FN_TD
_DAYOFYEAR SQL_FN_TD_MONTH SQL_FN_TD_QUARTER SQL_FN_TD_WEEK SQL_FN_TD_YEAR SQL_FN_CURTIME
SQL_FN_TD_HOUR SQL_FN_TD_MINUTE SQL_FN_TD_SECOND
SQL_FN_TD
_TIMESTAMP_ADD
SQL_FN_TD
_TIMESTAMPDIFF
SQL_FN_TD_DAYNAME
SQL_FN_TD
_MONTHNAME Support for DML, DDL within transactions SQL_TXN_CAPABLE SQL_TC_ALL Options for setting transaction isolation levels SQL_TXN_ISOLATION_
OPTION SQL_TXN_READ
_UNCOMMITTED
SQL_TXN
_SERIALIZABLE
SQL_TXN_READ
_COMMITTED
SQL_TXN_REPEATABLE
_READ UNION support SQL_UNION SQL_U_UNION SQL_U_UNION_ALL Name of user connected to the data source SQL_USER_NAME (string containing the name) Year of publication of the X/Open specification with which the driver complies SQL_XOPEN_CLI_YEAR 1995
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |