Result = filelabel{PROP:GETINFO, property}
(NOTE: Not valid for ORACLE Accelerator)
Use this property to retrieve information about a connection to any ODBC (or SQL) data source. This property is basically a wrapper to the SQLGetInfo ODBC API. The data returned is dependent of the “request” and can be returned in a string form or a long. When it is a LONG, the value needs to be “interpreted” using a bitmask.
The full list of available ODBC properties can be found in ODBCATTR.INC:
SQL_ACTIVE_CONNECTIONS EQUATE(0)
SQL_ACTIVE_STATEMENTS EQUATE(1)
SQL_DATA_SOURCE_NAME EQUATE(2)
SQL_DRIVER_HDBC EQUATE(3)
SQL_DRIVER_HENV EQUATE(4)
SQL_DRIVER_HSTMT EQUATE(5)
SQL_DRIVER_NAME EQUATE(6)
SQL_DRIVER_VER EQUATE(7)
SQL_FETCH_DIRECTION EQUATE(8)
SQL_ODBC_API_CONFORMANCE EQUATE(9)
SQL_ODBC_VER EQUATE(10)
SQL_ROW_UPDATES EQUATE(11)
SQL_ODBC_SAG_CLI_CONFORMANCE EQUATE(12)
SQL_SERVER_NAME EQUATE(13)
SQL_SEARCH_PATTERN_ESCAPE EQUATE(14)
SQL_ODBC_SQL_CONFORMANCE EQUATE(15)
SQL_DBMS_NAME EQUATE(17)
SQL_DBMS_VER EQUATE(18)
SQL_ACCESSIBLE_TABLES EQUATE(19)
SQL_ACCESSIBLE_PROCEDURES EQUATE(20)
SQL_PROCEDURES EQUATE(21)
SQL_CONCAT_NULL_BEHAVIOR EQUATE(22)
SQL_CURSOR_COMMIT_BEHAVIOR EQUATE(23)
SQL_CURSOR_ROLLBACK_BEHAVIOR EQUATE(24)
SQL_DATA_SOURCE_READ_ONLY EQUATE(25)
SQL_DEFAULT_TXN_ISOLATION EQUATE(26)
SQL_EXPRESSIONS_IN_ORDERBY EQUATE(27)
SQL_IDENTIFIER_CASE EQUATE(28)
SQL_IDENTIFIER_QUOTE_CHAR EQUATE(29)
SQL_MAX_COLUMN_NAME_LEN EQUATE(30)
SQL_MAX_CURSOR_NAME_LEN EQUATE(31)
SQL_MAX_OWNER_NAME_LEN EQUATE(32)
SQL_MAX_PROCEDURE_NAME_LEN EQUATE(33)
SQL_MAX_QUALIFIER_NAME_LEN EQUATE(34)
SQL_MAX_TABLE_NAME_LEN EQUATE(35)
SQL_MULT_RESULT_SETS EQUATE(36)
SQL_MULTIPLE_ACTIVE_TXN EQUATE(37)
SQL_OUTER_JOINS EQUATE(38)
SQL_OWNER_TERM EQUATE(39)
SQL_PROCEDURE_TERM EQUATE(40)
SQL_QUALIFIER_NAME_SEPARATOR EQUATE(41)
SQL_QUALIFIER_TERM EQUATE(42)
SQL_SCROLL_CONCURRENCY EQUATE(43)
SQL_SCROLL_OPTIONS EQUATE(44)
SQL_TABLE_TERM EQUATE(45)
SQL_TXN_CAPABLE EQUATE(46)
SQL_USER_NAME EQUATE(47)
SQL_CONVERT_FUNCTIONS EQUATE(48)
SQL_NUMERIC_FUNCTIONS EQUATE(49)
SQL_STRING_FUNCTIONS EQUATE(50)
SQL_SYSTEM_FUNCTIONS EQUATE(51)
SQL_TIMEDATE_FUNCTIONS EQUATE(52)
SQL_CONVERT_BIGINT EQUATE(53)
SQL_CONVERT_BINARY EQUATE(54)
SQL_CONVERT_BIT EQUATE(55)
SQL_CONVERT_CHAR EQUATE(56)
SQL_CONVERT_DATE EQUATE(57)
SQL_CONVERT_DECIMAL EQUATE(58)
SQL_CONVERT_DOUBLE EQUATE(59)
SQL_CONVERT_FLOAT EQUATE(60)
SQL_CONVERT_INTEGER EQUATE(61)
SQL_CONVERT_LONGVARCHAR EQUATE(62)
SQL_CONVERT_NUMERIC EQUATE(63)
SQL_CONVERT_REAL EQUATE(64)
SQL_CONVERT_SMALLINT EQUATE(65)
SQL_CONVERT_TIME EQUATE(66)
SQL_CONVERT_TIMESTAMP EQUATE(67)
SQL_CONVERT_TINYINT EQUATE(68)
SQL_CONVERT_VARBINARY EQUATE(69)
SQL_CONVERT_VARCHAR EQUATE(70)
SQL_CONVERT_LONGVARBINARY EQUATE(71)
SQL_TXN_ISOLATION_OPTION EQUATE(72)
SQL_ODBC_SQL_OPT_IEF EQUATE(73)
! ODBC SDK 1.0 Additions
SQL_CORRELATION_NAME EQUATE(74)
SQL_NON_NULLABLE_COLUMNS EQUATE(75)
! ODBC SDK 2.0 Additions
SQL_DRIVER_HLIB EQUATE(76)
SQL_DRIVER_ODBC_VER EQUATE(77)
SQL_LOCK_TYPES EQUATE(78)
SQL_POS_OPERATIONS EQUATE(79)
SQL_POSITIONED_STATEMENTS EQUATE(80)
SQL_GETDATA_EXTENSIONS EQUATE(81)
SQL_BOOKMARK_PERSISTENCE EQUATE(82)
SQL_STATIC_SENSITIVITY EQUATE(83)
SQL_FILE_USAGE EQUATE(84)
SQL_NULL_COLLATION EQUATE(85)
SQL_ALTER_TABLE EQUATE(86)
SQL_COLUMN_ALIAS EQUATE(87)
SQL_GROUP_BY EQUATE(88)
SQL_KEYWORDS EQUATE(89)
SQL_ORDER_BY_COLUMNS_IN_SELECT EQUATE(90)
SQL_OWNER_USAGE EQUATE(91)
SQL_QUALIFIER_USAGE EQUATE(92)
SQL_QUOTED_IDENTIFIER_CASE EQUATE(93)
SQL_SPECIAL_CHARACTERS EQUATE(94)
SQL_SUBQUERIES EQUATE(95)
SQL_UNION EQUATE(96)
SQL_MAX_COLUMNS_IN_GROUP_BY EQUATE(97)
SQL_MAX_COLUMNS_IN_INDEX EQUATE(98)
SQL_MAX_COLUMNS_IN_ORDER_BY EQUATE(99)
SQL_MAX_COLUMNS_IN_SELECT EQUATE(100)
SQL_MAX_COLUMNS_IN_TABLE EQUATE(101)
SQL_MAX_INDEX_SIZE EQUATE(102)
SQL_MAX_ROW_SIZE_INCLUDES_LONG EQUATE(103)
SQL_MAX_ROW_SIZE EQUATE(104)
SQL_MAX_STATEMENT_LEN EQUATE(105)
SQL_MAX_TABLES_IN_SELECT EQUATE(106)
SQL_MAX_USER_NAME_LEN EQUATE(107)
SQL_MAX_CHAR_LITERAL_LEN EQUATE(108)
SQL_TIMEDATE_ADD_INTERVALS EQUATE(109)
SQL_TIMEDATE_DIFF_INTERVALS EQUATE(110)
SQL_NEED_LONG_DATA_LEN EQUATE(111)
SQL_MAX_BINARY_LITERAL_LEN EQUATE(112)
SQL_LIKE_ESCAPE_CLAUSE EQUATE(113)
SQL_QUALIFIER_LOCATION EQUATE(114)