summaryrefslogtreecommitdiff
path: root/dbi_sql.h
diff options
context:
space:
mode:
Diffstat (limited to 'dbi_sql.h')
-rw-r--r--dbi_sql.h96
1 files changed, 96 insertions, 0 deletions
diff --git a/dbi_sql.h b/dbi_sql.h
new file mode 100644
index 0000000..1d7869d
--- /dev/null
+++ b/dbi_sql.h
@@ -0,0 +1,96 @@
+/* $Id: dbi_sql.h 2488 2006-02-07 22:24:43Z timbo $
+ *
+ * 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 */