Header for the Raima SQL API Extensions. More...
Include dependency graph for sqlrext.h:
                                                    
                                                        
                                                            Functions | 
                                                    |
| RDBC_EXPORT SQLRETURN | SQLDescribeStmt (SQLHSTMT StatementHandle, SQLUSMALLINT *pStmtType) | 
| Obtain the type of the latest executed statement. More... | 
                                                    |
| RDBC_EXPORT SQLRETURN | SQLExtendedTran (SQLSMALLINT HandleType, SQLHANDLE Handle, SQLSMALLINT OperationType, SQLSMALLINT TransactionType, const SQLCHAR *TransactionID, SQLSMALLINT StringLengthPtr) | 
| Perform an RDM specific transaction (start, mark, etc.) More... | 
                                                    |
| RDBC_EXPORT SQLRETURN | SQLGetStatementType (SQLHSTMT StatementHandle, SQLUSMALLINT *pStmtType) | 
| Obtain the RDM SQL statement type. More... | 
                                                    |
| RDBC_EXPORT SQLRETURN | SQLRowId (SQLHSTMT StatementHandle, const SQLCHAR *TableName, SQLROWID *pRowid) | 
| Retrieve the ROWID value of the current row. More... | 
                                                    |
| RDBC_EXPORT SQLRETURN | SQLSetError (SQLSMALLINT HandleType, SQLHANDLE Handle, SQLRETURN ErrorCode, ECALLBACK ErrorHandler) | 
| Set the user-defined error handling routine for the specified handle. More... | 
                                                    |
| RDBC_EXPORT SQLRETURN | SQLSetErrorEx (SQLSMALLINT HandleType, SQLHANDLE Handle, SQLRETURN ErrorCode, ECALLBACK ErrorHandler, void *pCtx) | 
| Set the user-defined error handling routine for the specified handle. More... | 
                                                    |
| RDBC_EXPORT SQLRETURN | SQLShowPlan (SQLHSTMT StatementHandle, SQLHSTMT QueryHandle) | 
| Return the command execution plan chosen by the query optimizer. More... | 
                                                    |
| RDBC_EXPORT SQLRETURN | SQLTransactStatus (SQLSMALLINT HandleType, SQLHANDLE Handle, SQLSMALLINT *pActive) | 
| Return the status of an ongoing transaction. More... | 
                                                    |
Detailed Description
Header for the Raima SQL API Extensions.
Macro Definition Documentation
RDM_DRIVER_VER
| #define RDM_DRIVER_VER RDM_ODBC_DRIVER_VERSION | 
RDM_INFO_LAST
| #define RDM_INFO_LAST SQL_CONVERT_GUID /* sqlext.h */ | 
RDM_MAX_STATEMENT_LEN
| #define RDM_MAX_STATEMENT_LEN 4096 /* defSqlMaxstmtlen */ | 
RDM_MAX_USER_NAME_LEN
| #define RDM_MAX_USER_NAME_LEN 32 | 
RDM_SOURCE_VER
| #define RDM_SOURCE_VER RDM_ODBC_DRIVER_VERSION | 
RDM_XOPEN_INFO_FIRST
| #define RDM_XOPEN_INFO_FIRST SQL_XOPEN_CLI_YEAR | 
RDM_XOPEN_INFO_LAST
| #define RDM_XOPEN_INFO_LAST SQL_MAX_ASYNC_CONCURRENT_STATEMENTS | 
SQL_ATTR_RDM_CAT_BUFFER
| #define SQL_ATTR_RDM_CAT_BUFFER (SQL_DRIVER_CONN_ATTR_BASE) /* SetCatalog */ | 
RDM specific connection attributes.
- Examples
 - odbc01Example_main.c.
 
