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 RaimaDB specific transaction (start, mark, etc.) More... |
|
RDBC_EXPORT SQLRETURN | SQLGetStatementType (SQLHSTMT StatementHandle, SQLUSMALLINT *pStmtType) |
Obtain the RaimaDB 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 */ |
RaimaDB 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 (SQL_DRIVER_STMT_ATTR_BASE + 501) /* logical line number */ |
RaimaDB specific statement attributes.
SQL_ATTR_RDM_FILE_NAME
#define SQL_ATTR_RDM_FILE_NAME (SQL_DRIVER_STMT_ATTR_BASE + 502) /* logical file name */ |
SQL_ATTR_RDM_FORCE_SSL
#define SQL_ATTR_RDM_FORCE_SSL (SQL_DRIVER_CONN_ATTR_BASE + 110) |
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_USE_SSL
#define SQL_ATTR_RDM_USE_SSL (SQL_DRIVER_CONN_ATTR_BASE + 111) |
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 |
RaimaDB specfic diagnostic area codes.
NOTE: ODBC-defined area codes are currently from 1 to 12 (sql.h)
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 RaimaDB 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) |
RaimaDB 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 */ |