Edit File: dbi_sql.h
/* $Id$ * * Copyright (c) 1997,1998,1999 Tim Bunce England * * See COPYRIGHT section in DBI.pm for usage and distribution rights. */ /* Some core SQL CLI standard (ODBC) declarations */ #ifndef SQL_SUCCESS /* don't clash with ODBC based drivers */ /* SQL datatype codes */ #define SQL_GUID (-11) #define SQL_WLONGVARCHAR (-10) #define SQL_WVARCHAR (-9) #define SQL_WCHAR (-8) #define SQL_BIT (-7) #define SQL_TINYINT (-6) #define SQL_BIGINT (-5) #define SQL_LONGVARBINARY (-4) #define SQL_VARBINARY (-3) #define SQL_BINARY (-2) #define SQL_LONGVARCHAR (-1) #define SQL_UNKNOWN_TYPE 0 #define SQL_ALL_TYPES 0 #define SQL_CHAR 1 #define SQL_NUMERIC 2 #define SQL_DECIMAL 3 #define SQL_INTEGER 4 #define SQL_SMALLINT 5 #define SQL_FLOAT 6 #define SQL_REAL 7 #define SQL_DOUBLE 8 #define SQL_DATETIME 9 #define SQL_DATE 9 #define SQL_INTERVAL 10 #define SQL_TIME 10 #define SQL_TIMESTAMP 11 #define SQL_VARCHAR 12 #define SQL_BOOLEAN 16 #define SQL_UDT 17 #define SQL_UDT_LOCATOR 18 #define SQL_ROW 19 #define SQL_REF 20 #define SQL_BLOB 30 #define SQL_BLOB_LOCATOR 31 #define SQL_CLOB 40 #define SQL_CLOB_LOCATOR 41 #define SQL_ARRAY 50 #define SQL_ARRAY_LOCATOR 51 #define SQL_MULTISET 55 #define SQL_MULTISET_LOCATOR 56 #define SQL_TYPE_DATE 91 #define SQL_TYPE_TIME 92 #define SQL_TYPE_TIMESTAMP 93 #define SQL_TYPE_TIME_WITH_TIMEZONE 94 #define SQL_TYPE_TIMESTAMP_WITH_TIMEZONE 95 #define SQL_INTERVAL_YEAR 101 #define SQL_INTERVAL_MONTH 102 #define SQL_INTERVAL_DAY 103 #define SQL_INTERVAL_HOUR 104 #define SQL_INTERVAL_MINUTE 105 #define SQL_INTERVAL_SECOND 106 #define SQL_INTERVAL_YEAR_TO_MONTH 107 #define SQL_INTERVAL_DAY_TO_HOUR 108 #define SQL_INTERVAL_DAY_TO_MINUTE 109 #define SQL_INTERVAL_DAY_TO_SECOND 110 #define SQL_INTERVAL_HOUR_TO_MINUTE 111 #define SQL_INTERVAL_HOUR_TO_SECOND 112 #define SQL_INTERVAL_MINUTE_TO_SECOND 113 /* Main return codes */ #define SQL_ERROR (-1) #define SQL_SUCCESS 0 #define SQL_SUCCESS_WITH_INFO 1 #define SQL_NO_DATA_FOUND 100 /* * for ODBC SQL Cursor Types */ #define SQL_CURSOR_FORWARD_ONLY 0UL #define SQL_CURSOR_KEYSET_DRIVEN 1UL #define SQL_CURSOR_DYNAMIC 2UL #define SQL_CURSOR_STATIC 3UL #define SQL_CURSOR_TYPE_DEFAULT SQL_CURSOR_FORWARD_ONLY #endif /* SQL_SUCCESS */ /* Handy macro for testing for success and success with info. */ /* BEWARE that this macro can have side effects since rc appears twice! */ /* So DONT use it as if(SQL_ok(func(...))) { ... } */ #define SQL_ok(rc) ((rc)==SQL_SUCCESS || (rc)==SQL_SUCCESS_WITH_INFO) /* end of dbi_sql.h */