SQL_ATTR_RDM_CAT_FILE
| #define SQL_ATTR_RDM_CAT_FILE (SQL_DRIVER_CONN_ATTR_BASE + 1) | 
SQL_ATTR_RDM_COLLATION
| #define SQL_ATTR_RDM_COLLATION (SQL_DRIVER_CONN_ATTR_BASE + 6) | 
SQL_ATTR_RDM_DB_SIZE_MAX
| #define SQL_ATTR_RDM_DB_SIZE_MAX (SQL_DRIVER_CONN_ATTR_BASE + 103) | 
SQL_ATTR_RDM_DURABILITY
| #define SQL_ATTR_RDM_DURABILITY (SQL_DRIVER_CONN_ATTR_BASE + 109) | 
SQL_ATTR_RDM_ENCRYPT
| #define SQL_ATTR_RDM_ENCRYPT (SQL_DRIVER_CONN_ATTR_BASE + 2) | 
SQL_ATTR_RDM_FILE_LINE
| #define SQL_ATTR_RDM_FILE_LINE 501 /* logical line number */ | 
RDM specific statement attributes.
SQL_ATTR_RDM_FILE_NAME
| #define SQL_ATTR_RDM_FILE_NAME 502 /* logical file name */ | 
SQL_ATTR_RDM_OPTIMIZE_PARAMETERS
| #define SQL_ATTR_RDM_OPTIMIZE_PARAMETERS (SQL_DRIVER_CONN_ATTR_BASE + 7) | 
SQL_ATTR_RDM_PACK_FILE_SIZE_MAX
| #define SQL_ATTR_RDM_PACK_FILE_SIZE_MAX (SQL_DRIVER_CONN_ATTR_BASE + 102) | 
SQL_ATTR_RDM_PACK_WRITE_CHUNK_SIZE
| #define SQL_ATTR_RDM_PACK_WRITE_CHUNK_SIZE (SQL_DRIVER_CONN_ATTR_BASE + 101) | 
Pack-related options.
SQL_ATTR_RDM_REMOTE_NAME
| #define SQL_ATTR_RDM_REMOTE_NAME (SQL_DRIVER_CONN_ATTR_BASE + 3) | 
SQL_ATTR_RDM_ROUNDING_MODE
| #define SQL_ATTR_RDM_ROUNDING_MODE (SQL_DRIVER_CONN_ATTR_BASE + 8) | 
SQL_ATTR_RDM_SQL_OPTIONS
| #define SQL_ATTR_RDM_SQL_OPTIONS (SQL_DRIVER_CONN_ATTR_BASE + 4) | 
SQL_ATTR_RDM_STORAGE_MEDIA
| #define SQL_ATTR_RDM_STORAGE_MEDIA (SQL_DRIVER_CONN_ATTR_BASE + 9) | 
SQL_ATTR_RDM_TFS_HANDLE
| #define SQL_ATTR_RDM_TFS_HANDLE (SQL_DRIVER_CONN_ATTR_BASE + 10) | 
- Examples
 - odbc01Example_main.c, tfsrdbc/rdbcTfsAlloc.c, and tfsrdbc/rdbcTfsAllocDefault.c.
 
