Statement Options - Option 2

The following options are available for use with Option 2 of lrd_stmt:

Definition
Corresponding DB command
Code
Oracle
   
LRD_STMT_ORACLE_OPT2_V6
 
0
LRD_STMT_ORACLE_OPT2_DEFAULT_V
 
1
LRD_STMT_ORACLE_OPT2_V7
 
2
LRD_STMT_ORACLE_OPT2_UNUSED
 
-1
CtLib
   
LRD_STMT_CTLIB_OPT2_RECOMPILE
 
188
LRD_STMT_CTLIB_OPT2_NO_RECOMP
 
189
LRD_STMT_CTLIB_OPT2_BULK_INIT
 
190
LRD_STMT_CTLIB_OPT2_BULK_CONT
 
191
LRD_STMT_CTLIB_OPT2_BULK_DATA
 
192
LRD_STMT_CTLIB_OPT2_COLUMN_DATA
 
193
LRD_STMT_CTLIB_OPT2_UNUSED
 
-99999
DbLib
   
LRD_STMT_DBLIB_OPT2_NONE
 
0
LRD_STMT_DBLIB_OPT2_RPCRECOMPRESET
 
1
LRD_STMT_DBLIB_OPT2_RPCRECOMPILE
 
2
LRD_STMT_DBLIB_OPT2_RPCRESET
 
3
LRD_STMT_DBLIB_OPT2_WRITE
 
4
LRD_STMT_DBLIB_OPT2_UPDATE
 
5
ODBC
   
LRD_STMT_ODBC_OPT2_NONE
Default
0
LRD_STMT_ODBC_OPT2_COL_PRIV
Call SQLColumnPrivileges
1
LRD_STMT_ODBC_OPT2_COLUMNS
Call SQLColumns
2
LRD_STMT_ODBC_OPT2_FRGN_KEYS
Call SQLForeignKeys
3
LRD_STMT_ODBC_OPT2_TYPE_INFO
Call SQLGetTypeInfo
4
LRD_STMT_ODBC_OPT2_PRIM_KEYS
Call SQLPrimaryKeys
5
LRD_STMT_ODBC_OPT2_PROC_COLS
Call SQLProcedureColumns
6
LRD_STMT_ODBC_OPT2_PROCS
Call SQLProcedures
7
LRD_STMT_ODBC_OPT2_SPEC_COLS
Call SQLSpecialColumns
8
LRD_STMT_ODBC_OPT2_STATS
Call SQLStatistics
9
LRD_STMT_ODBC_OPT2_TBL_PRIV
Call SQLTablePriveleges
10
LRD_STMT_ODBC_OPT2_TABLES
Call SQLTables
11