[Summary view] [Print] [Text view]

   1  /* $Id: dbi_sql.h 2488 2006-02-07 22:24:43Z timbo $
   2   *
   3   * Copyright (c) 1997,1998,1999  Tim Bunce  England
   4   *
   5   * See COPYRIGHT section in DBI.pm for usage and distribution rights.
   6   */
   7  
   8  
   9  /* Some core SQL CLI standard (ODBC) declarations        */
  10  #ifndef SQL_SUCCESS    /* don't clash with ODBC based drivers    */
  11  
  12  /* SQL datatype codes */
  13  #define SQL_GUID                         (-11)
  14  #define SQL_WLONGVARCHAR                 (-10)
  15  #define SQL_WVARCHAR                      (-9)
  16  #define SQL_WCHAR                         (-8)
  17  #define SQL_BIT                           (-7)
  18  #define SQL_TINYINT                       (-6)
  19  #define SQL_BIGINT                        (-5)
  20  #define SQL_LONGVARBINARY                 (-4)
  21  #define SQL_VARBINARY                     (-3)
  22  #define SQL_BINARY                        (-2)
  23  #define SQL_LONGVARCHAR                   (-1)
  24  #define SQL_UNKNOWN_TYPE                    0
  25  #define SQL_ALL_TYPES                       0
  26  #define SQL_CHAR                            1
  27  #define SQL_NUMERIC                         2
  28  #define SQL_DECIMAL                         3
  29  #define SQL_INTEGER                         4
  30  #define SQL_SMALLINT                        5
  31  #define SQL_FLOAT                           6
  32  #define SQL_REAL                            7
  33  #define SQL_DOUBLE                          8
  34  #define SQL_DATETIME                        9
  35  #define SQL_DATE                            9
  36  #define SQL_INTERVAL                       10
  37  #define SQL_TIME                           10
  38  #define SQL_TIMESTAMP                      11
  39  #define SQL_VARCHAR                        12
  40  #define SQL_BOOLEAN                        16
  41  #define SQL_UDT                            17
  42  #define SQL_UDT_LOCATOR                    18
  43  #define SQL_ROW                            19
  44  #define SQL_REF                            20
  45  #define SQL_BLOB                           30
  46  #define SQL_BLOB_LOCATOR                   31
  47  #define SQL_CLOB                           40
  48  #define SQL_CLOB_LOCATOR                   41
  49  #define SQL_ARRAY                          50
  50  #define SQL_ARRAY_LOCATOR                  51
  51  #define SQL_MULTISET                       55
  52  #define SQL_MULTISET_LOCATOR               56
  53  #define SQL_TYPE_DATE                      91
  54  #define SQL_TYPE_TIME                      92
  55  #define SQL_TYPE_TIMESTAMP                 93
  56  #define SQL_TYPE_TIME_WITH_TIMEZONE        94
  57  #define SQL_TYPE_TIMESTAMP_WITH_TIMEZONE   95
  58  #define SQL_INTERVAL_YEAR                 101
  59  #define SQL_INTERVAL_MONTH                102
  60  #define SQL_INTERVAL_DAY                  103
  61  #define SQL_INTERVAL_HOUR                 104
  62  #define SQL_INTERVAL_MINUTE               105
  63  #define SQL_INTERVAL_SECOND               106
  64  #define SQL_INTERVAL_YEAR_TO_MONTH        107
  65  #define SQL_INTERVAL_DAY_TO_HOUR          108
  66  #define SQL_INTERVAL_DAY_TO_MINUTE        109
  67  #define SQL_INTERVAL_DAY_TO_SECOND        110
  68  #define SQL_INTERVAL_HOUR_TO_MINUTE       111
  69  #define SQL_INTERVAL_HOUR_TO_SECOND       112
  70  #define SQL_INTERVAL_MINUTE_TO_SECOND     113
  71  
  72  
  73  /* Main return codes                        */
  74  #define    SQL_ERROR            (-1)
  75  #define    SQL_SUCCESS            0
  76  #define    SQL_SUCCESS_WITH_INFO        1
  77  #define    SQL_NO_DATA_FOUND        100
  78  
  79  /*
  80   * for ODBC SQL Cursor Types
  81   */
  82  #define SQL_CURSOR_FORWARD_ONLY         0UL
  83  #define SQL_CURSOR_KEYSET_DRIVEN        1UL
  84  #define SQL_CURSOR_DYNAMIC              2UL
  85  #define SQL_CURSOR_STATIC               3UL
  86  #define SQL_CURSOR_TYPE_DEFAULT         SQL_CURSOR_FORWARD_ONLY
  87  
  88  #endif    /*    SQL_SUCCESS    */
  89  
  90  /* Handy macro for testing for success and success with info.        */
  91  /* BEWARE that this macro can have side effects since rc appears twice!    */
  92  /* So DONT use it as if(SQL_ok(func(...))) { ... }            */
  93  #define SQL_ok(rc)    ((rc)==SQL_SUCCESS || (rc)==SQL_SUCCESS_WITH_INFO)
  94  
  95  
  96  /* end of dbi_sql.h */