SQL_ATTR_RDM_TFS_NAME
| #define SQL_ATTR_RDM_TFS_NAME (SQL_DRIVER_CONN_ATTR_BASE + 11) | 
SQL_ATTR_RDM_USE_CATALOG
| #define SQL_ATTR_RDM_USE_CATALOG (SQL_DRIVER_CONN_ATTR_BASE + 5) | 
SQL_ATTR_RDM_VACUUM_CHUNK_SIZE
| #define SQL_ATTR_RDM_VACUUM_CHUNK_SIZE (SQL_DRIVER_CONN_ATTR_BASE + 105) | 
SQL_ATTR_RDM_VACUUM_PERCENTAGE
| #define SQL_ATTR_RDM_VACUUM_PERCENTAGE (SQL_DRIVER_CONN_ATTR_BASE + 104) | 
SQL_CT_LOCAL
SQL_CT_REMOTE
SQL_CT_UNKNOWN
| #define SQL_CT_UNKNOWN ((SQLULEN) CT_UNKNOWN) | 
SQL_DIAG_RDM_ASSIGN
| #define SQL_DIAG_RDM_ASSIGN 126 | 
SQL_DIAG_RDM_CLOSE_DB
| #define SQL_DIAG_RDM_CLOSE_DB 103 | 
SQL_DIAG_RDM_COMMIT
| #define SQL_DIAG_RDM_COMMIT 106 | 
SQL_DIAG_RDM_CREATE_CATALOG
| #define SQL_DIAG_RDM_CREATE_CATALOG 118 | 
SQL_DIAG_RDM_CREATE_ENCKEY
| #define SQL_DIAG_RDM_CREATE_ENCKEY 122 | 
SQL_DIAG_RDM_CREATE_PROCEDURE
| #define SQL_DIAG_RDM_CREATE_PROCEDURE 111 | 
SQL_DIAG_RDM_CREATE_TRIGGER
| #define SQL_DIAG_RDM_CREATE_TRIGGER 128 | 
SQL_DIAG_RDM_DECLARE_VAR
| #define SQL_DIAG_RDM_DECLARE_VAR 125 | 
SQL_DIAG_RDM_DROP_ENCKEY
| #define SQL_DIAG_RDM_DROP_ENCKEY 123 | 
SQL_DIAG_RDM_DROP_PROCEDURE
| #define SQL_DIAG_RDM_DROP_PROCEDURE 112 | 
SQL_DIAG_RDM_DROP_TRIGGER
| #define SQL_DIAG_RDM_DROP_TRIGGER 129 | 
SQL_DIAG_RDM_EXPORT_TABLE
| #define SQL_DIAG_RDM_EXPORT_TABLE 120 | 
SQL_DIAG_RDM_FILE_COLUMN
| #define SQL_DIAG_RDM_FILE_COLUMN 1003 | 
SQL_DIAG_RDM_FILE_LINE
| #define SQL_DIAG_RDM_FILE_LINE 1002 | 
SQL_DIAG_RDM_FILE_NAME
| #define SQL_DIAG_RDM_FILE_NAME 1001 | 
SQL_DIAG_RDM_GOTO
| #define SQL_DIAG_RDM_GOTO 127 | 
SQL_DIAG_RDM_IMPORT_TABLE
| #define SQL_DIAG_RDM_IMPORT_TABLE 119 | 
SQL_DIAG_RDM_INITIALIZE_SCHEMA
| #define SQL_DIAG_RDM_INITIALIZE_SCHEMA 117 | 
SQL_DIAG_RDM_LOCK
| #define SQL_DIAG_RDM_LOCK 115 | 
SQL_DIAG_RDM_OPEN_DB
| #define SQL_DIAG_RDM_OPEN_DB 101 | 
SQL_DIAG_RDM_OPEN_DBUNION
| #define SQL_DIAG_RDM_OPEN_DBUNION 102 | 
SQL_DIAG_RDM_PERSIST
| #define SQL_DIAG_RDM_PERSIST 130 | 
SQL_DIAG_RDM_PRECOMMIT
| #define SQL_DIAG_RDM_PRECOMMIT 110 | 
SQL_DIAG_RDM_RELEASE
| #define SQL_DIAG_RDM_RELEASE 108 | 
SQL_DIAG_RDM_ROLLBACK
| #define SQL_DIAG_RDM_ROLLBACK 109 | 
SQL_DIAG_RDM_SAVEPOINT
| #define SQL_DIAG_RDM_SAVEPOINT 107 | 
SQL_DIAG_RDM_SELECT
| #define SQL_DIAG_RDM_SELECT 104 | 
SQL_DIAG_RDM_SET
| #define SQL_DIAG_RDM_SET 113 | 
SQL_DIAG_RDM_SET_COLUMN
| #define SQL_DIAG_RDM_SET_COLUMN 114 | 
SQL_DIAG_RDM_SET_DB_ENC
| #define SQL_DIAG_RDM_SET_DB_ENC 124 | 
SQL_DIAG_RDM_START
| #define SQL_DIAG_RDM_START 105 | 
SQL_DIAG_RDM_UNLOCK
| #define SQL_DIAG_RDM_UNLOCK 116 | 
SQL_DIAG_RDM_UPDATE_STATS
| #define SQL_DIAG_RDM_UPDATE_STATS 121 | 
SQL_INIT
| #define SQL_INIT 5 | 
SQL_MODE_EXCLUSIVE
| #define SQL_MODE_EXCLUSIVE 2 | 
SQL_MODE_EXCLUSIVE_APPEND
| #define SQL_MODE_EXCLUSIVE_APPEND 4 | 
SQL_MODE_EXCLUSIVE_CREAT
| #define SQL_MODE_EXCLUSIVE_CREAT 6 | 
SQL_MODE_EXCLUSIVE_CREAT_EXCL
| #define SQL_MODE_EXCLUSIVE_CREAT_EXCL 10 | 
SQL_MODE_EXCLUSIVE_CREAT_TRUNC
| #define SQL_MODE_EXCLUSIVE_CREAT_TRUNC 8 | 
SQL_MODE_READ_WRITE_APPEND
| #define SQL_MODE_READ_WRITE_APPEND 3 | 
SQL_MODE_READ_WRITE_CREAT
| #define SQL_MODE_READ_WRITE_CREAT 5 | 
SQL_MODE_READ_WRITE_CREAT_EXCL
| #define SQL_MODE_READ_WRITE_CREAT_EXCL 9 | 
SQL_MODE_READ_WRITE_CREAT_TRUNC
| #define SQL_MODE_READ_WRITE_CREAT_TRUNC 7 | 
SQL_PRECOMMIT
| #define SQL_PRECOMMIT 5 | 
SQL_RDM_DEFAULT_PORT
| #define SQL_RDM_DEFAULT_PORT TFS_DEFAULT_PORT | 
SQL_RDM_DEFAULT_STDOUT
| #define SQL_RDM_DEFAULT_STDOUT "" | 
SQL_RDM_STMT_CLOSE
| #define SQL_RDM_STMT_CLOSE SQL_DIAG_RDM_CLOSE_DB | 
SQL_RDM_STMT_COMMIT
| #define SQL_RDM_STMT_COMMIT SQL_DIAG_RDM_COMMIT | 
SQL_RDM_STMT_CRCAT
| #define SQL_RDM_STMT_CRCAT SQL_DIAG_RDM_CREATE_CATALOG | 
SQL_RDM_STMT_CRPROC
| #define SQL_RDM_STMT_CRPROC SQL_DIAG_RDM_CREATE_PROCEDURE | 
SQL_RDM_STMT_DBUNION
| #define SQL_RDM_STMT_DBUNION SQL_DIAG_RDM_OPEN_DBUNION | 
SQL_RDM_STMT_DDL
| #define SQL_RDM_STMT_DDL SQL_DIAG_CREATE_SCHEMA | 
SQL_RDM_STMT_DELETE
| #define SQL_RDM_STMT_DELETE SQL_DIAG_DELETE_WHERE | 
SQL_RDM_STMT_DRPROC
| #define SQL_RDM_STMT_DRPROC SQL_DIAG_RDM_DROP_PROCEDURE | 
SQL_RDM_STMT_EXECUTE
| #define SQL_RDM_STMT_EXECUTE SQL_DIAG_RDM_EXECUTE_PROCEDURE | 
SQL_RDM_STMT_EXPORT
| #define SQL_RDM_STMT_EXPORT SQL_DIAG_RDM_EXPORT_TABLE | 
SQL_RDM_STMT_IMPORT
| #define SQL_RDM_STMT_IMPORT SQL_DIAG_RDM_IMPORT_TABLE | 
SQL_RDM_STMT_INITDB
| #define SQL_RDM_STMT_INITDB SQL_DIAG_RDM_INITIALIZE_SCHEMA | 
SQL_RDM_STMT_INSERT
| #define SQL_RDM_STMT_INSERT SQL_DIAG_INSERT | 
SQL_RDM_STMT_LOCK
| #define SQL_RDM_STMT_LOCK SQL_DIAG_RDM_LOCK | 
SQL_RDM_STMT_OPEN
| #define SQL_RDM_STMT_OPEN SQL_DIAG_RDM_OPEN_DB | 
SQL_RDM_STMT_PERSIST
| #define SQL_RDM_STMT_PERSIST SQL_DIAG_RDM_PERSIST | 
SQL_RDM_STMT_RELEASE
| #define SQL_RDM_STMT_RELEASE SQL_DIAG_RDM_RELEASE | 
SQL_RDM_STMT_ROLLBACK
| #define SQL_RDM_STMT_ROLLBACK SQL_DIAG_RDM_ROLLBACK | 
SQL_RDM_STMT_SAVEPOINT
| #define SQL_RDM_STMT_SAVEPOINT SQL_DIAG_RDM_SAVEPOINT | 
SQL_RDM_STMT_SELECT
| #define SQL_RDM_STMT_SELECT SQL_DIAG_RDM_SELECT | 
SQL_RDM_STMT_SET
| #define SQL_RDM_STMT_SET SQL_DIAG_RDM_SET | 
SQL_RDM_STMT_SETCOLUMN
| #define SQL_RDM_STMT_SETCOLUMN SQL_DIAG_RDM_SET_COLUMN | 
SQL_RDM_STMT_START
| #define SQL_RDM_STMT_START SQL_DIAG_RDM_START | 
SQL_RDM_STMT_UNKNOWN
| #define SQL_RDM_STMT_UNKNOWN SQL_DIAG_UNKNOWN_STATEMENT | 
SQL_RDM_STMT_UNLOCK
| #define SQL_RDM_STMT_UNLOCK SQL_DIAG_RDM_UNLOCK | 
SQL_RDM_STMT_UPDATE
| #define SQL_RDM_STMT_UPDATE SQL_DIAG_UPDATE_WHERE | 
SQL_RDM_UNSET
| #define SQL_RDM_UNSET ((SQLULEN) -1) | 
This indicates that a given numeric RDM connection attribute is not set.
SQL_RELEASE
| #define SQL_RELEASE 4 | 
SQL_ROUND_DOWN
| #define SQL_ROUND_DOWN ((SQLULEN) RDM_BCD_ROUND_DOWN) | 
SQL_ROUND_NEAREST_TIES_AWAY_FROM_ZERO
| #define SQL_ROUND_NEAREST_TIES_AWAY_FROM_ZERO ((SQLULEN) RDM_BCD_ROUND_NEAREST_TIES_AWAY_FROM_ZERO) | 
SQL_ROUND_NEAREST_TIES_TO_EVEN
| #define SQL_ROUND_NEAREST_TIES_TO_EVEN ((SQLULEN) RDM_BCD_ROUND_NEAREST_TIES_TO_EVEN) | 
RDM specific SQL_ATTR_RDM_ROUNDING_MODE atrtibute values.
SQL_ROUND_TOWARDS_ZERO
| #define SQL_ROUND_TOWARDS_ZERO ((SQLULEN) RDM_BCD_ROUND_TOWARDS_ZERO) | 
SQL_ROUND_UP
| #define SQL_ROUND_UP ((SQLULEN) RDM_BCD_ROUND_UP) | 
SQL_SAVEPOINT
| #define SQL_SAVEPOINT 3 | 
SQL_START
| #define SQL_START 2 | 
SQL_TFSTYPE_DEFAULT
| #define SQL_TFSTYPE_DEFAULT ((SQLUINTEGER) TFS_TYPE_DEFAULT) | 
SQL_TFSTYPE_EMBED
| #define SQL_TFSTYPE_EMBED ((SQLUINTEGER) TFS_TYPE_EMBED) | 
SQL_TFSTYPE_HYBRID
| #define SQL_TFSTYPE_HYBRID ((SQLUINTEGER) TFS_TYPE_HYBRID) | 
SQL_TFSTYPE_REMOTE
| #define SQL_TFSTYPE_REMOTE ((SQLUINTEGER) TFS_TYPE_CLIENT) | 
SQL_TXN_DDL
| #define SQL_TXN_DDL 4 | 
SQL_TXN_INACTIVE
| #define SQL_TXN_INACTIVE 0 | 
SQL_TXN_READ
| #define SQL_TXN_READ 2 | 
SQL_TXN_SNAPSHOT
| #define SQL_TXN_SNAPSHOT 3 | 
SQL_TXN_UPDATE
| #define SQL_TXN_UPDATE 1 | 
TFSTYPE_MAXSIZE
| #define TFSTYPE_MAXSIZE 8 /* "default" + 1 */ |