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