SQL defines the C-level interface to the ODBC system. The contents of this interface were derived from the Microsoft version of
sql.h
dated 4/10/95 and the sql.h interfaces for Linux provided by Positron.
See DB.i3 for a safe Modula-3 interface to the same functionality.
UNSAFE INTERFACECore Function PrototypesSQL ; FROM SQLtypes IMPORT SQLRETURN, SQLHENV, SQLHENV_star, SQLHDBC, SQLHDBC_star, SQLHSTMT, SQLHSTMT_star, SQLUSMALLINT, SQLUSMALLINT_star, SQLSMALLINT, SQLSMALLINT_star, SQLPOINTER, SQLPOINTER_star, SQLINTEGER, SQLINTEGER_star, SQLUINTEGER, SQLUINTEGER_star, SQLCHAR_star; CONST ODBCVER = 16_0250; (* ODBC version number *) SQL_SPEC_MAJOR = 2; (* Major version of specification *) SQL_SPEC_MINOR = 50; (* Minor version of specification *) SQL_SPEC_STRING = "02.50"; (* String constant for version *) SQL_SQLSTATE_SIZE = 5; (* size of SQL state *) SQL_MAX_MESSAGE_LENGTH = 512; (* message buffer size *) SQL_MAX_DSN_LENGTH = 32 ; (* maximum data source name size *) (* RETCODEs *) SQL_INVALID_HANDLE = -2; SQL_ERROR = -1; SQL_SUCCESS = 0; SQL_SUCCESS_WITH_INFO = 1; SQL_NO_DATA_FOUND = 100; (* Standard SQL datatypes, using ANSI numbering *) SQL_CHAR = 1; SQL_NUMERIC = 2; SQL_DECIMAL = 3; SQL_INTEGER = 4; SQL_SMALLINT = 5; SQL_FLOAT = 6; SQL_REAL = 7; SQL_DOUBLE = 8; SQL_VARCHAR = 12; SQL_TYPE_NULL = 0; SQL_TYPE_MIN = SQL_BIT; SQL_TYPE_MAX = SQL_VARCHAR; SQL_ALL_TYPES = 0; (* C datatype to SQL datatype mapping *) (* SQL types *) SQL_C_CHAR = SQL_CHAR; (* CHAR, VARCHAR, DECIMAL, NUMERIC *) SQL_C_LONG = SQL_INTEGER; (* INTEGER *) SQL_C_SHORT = SQL_SMALLINT; (* SMALLINT *) SQL_C_FLOAT = SQL_REAL; (* REAL *) SQL_C_DOUBLE = SQL_DOUBLE; (* FLOAT, DOUBLE *) SQL_C_DEFAULT = 99; (* NULL status constants. These are used in SQLColumns, SQLColAttributes, SQLDescribeCol, SQLDescribeParam, and SQLSpecialColumns to describe the nullability of a column in a table. *) SQL_NO_NULLS = 0; SQL_NULLABLE = 1; SQL_NULLABLE_UNKNOWN = 2; (* Special length values *) SQL_NULL_DATA = -1; SQL_DATA_AT_EXEC = -2; SQL_NTS = -3; (* SQLFreeStmt defines *) SQL_CLOSE = 0; SQL_DROP = 1; SQL_UNBIND = 2; SQL_RESET_PARAMS = 3; (* SQLTransact defines *) SQL_COMMIT = 0; SQL_ROLLBACK = 1; (* SQLColAttributes defines *) SQL_COLUMN_COUNT = 0; SQL_COLUMN_NAME = 1; SQL_COLUMN_TYPE = 2; SQL_COLUMN_LENGTH = 3; SQL_COLUMN_PRECISION = 4; SQL_COLUMN_SCALE = 5; SQL_COLUMN_DISPLAY_SIZE = 6; SQL_COLUMN_NULLABLE = 7; SQL_COLUMN_UNSIGNED = 8; SQL_COLUMN_MONEY = 9; SQL_COLUMN_UPDATEABLE = 10; SQL_COLUMN_AUTO_INCREMENT = 11; SQL_COLUMN_CASE_SENSITIVE = 12; SQL_COLUMN_SEARCHABLE = 13; SQL_COLUMN_TYPE_NAME = 14; SQL_COLUMN_TABLE_NAME = 15; SQL_COLUMN_OWNER_NAME = 16; SQL_COLUMN_QUALIFER_NAME = 17; SQL_COLUMN_LABEL = 18; SQL_COLATT_OPT_MAX = SQL_COLUMN_LABEL; SQL_COLUMN_DRIVER_START = 1000; SQL_COLLATT_OPT_MIN = SQL_COLUMN_COUNT; (* SQLCollAttributes subdefines for SQL_COLUMN_UPDATEABLE *) SQL_ATTR_READONLY = 0; SQL_ATTR_WRITE = 1; SQL_ATTR_READWITE_UNKNOWN = 2; (* SQLColAttributes subdefines for SQL_COLUMN_SEARCHABLE *) (* These are also used by SQLGetInfo. *) SQL_UNSEARCHABLE = 0; SQL_LIKE_ONLY = 1; SQL_ALL_EXCEPT_LIKE = 2; SQL_SEARCHABLE = 3; (* SQLError defines *) SQL_NULL_HENV : SQLHENV = NIL; SQL_NULL_HDBC : SQLHDBC = NIL; SQL_NULL_HSTMT : SQLHSTMT = NIL;
<*EXTERNAL SQLAllocConnect *>
PROCEDURE SQLAllocConnect (henv: SQLHENV; phdbc: SQLHDBC_star): SQLRETURN;
<*EXTERNAL SQLAllocEnv *>
PROCEDURE SQLAllocEnv (phenv: SQLHENV_star): SQLRETURN;
<*EXTERNAL SQLAllocStmt *>
PROCEDURE SQLAllocStmt (hdbc: SQLHDBC; phstmt: SQLHSTMT_star): SQLRETURN;
<*EXTERNAL SQLBindCol *>
PROCEDURE SQLBindCol (
hstmt: SQLHSTMT;
icol: SQLUSMALLINT;
fCtype: SQLSMALLINT;
rgbValue: SQLPOINTER;
cbValueMax: SQLINTEGER;
pcbValue: SQLINTEGER_star): SQLRETURN;
<*EXTERNAL SQLCancel *>
PROCEDURE SQLCancel (hstmt: SQLHSTMT): SQLRETURN;
<*EXTERNAL SQLColAttributes *>
PROCEDURE SQLColAttributes (
hstmt: SQLHSTMT;
icol: SQLUSMALLINT;
fDescType: SQLUSMALLINT;
rgbDesc: SQLPOINTER;
cbDescMax: SQLSMALLINT;
pcbDesc: SQLSMALLINT_star;
pfDesc: SQLINTEGER_star): SQLRETURN;
<*EXTERNAL SQLConnect *>
PROCEDURE SQLConnect (
hdbc: SQLHDBC;
szDSN: SQLCHAR_star;
cbDSN: SQLSMALLINT;
szUID: SQLCHAR_star;
cbUID: SQLSMALLINT;
szAuthStr: SQLCHAR_star;
cbAuthStr: SQLSMALLINT): SQLRETURN;
<*EXTERNAL SQLDescribeCol *>
PROCEDURE SQLDescribeCol (
hstmt: SQLHSTMT;
icol: SQLUSMALLINT;
szColName: SQLCHAR_star;
cbColNameMax: SQLSMALLINT;
pcbColName: SQLSMALLINT_star;
pfSqlType: SQLSMALLINT_star;
pcbColDef: SQLUINTEGER_star;
pibScale: SQLSMALLINT_star;
pfNullable: SQLSMALLINT_star): SQLRETURN;
<*EXTERNAL SQLDisconnect *>
PROCEDURE SQLDisconnect (hdbc: SQLHDBC): SQLRETURN;
<*EXTERNAL SQLError *>
PROCEDURE SQLError (
henv: SQLHENV;
hdbc: SQLHDBC;
hstmt: SQLHSTMT;
szSqlState: SQLCHAR_star;
pfNativeError: SQLINTEGER_star;
szErrorMsg: SQLCHAR_star;
cbErrorMsgMax: SQLSMALLINT;
pcbErrorMsg: SQLSMALLINT_star): SQLRETURN;
<*EXTERNAL SQLExecDirect *>
PROCEDURE SQLExecDirect (
hstmt: SQLHSTMT;
szSqlStr: SQLCHAR_star;
cbSqlStr: SQLINTEGER): SQLRETURN;
<*EXTERNAL SQLExecute *>
PROCEDURE SQLExecute (hstmt: SQLHSTMT): SQLRETURN;
<*EXTERNAL SQLFetch *>
PROCEDURE SQLFetch (hstmt: SQLHSTMT): SQLRETURN;
<*EXTERNAL SQLFreeConnect *>
PROCEDURE SQLFreeConnect (hdbc: SQLHDBC): SQLRETURN;
<*EXTERNAL SQLFreeEnv *>
PROCEDURE SQLFreeEnv (henv: SQLHENV): SQLRETURN;
<*EXTERNAL SQLFreeStmt *>
PROCEDURE SQLFreeStmt (hstmt: SQLHSTMT; fOption: SQLUSMALLINT): SQLRETURN;
<*EXTERNAL SQLGetCursorName *>
PROCEDURE SQLGetCursorName (
hstmt: SQLHSTMT;
szCursor: SQLCHAR_star;
cbCursorMax: SQLSMALLINT;
pcbCursor: SQLSMALLINT_star): SQLRETURN;
<*EXTERNAL SQLNumResultCols *>
PROCEDURE SQLNumResultCols (
hstmt: SQLHSTMT;
pccol: SQLSMALLINT_star): SQLRETURN;
<*EXTERNAL SQLPrepare *>
PROCEDURE SQLPrepare (
hstmt: SQLHSTMT;
szSqlStr: SQLCHAR_star;
cbSqlStr: SQLINTEGER): SQLRETURN;
<*EXTERNAL SQLRowCount *>
PROCEDURE SQLRowCount (
hstmt: SQLHSTMT;
pcrow: SQLINTEGER_star): SQLRETURN;
<*EXTERNAL SQLSetCursorName *>
PROCEDURE SQLSetCursorName (
hstmt: SQLHSTMT;
szCursor: SQLCHAR_star;
cbCursor: SQLSMALLINT): SQLRETURN;
<*EXTERNAL SQLTransact *>
PROCEDURE SQLTransact (
henv: SQLHENV;
hdbc: SQLHDBC;
fType: SQLUSMALLINT): SQLRETURN;
Deprecated functions from prior versions of ODBC
<*EXTERNAL SQLSetParam *>
PROCEDURE SQLSetParam (
hstmt: SQLHSTMT;
ipar: SQLUSMALLINT;
fCType: SQLSMALLINT;
fSqlType: SQLSMALLINT;
cbParamDef: SQLUINTEGER;
ibScale: SQLSMALLINT;
rgbValue: SQLPOINTER;
pcbValue: SQLINTEGER_star): SQLRETURN;
Defines used by both Level 1 and Level 2 functions
generally useful constants
CONST SQL_MAX_OPTION_STRING_LENGTH = 256;Additional return codes
CONST SQL_STILL_EXECUTING = 2; SQL_NEED_DATA = 99;SQL extended datatypes
CONST SQL_DATE = 9; SQL_TIME = 10; SQL_TIMESTAMP = 11; SQL_LONGVARCHAR = -1; SQL_BINARY = -2; SQL_VARBINARY = -3; SQL_LONGVARBINARY = -4; SQL_BIGINT = -5; SQL_TINYINT = -6; SQL_BIT = -7; SQL_INTERVAL_YEAR = -80; SQL_INTERVAL_MONTH = -81; SQL_INTERVAL_YEAR_TO_MONTH = -82; SQL_INTERVAL_DAY = -83; SQL_INTERVAL_HOUR = -84; SQL_INTERVAL_MINUTE = -85; SQL_INTERVAL_SECOND = -86; SQL_INTERVAL_DAY_TO_HOUR = -87; SQL_INTERVAL_DAY_TO_MINUTE = -88; SQL_INTERVAL_DAY_TO_SECOND = -89; SQL_INTERVAL_HOUR_TO_MINUTE = -90; SQL_INTERVAL_HOUR_TO_SECOND = -91; SQL_INTERVAL_MINUTE_TO_SECOND = -92; SQL_UNICODE = -95; SQL_UNICODE_VARCHAR = -96; SQL_UNICODE_LONGVARCHAR = -97; SQL_UNICODE_CHAR = SQL_UNICODE; SQL_TYPE_DRIVER_START = SQL_INTERVAL_YEAR; SQL_TYPE_DRIVER_END = SQL_UNICODE_LONGVARCHAR; SQL_SIGNED_OFFSET = -20; SQL_UNSIGNED_OFFSET = -22;C datatype to SQL datatype mapping
CONST SQL_C_DATE = SQL_DATE; SQL_C_TIME = SQL_TIME; SQL_C_TIMESTAMP = SQL_TIMESTAMP; SQL_C_BINARY = SQL_BINARY; SQL_C_BIT = SQL_BIT; SQL_C_TINYINT = SQL_TINYINT; SQL_C_SLONG = SQL_C_LONG + SQL_SIGNED_OFFSET; SQL_C_SSHORT = SQL_C_SHORT + SQL_SIGNED_OFFSET; SQL_C_STINYINT = SQL_TINYINT + SQL_SIGNED_OFFSET; SQL_C_ULONG = SQL_C_LONG + SQL_UNSIGNED_OFFSET; SQL_C_USHORT = SQL_C_SHORT + SQL_UNSIGNED_OFFSET; SQL_U_TINYINT = SQL_TINYINT + SQL_UNSIGNED_OFFSET; SQL_C_BOOKMARK = SQL_C_ULONG;Level 1 Functions
Special return values for SQLGetData
CONST SQL_NO_TOTAL = -4;Defines for SQLGetFunctions and _iodbcdm_getproc
CONST SQL_API_SQLALLOCCONNECT = 1; (* Core Functions *) SQL_API_SQLALLOCENV = 2; SQL_API_SQLALLOCSTMT = 3; SQL_API_SQLBINDCOL = 4; SQL_API_SQLCANCEL = 5; SQL_API_SQLCOLATTRIBUTES = 6; SQL_API_SQLCONNECT = 7; SQL_API_SQLDESCRIBECOL = 8; SQL_API_SQLDISCONNECT = 9; SQL_API_SQLERROR = 10; SQL_API_SQLEXECDIRECT = 11; SQL_API_SQLEXECUTE = 12; SQL_API_SQLFETCH = 13; SQL_API_SQLFREECONNECT = 14; SQL_API_SQLFREEENV = 15; SQL_API_SQLFREESTMT = 16; SQL_API_SQLGETCURSORNAME = 17; SQL_API_NUMRESULTCOLS = 18; SQL_API_SQLPREPARE = 19; SQL_API_SQLROWCOUNT = 20; SQL_API_SQLSETCURSORNAME = 21; SQL_API_SQLSETPARAM = 22; SQL_API_SQLTRANSACT = 23; SQL_NUM_FUNCTIONS = 23; SQL_EXT_API_START = 40; SQL_API_SQLCOLUMNS = 40; (* Level 1 Functions *) SQL_API_SQLDRIVERCONNECT = 41; SQL_API_SQLGETCONNECTOPTION = 42; SQL_API_SQLGETDATA = 43; SQL_API_SQLGETFUNCTIONS = 44; SQL_API_SQLGETINFO = 45; SQL_API_SQLGETSTMTOPTION = 46; SQL_API_SQLGETTYPEINFO = 47; SQL_API_SQLPARAMDATA = 48; SQL_API_SQLPUTDATA = 49; SQL_API_SQLSETCONNECTOPTION = 50; SQL_API_SQLSTMTOPTION = 51; SQL_API_SQLSPECIALCOLUMNS = 52; SQL_API_SQLSTATISTICS = 53; SQL_API_SQLTABLES = 54; SQL_API_SQLBROWSECONNECT = 55; (* Level 2 Functions *) SQL_API_SQLCOLUMNPRIVILEGES = 56; SQL_API_SQLDATASOURCES = 57; SQL_API_SQLDESCRIBEPARAM = 58; SQL_API_SQLEXTENDEDFETCH = 59; SQL_API_SQLFOREIGNKEYS = 60; SQL_API_SQLMORERESULTS = 61; SQL_API_SQLNATIVESQL = 62; SQL_API_SQLNUMPARAMS = 63; SQL_API_SQLPARAMOPTIONS = 64; SQL_API_SQLPRIMARYKEYS = 65; SQL_API_SQLPROCEDURECOLUMNS = 66; SQL_API_SQLPROCEDURES = 67; SQL_API_SQLSETPOS = 68; SQL_API_SQLSETSCROLLOPTIONS = 69; SQL_API_SQLTABLEPRIVILEGES = 70; (* SDK 2.0 Additions *) SQL_API_SQLDRIVERS = 71; SQL_API_SQLBINDPARAMETER = 72; SQL_EXT_API_LAST = SQL_API_SQLBINDPARAMETER; SQL_API_ALL_FUNCTIONS = 0; SQL_NUM_EXTENSIONS = SQL_EXT_API_LAST - SQL_EXT_API_START + 1; SQL_API_LOADBYORDINAL = 199;Defines for SQLGetInfo
CONST SQL_INFO_FIRST = 0; SQL_ACTIVE_CONNECTIONS = 0; SQL_ACTIVE_STATEMENTS = 1; SQL_DATA_SOURCE_NAME = 2; SQL_DRIVER_HDBC = 3; SQL_DRIVER_HENV = 4; SQL_DRIVER_HSTMT = 5; SQL_DRIVER_NAME = 6; SQL_DRIVER_VER = 7; SQL_FETCH_DIRECTION = 8; SQL_ODBC_API_CONFORMANCE = 9; SQL_ODBC_VER = 10; SQL_ROW_UPDATES = 11; SQL_ODBC_SAG_CLI_CONFORMANCE = 12; SQL_SERVER_NAME = 13; SQL_SEARCH_PATTERN_ESCAPE = 14; SQL_ODBC_SQL_CONFORMANCE = 15; SQL_DBMS_NAME = 17; SQL_DBMS_VER = 18; SQL_ACCESSIBLE_TABLES = 19; SQL_ACCESSIBLE_PROCEDURES = 20; SQL_PROCEDURES = 21; SQL_CONCAT_NULL_BEHAVIOR = 22; SQL_CURSOR_COMMIT_BEHAVIOR = 23; SQL_CURSOR_ROLLBACK_BEHAVIOR = 24; SQL_DATA_SOURCE_READ_ONLY = 25; SQL_DEFAULT_TXN_ISOLATION = 26; SQL_EXPRESSIONS_IN_ORDERBY = 27; SQL_IDENTIFIER_CASE = 28; SQL_IDENTIFIER_QUOTE_CHAR = 29; SQL_MAX_COLUMN_NAME_LEN = 30; SQL_MAX_CURSOR_NAME_LEN = 31; SQL_MAX_OWNER_NAME_LEN = 32; SQL_MAX_PROCEDURE_NAME_LEN = 33; SQL_MAX_QUALIFIER_NAME_LEN = 34; SQL_MAX_TABLE_NAME_LEN = 35; SQL_MULT_RESULT_SETS = 36; SQL_MULTIPLE_ACTIVE_TXN = 37; SQL_OUTER_JOINS = 38; SQL_OWNER_TERM = 39; SQL_PROCEDURE_TERM = 40; SQL_QUALIFIER_NAME_SEPARATOR = 41; SQL_QUALIFIER_TERM = 42; SQL_SCROLL_CONCURRENCY = 43; SQL_SCROLL_OPTIONS = 44; SQL_TABLE_TERM = 45; SQL_TXN_CAPABLE = 46; SQL_USER_NAME = 47; SQL_CONVERT_FUNCTIONS = 48; SQL_NUMERIC_FUNCTIONS = 49; SQL_STRING_FUNCTIONS = 50; SQL_SYSTEM_FUNCTIONS = 51; SQL_TIMEDATE_FUNCTIONS = 52; SQL_CONVERT_BIGINT = 53; SQL_CONVERT_BINARY = 54; SQL_CONVERT_BIT = 55; SQL_CONVERT_CHAR = 56; SQL_CONVERT_DATE = 57; SQL_CONVERT_DECIMAL = 58; SQL_CONVERT_DOUBLE = 59; SQL_CONVERT_FLOAT = 60; SQL_CONVERT_INTEGER = 61; SQL_CONVERT_LONGVARCHAR = 62; SQL_CONVERT_NUMERIC = 63; SQL_CONVERT_REAL = 64; SQL_CONVERT_SMALLINT = 65; SQL_CONVERT_TIME = 66; SQL_CONVERT_TIMESTAMP = 67; SQL_CONVERT_TINYINT = 68; SQL_CONVERT_VARBINARY = 69; SQL_CONVERT_VARCHAR = 70; SQL_CONVERT_LONGVARBINARY = 71; SQL_TXN_ISOLATION_OPTION = 72; SQL_ODBC_SQL_OPT_IEF = 73; (* ODBC SDK 1.0 Additions *) SQL_CORRELATION_NAME = 74; SQL_NON_NULLABLE_COLUMNS = 75; (* ODBC SDK 2.0 Additions *) SQL_DRIVER_HLIB = 76; SQL_DRIVER_ODBC_VER = 77; SQL_LOCK_TYPES = 78; SQL_POS_OPERATIONS = 79; SQL_POSITIONED_STATEMENTS = 80; SQL_GETDATA_EXTENSIONS = 81; SQL_BOOKMARK_PERSISTENCE = 82; SQL_STATIC_SENSITIVITY = 83; SQL_FILE_USAGE = 84; SQL_NULL_COLLATION = 85; SQL_ALTER_TABLE = 86; SQL_COLUMN_ALIAS = 87; SQL_GROUP_BY = 88; SQL_KEYWORDS = 89; SQL_ORDER_BY_COLUMNS_IN_SELECT= 90; SQL_OWNER_USAGE = 91; SQL_QUALIFIER_USAGE = 92; SQL_QUOTED_IDENTIFIER_CASE = 93; SQL_SPECIAL_CHARACTERS = 94; SQL_SUBQUERIES = 95; SQL_UNION = 96; SQL_MAX_COLUMNS_IN_GROUP_BY = 97; SQL_MAX_COLUMNS_IN_INDEX = 98; SQL_MAX_COLUMNS_IN_ORDER_BY = 99; SQL_MAX_COLUMNS_IN_SELECT = 100; SQL_MAX_COLUMNS_IN_TABLE = 101; SQL_MAX_INDEX_SIZE = 102; SQL_MAX_ROW_SIZE_INCLUDES_LONG= 103; SQL_MAX_ROW_SIZE = 104; SQL_MAX_STATEMENT_LEN = 105; SQL_MAX_TABLES_IN_SELECT = 106; SQL_MAX_USER_NAME_LEN = 107; SQL_MAX_CHAR_LITERAL_LEN = 108; SQL_TIMEDATE_ADD_INTERVALS = 109; SQL_TIMEDATE_DIFF_INTERVALS = 110; SQL_NEED_LONG_DATA_LEN = 111; SQL_MAX_BINARY_LITERAL_LEN = 112; SQL_LIKE_ESCAPE_CLAUSE = 113; SQL_QUALIFIER_LOCATION = 114; (* ODBC SDK 2.01 Additions *) SQL_OJ_CAPABILITIES = 65003; (* Temporary value until ODBC 3.0 *) SQL_INFO_LAST = SQL_QUALIFIER_LOCATION; SQL_INFO_DRIVER_START = 1000;SQL_CONVERT_* return value bitmasks
CONST SQL_CVT_CHAR = 16_00000001; SQL_CVT_NUMERIC = 16_00000002; SQL_CVT_DECIMAL = 16_00000004; SQL_CVT_INTEGER = 16_00000008; SQL_CVT_SMALLINT = 16_00000010; SQL_CVT_FLOAT = 16_00000020; SQL_CVT_REAL = 16_00000040; SQL_CVT_DOUBLE = 16_00000080; SQL_CVT_VARCHAR = 16_00000100; SQL_CVT_LONGVARCHAR = 16_00000200; SQL_CVT_BINARY = 16_00000400; SQL_CVT_VARBINARY = 16_00000800; SQL_CVT_BIT = 16_00001000; SQL_CVT_TINYINT = 16_00002000; SQL_CVT_BIGINT = 16_00004000; SQL_CVT_DATE = 16_00008000; SQL_CVT_TIME = 16_00010000; SQL_CVT_TIMESTAMP = 16_00020000; SQL_CVT_LONGVARBINARY = 16_00040000;SQL_CONVERT_FUNCTIONS functions
CONST SQL_FN_CVT_CONVERT = 16_00000001;SQL_STRING_FUNCTIONS functions
CONST SQL_FN_STR_CONCAT = 16_00000001; SQL_FN_STR_INSERT = 16_00000002; SQL_FN_STR_LEFT = 16_00000004; SQL_FN_STR_LTRIM = 16_00000008; SQL_FN_STR_LENGTH = 16_00000010; SQL_FN_STR_LOCATE = 16_00000020; SQL_FN_STR_LCASE = 16_00000040; SQL_FN_STR_REPEAT = 16_00000080; SQL_FN_STR_REPLACE = 16_00000100; SQL_FN_STR_RIGHT = 16_00000200; SQL_FN_STR_RTRIM = 16_00000400; SQL_FN_STR_SUBSTRING = 16_00000800; SQL_FN_STR_UCASE = 16_00001000; SQL_FN_STR_ASCII = 16_00002000; SQL_FN_STR_CHAR = 16_00004000; SQL_FN_STR_DIFFERENCE = 16_00008000; SQL_FN_STR_LOCATE_2 = 16_00010000; SQL_FN_STR_SOUNDEX = 16_00020000; SQL_FN_STR_SPACE = 16_00040000;SQL_NUMERIC_FUNCTIONS functions
CONST SQL_FN_NUM_ABS = 16_00000001; SQL_FN_NUM_ACOS = 16_00000002; SQL_FN_NUM_ASIN = 16_00000004; SQL_FN_NUM_ATAN = 16_00000008; SQL_FN_NUM_ATAN2 = 16_00000010; SQL_FN_NUM_CEILING = 16_00000020; SQL_FN_NUM_COS = 16_00000040; SQL_FN_NUM_COT = 16_00000080; SQL_FN_NUM_EXP = 16_00000100; SQL_FN_NUM_FLOOR = 16_00000200; SQL_FN_NUM_LOG = 16_00000400; SQL_FN_NUM_MOD = 16_00000800; SQL_FN_NUM_SIGN = 16_00001000; SQL_FN_NUM_SIN = 16_00002000; SQL_FN_NUM_SQRT = 16_00004000; SQL_FN_NUM_TAN = 16_00008000; SQL_FN_NUM_PI = 16_00010000; SQL_FN_NUM_RAND = 16_00020000; SQL_FN_NUM_DEGREES = 16_00040000; SQL_FN_NUM_LOG10 = 16_00080000; SQL_FN_NUM_POWER = 16_00100000; SQL_FN_NUM_RADIANS = 16_00200000; SQL_FN_NUM_ROUND = 16_00400000; SQL_FN_NUM_TRUNCATE = 16_00800000;SQL_TIMEDATE_FUNCTIONS functions
CONST SQL_FN_TD_NOW = 16_00000001; SQL_FN_TD_CURDATE = 16_00000002; SQL_FN_TD_DAYOFMONTH = 16_00000004; SQL_FN_TD_DAYOFWEEK = 16_00000008; SQL_FN_TD_DAYOFYEAR = 16_00000010; SQL_FN_TD_MONTH = 16_00000020; SQL_FN_TD_QUARTER = 16_00000040; SQL_FN_TD_WEEK = 16_00000080; SQL_FN_TD_YEAR = 16_00000100; SQL_FN_TD_CURTIME = 16_00000200; SQL_FN_TD_HOUR = 16_00000400; SQL_FN_TD_MINUTE = 16_00000800; SQL_FN_TD_SECOND = 16_00001000; SQL_FN_TD_TIMESTAMPADD = 16_00002000; SQL_FN_TD_TIMESTAMPDIFF = 16_00004000; SQL_FN_TD_DAYNAME = 16_00008000; SQL_FN_TD_MONTHNAME = 16_00010000;SQL_SYSTEM_FUNCTIONS functions
CONST SQL_FN_SYS_USERNAME = 16_00000001; SQL_FN_SYS_DBNAME = 16_00000002; SQL_FN_SYS_IFNULL = 16_00000004;SQL_TIMEDATE_ADD_INTERVALS and SQL_TIMEDATE_DIFF_INTERVALS functions
CONST SQL_FN_TSI_FRAC_SECOND = 16_00000001; SQL_FN_TSI_SECOND = 16_00000002; SQL_FN_TSI_MINUTE = 16_00000004; SQL_FN_TSI_HOUR = 16_00000008; SQL_FN_TSI_DAY = 16_00000010; SQL_FN_TSI_WEEK = 16_00000020; SQL_FN_TSI_MONTH = 16_00000040; SQL_FN_TSI_QUARTER = 16_00000080; SQL_FN_TSI_YEAR = 16_00000100;SQL_ODBC_API_CONFORMANCE values
CONST SQL_OAC_NONE = 16_0000; SQL_OAC_LEVEL1 = 16_0001; SQL_OAC_LEVEL2 = 16_0002;SQL_ODBC_SAG_CLI_CONFORMANCE values
CONST SQL_OSCC_NOT_COMPLIANT = 16_0000; SQL_OSCC_COMPLIANT = 16_0001;SQL_ODBC_SQL_CONFORMANCE values
SQL_OSC_MINIMUM = 16_0000; SQL_OSC_CORE = 16_0001; SQL_OSC_EXTENDED = 16_0002;SQL_CONCAT_NULL_BEHAVIOR values
SQL_CB_NULL = 16_0000; SQL_CB_NON_NULL = 16_0001;SQL_CURSOR_COMMIT_BEHAVIOR and SQL_CURSOR_ROLLBACK_BEHAVIOR values
SQL_CB_DELETE = 16_0000; SQL_CB_CLOSE = 16_0001; SQL_CB_PRESERVE = 16_0002;SQL_IDENTIFIER_CASE values
SQL_IC_UPPER = 16_0001; SQL_IC_LOWER = 16_0002; SQL_IC_SENSITIVE = 16_0003; SQL_IC_MIXED = 16_0004;SQL_TXN_CAPABLE values
SQL_TC_NONE = 16_0000; SQL_TC_DML = 16_0001; SQL_TC_ALL = 16_0002; SQL_TC_DDL_COMMIT = 16_0003; SQL_TC_DDL_IGNORE = 16_0004;SQL_SCROLL_OPTIONS masks
SQL_SO_FORWARD_ONLY = 16_00000001; SQL_SO_KEYSET_DRIVEN = 16_00000002; SQL_SO_DYNAMIC = 16_00000004; SQL_SO_MIXED = 16_00000008; SQL_SO_STATIC = 16_00000010;SQL_SCROLL_CONCURRENCY masks
SQL_SCCO_READ_ONLY = 16_00000001; SQL_SCCO_LOCK = 16_00000002; SQL_SCCO_OPT_ROWVER = 16_00000004; SQL_SCCO_OPT_VALUES = 16_00000008;SQL_FETCH_DIRECTION masks
SQL_FD_FETCH_NEXT = 16_00000001; SQL_FD_FETCH_FIRST = 16_00000002; SQL_FD_FETCH_LAST = 16_00000004; SQL_FD_FETCH_PRIOR = 16_00000008; SQL_FD_FETCH_ABSOLUTE = 16_00000010; SQL_FD_FETCH_RELATIVE = 16_00000020; SQL_FD_FETCH_RESUME = 16_00000040; SQL_FD_FETCH_BOOKMARK = 16_00000080;SQL_TXN_ISOLATION_OPTION masks
SQL_TXN_READ_UNCOMMITTED = 16_00000001; SQL_TXN_READ_COMMITTED = 16_00000002; SQL_TXN_REPEATABLE_READ = 16_00000004; SQL_TXN_SERIALIZABLE = 16_00000008; SQL_TXN_VERSIONING = 16_00000010;SQL_CORRELATION_NAME values
SQL_CN_NONE = 16_0000; SQL_CN_DIFFERENT = 16_0001; SQL_CN_ANY = 16_0002;SQL_NON_NULLABLE_COLUMNS values
SQL_NNC_NULL = 16_0000; SQL_NNC_NON_NULL = 16_0001;SQL_NULL_COLLATION values
SQL_NC_HIGH = 16_0000; SQL_NC_LOW = 16_0001; SQL_NC_START = 16_0002; SQL_NC_END = 16_0004;SQL_FILE_USAGE values
SQL_FILE_NOT_SUPPORTED = 16_0000; SQL_FILE_TABLE = 16_0001; SQL_FILE_QUALIFIER = 16_0002;SQL_GETDATA_EXTENSIONS values
SQL_GD_ANY_COLUMN = 16_00000001; SQL_GD_ANY_ORDER = 16_00000002; SQL_GD_BLOCK = 16_00000004; SQL_GD_BOUND = 16_00000008;SQL_ALTER_TABLE values
SQL_AT_ADD_COLUMN = 16_00000001; SQL_AT_DROP_COLUMN = 16_00000002;SQL_POSITIONED_STATEMENTS masks
SQL_PS_POSITIONED_DELETE = 16_00000001; SQL_PS_POSITIONED_UPDATE = 16_00000002; SQL_PS_SELECT_FOR_UPDATE = 16_00000004;SQL_GROUP_BY values
SQL_GB_NOT_SUPPORTED = 16_0000; SQL_GB_GROUP_BY_EQUALS_SELECT = 16_0001; SQL_GB_GROUP_BY_CONTAINS_SELECT = 16_0002; SQL_GB_NO_RELATION = 16_0003;SQL_OWNER_USAGE masks
SQL_OU_DML_STATEMENTS = 16_00000001; SQL_OU_PROCEDURE_INVOCATION = 16_00000002; SQL_OU_TABLE_DEFINITION = 16_00000004; SQL_OU_INDEX_DEFINITION = 16_00000008; SQL_OU_PRIVILEGE_DEFINITION = 16_00000010;SQL_QUALIFIER_USAGE masks
SQL_QU_DML_STATEMENTS = 16_00000001; SQL_QU_PROCEDURE_INVOCATION = 16_00000002; SQL_QU_TABLE_DEFINITION = 16_00000004; SQL_QU_INDEX_DEFINITION = 16_00000008; SQL_QU_PRIVILEGE_DEFINITION = 16_00000010;SQL_SUBQUERIES masks
SQL_SQ_COMPARISON = 16_00000001; SQL_SQ_EXISTS = 16_00000002; SQL_SQ_IN = 16_00000004; SQL_SQ_QUANTIFIED = 16_00000008; SQL_SQ_CORRELATED_SUBQUERIES = 16_00000010;SQL_UNION masks
SQL_U_UNION = 16_00000001; SQL_U_UNION_ALL = 16_00000002;SQL_BOOKMARK_PERSISTENCE values
SQL_BP_CLOSE = 16_00000001; SQL_BP_DELETE = 16_00000002; SQL_BP_DROP = 16_00000004; SQL_BP_TRANSACTION = 16_00000008; SQL_BP_UPDATE = 16_00000010; SQL_BP_OTHER_HSTMT = 16_00000020; SQL_BP_SCROLL = 16_00000040;SQL_STATIC_SENSITIVITY values
SQL_SS_ADDITIONS = 16_00000001; SQL_SS_DELETIONS = 16_00000002; SQL_SS_UPDATES = 16_00000004;SQL_LOCK_TYPESL masks
SQL_LCK_NO_CHANGE = 16_00000001; SQL_LCK_EXCLUSIVE = 16_00000002; SQL_LCK_UNLOCK = 16_00000004;SQL_POS_OPERATIONS masks
SQL_POS_POSITION = 16_00000001; SQL_POS_REFRESH = 16_00000002; SQL_POS_UPDATE = 16_00000004; SQL_POS_DELETE = 16_00000008; SQL_POS_ADD = 16_00000010;SQL_QUALIFIER_LOCATION values
SQL_QL_START = 16_0001; SQL_QL_END = 16_0002;SQL_OJ_CAPABILITIES values
SQL_OJ_LEFT = 16_00000001; SQL_OJ_RIGHT = 16_00000002; SQL_OJ_FULL = 16_00000004; SQL_OJ_NESTED = 16_00000008; SQL_OJ_NOT_ORDERED = 16_00000010; SQL_OJ_INNER = 16_00000020; SQL_OJ_ALL_COMPARISON_OPS = 16_00000040;options for SQLGetStmtOption/SQLSetStmtOption
SQL_QUERY_TIMEOUT = 0; SQL_MAX_ROWS = 1; SQL_NOSCAN = 2; SQL_MAX_LENGTH = 3; SQL_ASYNC_ENABLE = 4; SQL_BIND_TYPE = 5; SQL_CURSOR_TYPE = 6; SQL_CONCURRENCY = 7; SQL_KEYSET_SIZE = 8; SQL_ROWSET_SIZE = 9; SQL_SIMULATE_CURSOR = 10; SQL_RETRIEVE_DATA = 11; SQL_USE_BOOKMARKS = 12; SQL_GET_BOOKMARK = 13; (* GetStmtOption Only *) SQL_ROW_NUMBER = 14; (* GetStmtOption Only *) SQL_STMT_OPT_MAX = SQL_ROW_NUMBER; SQL_STMT_OPT_MIN = SQL_QUERY_TIMEOUT;SQL_QUERY_TIMEOUT options
SQL_QUERY_TIMEOUT_DEFAULT = 0;SQL_MAX_ROWS options
SQL_MAX_ROWS_DEFAULT = 0;SQL_NOSCAN options
SQL_NOSCAN_OFF = 0; (* 1.0 FALSE *) SQL_NOSCAN_ON = 1; (* 1.0 TRUE *) SQL_NOSCAN_DEFAULT = SQL_NOSCAN_OFF;SQL_MAX_LENGTH options
SQL_MAX_LENGTH_DEFAULT = 0;SQL_ASYNC_ENABLE options
SQL_ASYNC_ENABLE_OFF = 0; SQL_ASYNC_ENABLE_ON = 1; SQL_ASYNC_ENABLE_DEFAULT = SQL_ASYNC_ENABLE_OFF;SQL_BIND_TYPE options
SQL_BIND_BY_COLUMN = 0; SQL_BIND_TYPE_DEFAULT = SQL_BIND_BY_COLUMN; (* Default value *)SQL_CONCURRENCY options
SQL_CONCUR_READ_ONLY = 1; SQL_CONCUR_LOCK = 2; SQL_CONCUR_ROWVER = 3; SQL_CONCUR_VALUES = 4; SQL_CONCUR_DEFAULT = SQL_CONCUR_READ_ONLY; (* Default value *)SQL_CURSOR_TYPE options
SQL_CURSOR_FORWARD_ONLY = 0; SQL_CURSOR_KEYSET_DRIVEN = 1; SQL_CURSOR_DYNAMIC = 2; SQL_CURSOR_STATIC = 3; SQL_CURSOR_TYPE_DEFAULT = SQL_CURSOR_FORWARD_ONLY; (* Default value *)SQL_ROWSET_SIZE options
SQL_ROWSET_SIZE_DEFAULT = 1;SQL_KEYSET_SIZE options
SQL_KEYSET_SIZE_DEFAULT = 0;SQL_SIMULATE_CURSOR options
SQL_SC_NON_UNIQUE = 0; SQL_SC_TRY_UNIQUE = 1; SQL_SC_UNIQUE = 2;SQL_RETRIEVE_DATA options
SQL_RD_OFF = 0; SQL_RD_ON = 1; SQL_RD_DEFAULT = SQL_RD_ON;SQL_USE_BOOKMARKS options
SQL_UB_OFF = 0; SQL_UB_ON = 1; SQL_UB_DEFAULT = SQL_UB_OFF;options for SQLSetConnectOption/SQLGetConnectOption
SQL_ACCESS_MODE = 101; SQL_AUTOCOMMIT = 102; SQL_LOGIN_TIMEOUT = 103; SQL_OPT_TRACE = 104; SQL_OPT_TRACEFILE = 105; SQL_TRANSLATE_DLL = 106; SQL_TRANSLATE_OPTION = 107; SQL_TXN_ISOLATION = 108; SQL_CURRENT_QUALIFIER = 109; SQL_ODBC_CURSORS = 110; SQL_QUIET_MODE = 111; SQL_PACKET_SIZE = 112; SQL_CONN_OPT_MAX = SQL_PACKET_SIZE; SQL_CONNECT_OPT_DRVR_START = 1000; SQL_CONN_OPT_MIN = SQL_ACCESS_MODE;SQL_ACCESS_MODE options
SQL_MODE_READ_WRITE = 0; SQL_MODE_READ_ONLY = 1; SQL_MODE_DEFAULT = SQL_MODE_READ_WRITE;SQL_AUTOCOMMIT options
SQL_AUTOCOMMIT_OFF = 0; SQL_AUTOCOMMIT_ON = 1; SQL_AUTOCOMMIT_DEFAULT = SQL_AUTOCOMMIT_ON;SQL_LOGIN_TIMEOUT options
SQL_LOGIN_TIMEOUT_DEFAULT = 15;SQL_OPT_TRACE options
SQL_OPT_TRACE_OFF = 0; SQL_OPT_TRACE_ON = 1; SQL_OPT_TRACE_DEFAULT = SQL_OPT_TRACE_OFF; SQL_OPT_TRACE_FILE_DEFAULT = "odbc.log";SQL_ODBC_CURSORS options
SQL_CUR_USE_IF_NEEDED = 0; SQL_CUR_USE_ODBC = 1; SQL_CUR_USE_DRIVER = 2; SQL_CUR_DEFAULT = SQL_CUR_USE_DRIVER;Column types and scopes in SQLSpecialColumns.
SQL_BEST_ROWID = 1; SQL_ROWVER = 2; SQL_SCOPE_CURROW = 0; SQL_SCOPE_TRANSACTION = 1; SQL_SCOPE_SESSION = 2;Defines for SQLStatistics
SQL_INDEX_UNIQUE = 0; SQL_INDEX_ALL = 1; SQL_QUICK = 0; SQL_ENSURE = 1;Defines for SQLStatistics (returned in the result set)
SQL_TABLE_STAT = 0; SQL_INDEX_CLUSTERED = 1; SQL_INDEX_HASHED = 2; SQL_INDEX_OTHER = 3;Defines for SQLSpecialColumns (returned in the result set)
SQL_PC_UNKNOWN = 0; SQL_PC_NOT_PSEUDO = 1; SQL_PC_PSEUDO = 2;SQLDataSources
fDirection values, also used on SQLExtendedFetch()
SQL_FETCH_NEXT = 1; SQL_FETCH_FIRST = 2;Level 1 Prototypes
<*EXTERNAL SQLColumns *>
PROCEDURE SQLColumns (
hstmt: SQLHSTMT;
szCatalogName: SQLCHAR_star;
cbCatalogName: SQLSMALLINT;
szSchemaName: SQLCHAR_star;
cbSchemaName: SQLSMALLINT;
szTableName: SQLCHAR_star;
cbTableName: SQLSMALLINT;
szColumnName: SQLCHAR_star;
cbColumnName: SQLSMALLINT): SQLRETURN;
<*EXTERNAL SQLGetConnectOption *>
PROCEDURE SQLGetConnectOption (
hdbc: SQLHDBC;
fOption: SQLUSMALLINT;
pvParam: SQLPOINTER): SQLRETURN;
<*EXTERNAL SQLGetData *>
PROCEDURE SQLGetData (
hstmt: SQLHSTMT;
icol: SQLUSMALLINT;
fCtype: SQLSMALLINT;
rgbValue: SQLPOINTER;
cbValueMax: SQLINTEGER;
pcbValue: SQLINTEGER_star): SQLRETURN;
<*EXTERNAL SQLGetFunctions *>
PROCEDURE SQLGetFunctions (
hdbc: SQLHDBC;
fFunction: SQLUSMALLINT;
pfExists: SQLUSMALLINT_star): SQLRETURN;
<*EXTERNAL SQLGetInfo *>
PROCEDURE SQLGetInfo (
hdbc: SQLHDBC;
fInfoType: SQLUSMALLINT;
rgbInfoValue: SQLPOINTER;
cbInfoValueMax: SQLSMALLINT;
pcbInfoValue: SQLSMALLINT_star): SQLRETURN;
<*EXTERNAL SQLGetStmtOption *>
PROCEDURE SQLGetStmtOption (
hstmt: SQLHSTMT;
fOption: SQLUSMALLINT;
pvParam: SQLPOINTER): SQLRETURN;
<*EXTERNAL SQLGetTypeInfo *>
PROCEDURE SQLGetTypeInfo (
hstmt: SQLHSTMT;
fSqlType: SQLSMALLINT): SQLRETURN;
<*EXTERNAL SQLParamData *>
PROCEDURE SQLParamData (
hstmt: SQLHSTMT;
prgbValue: SQLPOINTER_star): SQLRETURN;
<*EXTERNAL SQLPutData *>
PROCEDURE SQLPutData (
hstmt: SQLHSTMT;
rgbValue: SQLPOINTER;
cbValue: SQLINTEGER): SQLRETURN;
<*EXTERNAL SQLSetConnectOption *>
PROCEDURE SQLSetConnectOption (
hdbc: SQLHDBC;
fOption: SQLUSMALLINT;
vParam: SQLUINTEGER): SQLRETURN;
<*EXTERNAL SQLSetStmtOption *>
PROCEDURE SQLSetStmtOption (
hstmt: SQLHSTMT;
fOption: SQLUSMALLINT;
vParam: SQLUINTEGER): SQLRETURN;
<*EXTERNAL SQLSpecialColumns *>
PROCEDURE SQLSpecialColumns (
hstmt: SQLHSTMT;
fColType: SQLUSMALLINT;
szCatalogName: SQLCHAR_star;
cbCatalogName: SQLSMALLINT;
szSchemaName: SQLCHAR_star;
cbSchemaName: SQLSMALLINT;
szTableName: SQLCHAR_star;
cbTableName: SQLSMALLINT;
fScope: SQLUSMALLINT;
fNullable: SQLUSMALLINT): SQLRETURN;
<*EXTERNAL SQLStatistics *>
PROCEDURE SQLStatistics (
hstmt: SQLHSTMT;
szCatalogName: SQLCHAR_star;
cbCatalogName: SQLSMALLINT;
szSchemaName: SQLCHAR_star;
cbSchemaName: SQLSMALLINT;
szTableName: SQLCHAR_star;
cbTableName: SQLSMALLINT;
fUnique: SQLUSMALLINT;
fAccuracy: SQLUSMALLINT): SQLRETURN;
<*EXTERNAL SQLTables *>
PROCEDURE SQLTables (
hstmt: SQLHSTMT;
szCatalogName: SQLCHAR_star;
cbCatalogName: SQLSMALLINT;
szSchemaName: SQLCHAR_star;
cbSchemaName: SQLSMALLINT;
szTableName: SQLCHAR_star;
cbTableName: SQLSMALLINT;
szTableType: SQLCHAR_star;
cbTableType: SQLSMALLINT): SQLRETURN;
Level 2 Functions
<*EXTERNAL SQLDataSources *>
PROCEDURE SQLDataSources (
henv: SQLHENV;
fDirection: SQLUSMALLINT;
szDSN: SQLCHAR_star;
cbDSNMax: SQLSMALLINT;
pcbDSN: SQLSMALLINT_star;
szDescription: SQLCHAR_star;
cbDescriptionMax: SQLSMALLINT;
pcbDescription: SQLSMALLINT_star): SQLRETURN;
Deprecated defines from prior versions of ODBC
CONST SQL_DATABASE_NAME = 16; (* Use SQLGetConnectOption/SQL_CURRENT_QUALIFIER *) SQL_FD_FETCH_PREV = SQL_FD_FETCH_PRIOR; SQL_FETCH_PREV = 4; (* == SQLext.SQL_FETCH_PRIOR *) SQL_CONCUR_TIMESTAMP = SQL_CONCUR_ROWVER; SQL_SCCO_OPT_TIMESTAMP = SQL_SCCO_OPT_ROWVER; SQL_CC_DELETE = SQL_CB_DELETE; SQL_CR_DELETE = SQL_CB_DELETE; SQL_CC_CLOSE = SQL_CB_CLOSE; SQL_CR_CLOSE = SQL_CB_CLOSE; SQL_CC_PRESERVE = SQL_CB_PRESERVE; SQL_CR_PRESERVE = SQL_CB_PRESERVE; SQL_FETCH_RESUME = 7; (* Not supported by 2.0 drivers *) SQL_SCROLL_FORWARD_ONLY = 0; (* -SQL_CURSOR_FORWARD_ONLY *) SQL_SCROLL_KEYSET_DRIVEN = -1; (* -SQL_CURSOR_KEYSET_DRIVEN *) SQL_SCROLL_DYNAMIC = -2; (* -SQL_CURSOR_DYNAMIC *) SQL_SCROLL_STATIC = -3; (* -SQL_CURSOR_STATIC *) SQL_PC_NON_PSEUDO = SQL_PC_NOT_PSEUDO;Deprecated functions from prior versions of ODBC
<*EXTERNAL SQLSetScrollOptions *>
PROCEDURE SQLSetScrollOptions ( (* Use SQLSetStmtOptions instead *)
hstmt: SQLHSTMT;
fConcurrency: SQLUSMALLINT;
crowKeyset: SQLINTEGER;
crowRowset: SQLUSMALLINT): SQLRETURN;
END SQL.