Test environment:
MS ODBC Test 2.60.0905
Oracle ODBC 8.1.7
Attached is the (slightly edited) output of 'Get Info All'.
Please note: Some values depend on the server release. However,
I couldn't encounter any SQL query activities (in v$sqlarea).
Steffen
20 SQL_ACCESSIBLE_PROCEDURES "Y"
19 SQL_ACCESSIBLE_TABLES "Y"
0 SQL_ACTIVE_CONNECTIONS 0
116 SQL_ACTIVE_ENVIRONMENTS 1
1 SQL_ACTIVE_STATEMENTS 0
117 SQL_ALTER_DOMAIN 0x00000000
86 SQL_ALTER_TABLE 0x000FB049 SQL_AT_ADD_COLUMN
| SQL_AT_ADD_CONSTRAINT | SQL_AT_ADD_COLUMN_DEFAULT | SQL_AT_ADD_TABLE_CONSTRAINT |
SQL_AT_DROP_TABLE_CONSTRAINT_CASCADE | SQL_AT_CONSTRAINT_NAME_DEFINITION |
SQL_AT_CONSTRAINT_INITIALLY_DEFERRED | SQL_AT_CONSTRAINT_INITIALLY_IMMEDIATE |
SQL_AT_CONSTRAINT_DEFERRABLE
10021 SQL_ASYNC_MODE 0 SQL_AM_NONE
120 SQL_BATCH_ROW_COUNT 0x00000000
121 SQL_BATCH_SUPPORT 0x00000000
82 SQL_BOOKMARK_PERSISTENCE 0x00000058
SQL_BP_TRANSACTION | SQL_BP_UPDATE | SQL_BP_SCROLL
114 SQL_CATALOG_LOCATION 2 SQL_CL_END
10003 SQL_CATALOG_NAME "N"
41 SQL_CATALOG_NAME_SEPARATOR "@"
42 SQL_CATALOG_TERM "Database Link"
92 SQL_CATALOG_USAGE 0x00000003
SQL_CU_DML_STATEMENTS | SQL_CU_PROCEDURE_INVOCATION
10004 SQL_COLLATION_SEQ ""
87 SQL_COLUMN_ALIAS "Y"
22 SQL_CONCAT_NULL_BEHAVIOR 1 SQL_CB_NON_NULL
53 SQL_CONVERT_BIGINT 0x000071FF 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_BIT | SQL_CVT_TINYINT |
SQL_CVT_BIGINT
54 SQL_CONVERT_BINARY 0x00000000
55 SQL_CONVERT_BIT 0x000071FF 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_BIT | SQL_CVT_TINYINT |
SQL_CVT_BIGINT
56 SQL_CONVERT_CHAR 0x0002F1FF 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_BIT | SQL_CVT_TINYINT |
SQL_CVT_BIGINT | SQL_CVT_DATE | SQL_CVT_TIMESTAMP
57 SQL_CONVERT_DATE 0x00028101 SQL_CVT_CHAR |
SQL_CVT_VARCHAR | SQL_CVT_DATE | SQL_CVT_TIMESTAMP
58 SQL_CONVERT_DECIMAL 0x000071FF 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_BIT | SQL_CVT_TINYINT |
SQL_CVT_BIGINT
59 SQL_CONVERT_DOUBLE 0x000071FF 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_BIT | SQL_CVT_TINYINT |
SQL_CVT_BIGINT
60 SQL_CONVERT_FLOAT 0x000071FF 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_BIT | SQL_CVT_TINYINT |
SQL_CVT_BIGINT
48 SQL_CONVERT_FUNCTIONS 0x00000001 SQL_FN_CVT_CONVERT
61 SQL_CONVERT_INTEGER 0x000071FF 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_BIT | SQL_CVT_TINYINT |
SQL_CVT_BIGINT
123 SQL_CONVERT_INTERVAL_DAY_TIME 0x00000000
124 SQL_CONVERT_INTERVAL_YEAR_MONTH 0x00000000
71 SQL_CONVERT_LONGVARBINARY 0x00000000
62 SQL_CONVERT_LONGVARCHAR 0x00000000
63 SQL_CONVERT_NUMERIC 0x000071FF 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_BIT | SQL_CVT_TINYINT |
SQL_CVT_BIGINT
64 SQL_CONVERT_REAL 0x000071FF 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_BIT | SQL_CVT_TINYINT |
SQL_CVT_BIGINT
65 SQL_CONVERT_SMALLINT 0x000071FF 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_BIT | SQL_CVT_TINYINT |
SQL_CVT_BIGINT
66 SQL_CONVERT_TIME 0x00000000
67 SQL_CONVERT_TIMESTAMP 0x00028101 SQL_CVT_CHAR |
SQL_CVT_VARCHAR | SQL_CVT_DATE | SQL_CVT_TIMESTAMP
68 SQL_CONVERT_TINYINT 0x000071FF 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_BIT | SQL_CVT_TINYINT |
SQL_CVT_BIGINT
69 SQL_CONVERT_VARBINARY 0x00000000
70 SQL_CONVERT_VARCHAR 0x0002F1FF 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_BIT | SQL_CVT_TINYINT |
SQL_CVT_BIGINT | SQL_CVT_DATE | SQL_CVT_TIMESTAMP
122 SQL_CONVERT_WCHAR 0x00000000
125 SQL_CONVERT_WLONGVARCHAR 0x00000000
126 SQL_CONVERT_WVARCHAR 0x00000000
74 SQL_CORRELATION_NAME 2 SQL_CN_ANY
127 SQL_CREATE_ASSERTION 0x00000000
128 SQL_CREATE_CHARACTER_SET 0x00000000
129 SQL_CREATE_COLLATION 0x00000000
130 SQL_CREATE_DOMAIN 0x00000000
131 SQL_CREATE_SCHEMA 0x00000003
SQL_CS_CREATE_SCHEMA | SQL_CS_AUTHORIZATION
132 SQL_CREATE_TABLE 0x000037E1
SQL_CT_CREATE_TABLE | SQL_CT_CONSTRAINT_INITIALLY_DEFERRED |
SQL_CT_CONSTRAINT_INITIALLY_IMMEDIATE | SQL_CT_CONSTRAINT_DEFERRABLE |
SQL_CT_CONSTRAINT_NON_DEFERRABLE | SQL_CT_COLUMN_CONSTRAINT | SQL_CT_COLUMN_DEFAULT |
SQL_CT_TABLE_CONSTRAINT | SQL_CT_CONSTRAINT_NAME_DEFINITION
133 SQL_CREATE_TRANSLATION 0x00000000
134 SQL_CREATE_VIEW 0x00000003
SQL_CV_CREATE_VIEW | SQL_CV_CHECK_OPTION
23 SQL_CURSOR_COMMIT_BEHAVIOR 2 SQL_CB_PRESERVE
24 SQL_CURSOR_ROLLBACK_BEHAVIOR 2 SQL_CB_PRESERVE
10001 SQL_CURSOR_SENSITIVITY 1 SQL_INSENSITIVE
16 SQL_DATABASE_NAME ""
2 SQL_DATA_SOURCE_NAME "ora81"
25 SQL_DATA_SOURCE_READ_ONLY "N"
119 SQL_DATETIME_LITERALS 0x00000000
17 SQL_DBMS_NAME "Oracle"
18 SQL_DBMS_VER "08.01.0721"
26 SQL_DEFAULT_TXN_ISOLATION 2
SQL_TXN_READ_COMMITTED
10002 SQL_DESCRIBE_PARAMETER "Y"
171 SQL_DM_VER "03.52.6019.0000"
3 SQL_DRIVER_HDBC 0x01E11C90
135 SQL_DRIVER_HDESC 0x01E11650
4 SQL_DRIVER_HENV 0x01E10570
76 SQL_DRIVER_HLIB 0x04C00000
5 SQL_DRIVER_HSTMT 0x01E11710
6 SQL_DRIVER_NAME "SQORA32.DLL"
77 SQL_DRIVER_ODBC_VER "03.51"
7 SQL_DRIVER_VER "08.01.0704"
136 SQL_DROP_ASSERTION 0x00000000
137 SQL_DROP_CHARACTER_SET 0x00000000
138 SQL_DROP_COLLATION 0x00000000
139 SQL_DROP_DOMAIN 0x00000000
140 SQL_DROP_SCHEMA 0x00000000
141 SQL_DROP_TABLE 0x00000001 SQL_DT_DROP_TABLE
142 SQL_DROP_TRANSLATION 0x00000000
143 SQL_DROP_VIEW 0x00000001 SQL_DV_DROP_VIEW
144 SQL_DYNAMIC_CURSOR_ATTRIBUTES1
145 SQL_DYNAMIC_CURSOR_ATTRIBUTES2
27 SQL_EXPRESSIONS_IN_ORDERBY "Y"
8 SQL_FETCH_DIRECTION 0x000000BF 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
84 SQL_FILE_USAGE 0
SQL_FILE_NOT_SUPPORTED
146 SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES1 0x0000E001 SQL_CA1_NEXT |
SQL_CA1_POSITIONED_UPDATE | SQL_CA1_POSITIONED_DELETE | SQL_CA1_SELECT_FOR_UPDATE
147 SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES2 0x00000887
SQL_CA2_READ_ONLY_CONCURRENCY | SQL_CA2_LOCK_CONCURRENCY |
SQL_CA2_OPT_ROWVER_CONCURRENCY | SQL_CA2_MAX_ROWS_SELECT | SQL_CA2_MAX_ROWS_CATALOG
81 SQL_GETDATA_EXTENSIONS 0x00000004 SQL_GD_BLOCK
88 SQL_GROUP_BY 2
SQL_GB_GROUP_BY_CONTAINS_SELECT
28 SQL_IDENTIFIER_CASE 1 SQL_IC_UPPER
29 SQL_IDENTIFIER_QUOTE_CHAR """
148 SQL_INDEX_KEYWORDS 0x00000001 SQL_IK_ASC
149 SQL_INFO_SCHEMA_VIEWS 0x00010020
SQL_ISV_COLUMN_PRIVILEGES | SQL_ISV_TABLE_PRIVILEGES
73 SQL_INTEGRITY "N"
150 SQL_KEYSET_CURSOR_ATTRIBUTES1 0x0000FE4F 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
151 SQL_KEYSET_CURSOR_ATTRIBUTES2 0x00000887
SQL_CA2_READ_ONLY_CONCURRENCY | SQL_CA2_LOCK_CONCURRENCY |
SQL_CA2_OPT_ROWVER_CONCURRENCY | SQL_CA2_MAX_ROWS_SELECT | SQL_CA2_MAX_ROWS_CATALOG
89 SQL_KEYWORDS
"ACCESS,AUDIT,BLOB,BFILE,CLOB,CLUSTER,COMMENT,COMPRESS,EXCLUSIVE,FILE,IDENTIFIED,INCREMENT,INITIAL,LOCK,LONG,MAXEXTENTS,MINUS,MODE,MODIFY,NOAUDIT,NOCOMPRESS,NOWAIT,NUMBER,OFFLINE,ONLINE,PCTFREE,RAW,RENAME,RESOURCE,ROW,ROWID,ROWLABEL,ROWNUM,SHARE,START,SUCCESSFUL,SYNONYM,SYSDATE,TRIGGER,UID,VALIDATE,"
113 SQL_LIKE_ESCAPE_CLAUSE "Y"
78 SQL_LOCK_TYPES 0x00000001 SQL_LCK_NO_CHANGE
10022 SQL_MAX_ASYNC_CONCURRENT_STATEMENTS 0
112 SQL_MAX_BINARY_LITERAL_LEN 0
34 SQL_MAX_CATALOG_NAME_LEN 0
108 SQL_MAX_CHAR_LITERAL_LEN 0
97 SQL_MAX_COLUMNS_IN_GROUP_BY 0
98 SQL_MAX_COLUMNS_IN_INDEX 0
99 SQL_MAX_COLUMNS_IN_ORDER_BY 0
100 SQL_MAX_COLUMNS_IN_SELECT 1000
101 SQL_MAX_COLUMNS_IN_TABLE 1000
30 SQL_MAX_COLUMN_NAME_LEN 30
1 SQL_MAX_CONCURRENT_ACTIVITIES 0
31 SQL_MAX_CURSOR_NAME_LEN 30
0 SQL_MAX_DRIVER_CONNECTIONS 0
10005 SQL_MAX_IDENTIFIER_LEN 30
102 SQL_MAX_INDEX_SIZE 123
32 SQL_MAX_OWNER_NAME_LEN 30
33 SQL_MAX_PROCEDURE_NAME_LEN 92
34 SQL_MAX_QUALIFIER_NAME_LEN 0
104 SQL_MAX_ROW_SIZE 0
103 SQL_MAX_ROW_SIZE_INCLUDES_LONG "N"
32 SQL_MAX_SCHEMA_NAME_LEN 30
105 SQL_MAX_STATEMENT_LEN 0
106 SQL_MAX_TABLES_IN_SELECT 0
35 SQL_MAX_TABLE_NAME_LEN 30
107 SQL_MAX_USER_NAME_LEN 30
37 SQL_MULTIPLE_ACTIVE_TXN "Y"
36 SQL_MULT_RESULT_SETS "N"
111 SQL_NEED_LONG_DATA_LEN "N"
75 SQL_NON_NULLABLE_COLUMNS 1 SQL_NNC_NON_NULL
85 SQL_NULL_COLLATION 1 SQL_NC_LOW
49 SQL_NUMERIC_FUNCTIONS 0x0099FF61 SQL_FN_NUM_ABS |
SQL_FN_NUM_CEILING | SQL_FN_NUM_COS | SQL_FN_NUM_EXP | SQL_FN_NUM_FLOOR |
SQL_FN_NUM_LOG | SQL_FN_NUM_MOD | SQL_FN_NUM_SIGN | SQL_FN_NUM_SIN | SQL_FN_NUM_SQRT |
SQL_FN_NUM_TAN | SQL_FN_NUM_PI | SQL_FN_NUM_LOG10 | SQL_FN_NUM_POWER |
SQL_FN_NUM_TRUNCATE
9 SQL_ODBC_API_CONFORMANCE 1 SQL_OAC_LEVEL1
152 SQL_ODBC_INTERFACE_CONFORMANCE 1 SQL_OIC_CORE
12 SQL_ODBC_SAG_CLI_CONFORMANCE 1 SQL_OSCC_COMPLIANT
15 SQL_ODBC_SQL_CONFORMANCE 1 SQL_OSC_CORE
73 SQL_ODBC_SQL_OPT_IEF "N"
10 SQL_ODBC_VER "03.52.0000"
115 SQL_OJ_CAPABILITIES 0x0000007B SQL_OJ_LEFT |
SQL_OJ_RIGHT | SQL_OJ_NESTED | SQL_OJ_NOT_ORDERED | SQL_OJ_INNER |
SQL_OJ_ALL_COMPARISON_OPS
90 SQL_ORDER_BY_COLUMNS_IN_SELECT "N"
38 SQL_OUTER_JOINS "Y"
39 SQL_OWNER_TERM "Owner"
91 SQL_OWNER_USAGE 0x0000001F
SQL_OU_DML_STATEMENTS | SQL_OU_PROCEDURE_INVOCATION | SQL_OU_TABLE_DEFINITION |
SQL_OU_INDEX_DEFINITION | SQL_OU_PRIVILEGE_DEFINITION
153 SQL_PARAM_ARRAY_ROW_COUNTS 2 SQL_PARC_NO_BATCH
154 SQL_PARAM_ARRAY_SELECTS 3 SQL_PAS_NO_SELECT
80 SQL_POSITIONED_STATEMENTS 0x00000007
SQL_PS_POSITIONED_DELETE | SQL_PS_POSITIONED_UPDATE | SQL_PS_SELECT_FOR_UPDATE
79 SQL_POS_OPERATIONS 0x0000001F SQL_POS_POSITION
| SQL_POS_REFRESH | SQL_POS_UPDATE | SQL_POS_DELETE | SQL_POS_ADD
21 SQL_PROCEDURES "Y"
40 SQL_PROCEDURE_TERM "Procedure"
114 SQL_QUALIFIER_LOCATION 2 SQL_CL_END
41 SQL_QUALIFIER_NAME_SEPARATOR "@"
42 SQL_QUALIFIER_TERM "Database Link"
92 SQL_QUALIFIER_USAGE 0x00000003
SQL_CU_DML_STATEMENTS | SQL_CU_PROCEDURE_INVOCATION
93 SQL_QUOTED_IDENTIFIER_CASE 3 SQL_IC_SENSITIVE
11 SQL_ROW_UPDATES "Y"
39 SQL_SCHEMA_TERM "Owner"
91 SQL_SCHEMA_USAGE 0x0000001F
SQL_OU_DML_STATEMENTS | SQL_OU_PROCEDURE_INVOCATION | SQL_OU_TABLE_DEFINITION |
SQL_OU_INDEX_DEFINITION | SQL_OU_PRIVILEGE_DEFINITION
43 SQL_SCROLL_CONCURRENCY 0x00000007
SQL_SCCO_READ_ONLY | SQL_SCCO_LOCK | SQL_SCCO_OPT_ROWVER
44 SQL_SCROLL_OPTIONS 0x00000013
SQL_SO_FORWARD_ONLY | SQL_SO_KEYSET_DRIVEN | SQL_SO_STATIC
14 SQL_SEARCH_PATTERN_ESCAPE "\"
13 SQL_SERVER_NAME "ORA3"
94 SQL_SPECIAL_CHARACTERS "$#"
155 SQL_SQL92_DATETIME_FUNCTIONS 0x00000000
156 SQL_SQL92_FOREIGN_KEY_DELETE_RULE 0x00000000
157 SQL_SQL92_FOREIGN_KEY_UPDATE_RULE 0x00000000
158 SQL_SQL92_GRANT 0x00000010
SQL_SG_WITH_GRANT_OPTION
159 SQL_SQL92_NUMERIC_VALUE_FUNCTIONS 0x00000000
160 SQL_SQL92_PREDICATES 0x00001E07 SQL_SP_EXISTS |
SQL_SP_ISNOTNULL | SQL_SP_ISNULL | SQL_SP_LIKE | SQL_SP_IN | SQL_SP_BETWEEN |
SQL_SP_COMPARISON
161 SQL_SQL92_RELATIONAL_JOIN_OPERATORS 0x00000000
162 SQL_SQL92_REVOKE 0x00000000
163 SQL_SQL92_ROW_VALUE_CONSTRUCTOR 0x00000000
164 SQL_SQL92_STRING_FUNCTIONS 0x00000000
165 SQL_SQL92_VALUE_EXPRESSIONS 0x00000001 SQL_SVE_CASE
118 SQL_SQL_CONFORMANCE 1 SQL_SC_SQL92_ENTRY
166 SQL_STANDARD_CLI_CONFORMANCE 0x00000003
SQL_SCC_XOPEN_CLI_VERSION1 | SQL_SCC_ISO92_CLI
167 SQL_STATIC_CURSOR_ATTRIBUTES1 0x0000FE4F 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
168 SQL_STATIC_CURSOR_ATTRIBUTES2 0x00001087
SQL_CA2_READ_ONLY_CONCURRENCY | SQL_CA2_LOCK_CONCURRENCY |
SQL_CA2_OPT_ROWVER_CONCURRENCY | SQL_CA2_MAX_ROWS_SELECT | SQL_CA2_CRC_EXACT
83 SQL_STATIC_SENSITIVITY 0x00000000
50 SQL_STRING_FUNCTIONS 0x00077FFF 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_LOCATE_2 | SQL_FN_STR_SOUNDEX |
SQL_FN_STR_SPACE
95 SQL_SUBQUERIES 0x0000001F SQL_SQ_COMPARISON
| SQL_SQ_EXISTS | SQL_SQ_IN | SQL_SQ_QUANTIFIED | SQL_SQ_CORRELATED_SUBQUERIES
51 SQL_SYSTEM_FUNCTIONS 0x00000005
SQL_FN_SYS_USERNAME | SQL_FN_SYS_IFNULL
45 SQL_TABLE_TERM "Table"
109 SQL_TIMEDATE_ADD_INTERVALS 0x00000000
110 SQL_TIMEDATE_DIFF_INTERVALS 0x00000000
52 SQL_TIMEDATE_FUNCTIONS 0x00001FFF SQL_FN_TD_NOW |
SQL_FN_TD_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_TD_CURTIME | SQL_FN_TD_HOUR | SQL_FN_TD_MINUTE | SQL_FN_TD_SECOND
46 SQL_TXN_CAPABLE 3 SQL_TC_DDL_COMMIT
72 SQL_TXN_ISOLATION_OPTION 0x0000000A
SQL_TXN_READ_COMMITTED | SQL_TXN_SERIALIZABLE
96 SQL_UNION 0x00000003 SQL_U_UNION |
SQL_U_UNION_ALL
47 SQL_USER_NAME "TST"
10000 SQL_XOPEN_CLI_YEAR "1995"
