vxodbc/catfunc.h

   1 /* File:                        catfunc.h
   2  *
   3  * Description:         See "info.c"
   4  *
   5  * Comments:            See "notice.txt" for copyright and license information.
   6  *
   7  */
   8
   9 #ifndef __CATFUNC_H__
  10 #define __CATFUNC_H__
  11
  12 #include "psqlodbc.h"
  13
  14 /*      SQLTables field position        */
  15 enum {
  16         TABLES_CATALOG_NAME     =       0
  17         ,TABLES_SCHEMA_NAME
  18         ,TABLES_TABLE_NAME
  19         ,TABLES_TABLE_TYPE
  20         ,TABLES_REMARKS
  21         ,NUM_OF_TABLES_FIELDS
  22 };
  23
  24 /*      SQLColumns field position       */
  25 enum {
  26         COLUMNS_CATALOG_NAME    =       0
  27         ,COLUMNS_SCHEMA_NAME
  28         ,COLUMNS_TABLE_NAME
  29         ,COLUMNS_COLUMN_NAME
  30         ,COLUMNS_DATA_TYPE
  31         ,COLUMNS_TYPE_NAME
  32         ,COLUMNS_PRECISION
  33         ,COLUMNS_LENGTH
  34         ,COLUMNS_SCALE
  35         ,COLUMNS_RADIX
  36         ,COLUMNS_NULLABLE
  37         ,COLUMNS_REMARKS
  38         ,COLUMNS_COLUMN_DEF
  39         ,COLUMNS_SQL_DATA_TYPE
  40         ,COLUMNS_SQL_DATETIME_SUB
  41         ,COLUMNS_CHAR_OCTET_LENGTH
  42         ,COLUMNS_ORDINAL_POSITION
  43         ,COLUMNS_IS_NULLABLE
  44         ,COLUMNS_DISPLAY_SIZE
  45         ,COLUMNS_FIELD_TYPE
  46         ,COLUMNS_AUTO_INCREMENT
  47         ,COLUMNS_PHYSICAL_NUMBER
  48         ,COLUMNS_TABLE_OID
  49         ,NUM_OF_COLUMNS_FIELDS
  50 };
  51 /*      SQLPrimaryKeys field position   */
  52 enum {
  53         PKS_TABLE_CAT   =       0
  54         ,PKS_TABLE_SCHEM
  55         ,PKS_TABLE_NAME
  56         ,PKS_COLUMN_NAME
  57         ,PKS_KEY_SQ
  58         ,PKS_PK_NAME
  59         ,NUM_OF_PKS_FIELDS
  60 };
  61 /*      SQLForeignKeys field position   */
  62 enum {
  63         FKS_PKTABLE_CAT =       0
  64         ,FKS_PKTABLE_SCHEM
  65         ,FKS_PKTABLE_NAME
  66         ,FKS_PKCOLUMN_NAME
  67         ,FKS_FKTABLE_CAT
  68         ,FKS_FKTABLE_SCHEM
  69         ,FKS_FKTABLE_NAME
  70         ,FKS_FKCOLUMN_NAME
  71         ,FKS_KEY_SEQ
  72         ,FKS_UPDATE_RULE
  73         ,FKS_DELETE_RULE
  74         ,FKS_FK_NAME
  75         ,FKS_PK_NAME
  76         ,FKS_DEFERRABILITY
  77         ,FKS_TRIGGER_NAME
  78         ,NUM_OF_FKS_FIELDS
  79 };
  80 /* SQLColAttribute */
  81 enum {
  82         COLATTR_DESC_COUNT = -1
  83         ,COLATTR_DESC_AUTO_UNIQUE_VALUE = 0
  84         ,COLATTR_DESC_BASE_COLUMN_NAME
  85         ,COLATTR_DESC_BASE_TABLE_NAME
  86         ,COLATTR_DESC_CASE_SENSITIVE
  87         ,COLATTR_DESC_CATALOG_NAME
  88         ,COLATTR_DESC_CONCISE_TYPE
  89         ,COLATTR_DESC_DISPLAY_SIZE
  90         ,COLATTR_DESC_FIXED_PREC_SCALE
  91         ,COLATTR_DESC_LABEL
  92         ,COLATTR_DESC_LENGTH
  93         ,COLATTR_DESC_LITERAL_PREFIX
  94         ,COLATTR_DESC_LITERAL_SUFFIX
  95         ,COLATTR_DESC_LOCAL_TYPE_NAME
  96         ,COLATTR_DESC_NAME
  97         ,COLATTR_DESC_NULLABLE
  98         ,COLATTR_DESC_NUM_PREX_RADIX
  99         ,COLATTR_DESC_OCTET_LENGTH
 100         ,COLATTR_DESC_PRECISION
 101         ,COLATTR_DESC_SCALE
 102         ,COLATTR_DESC_SCHEMA_NAME
 103         ,COLATTR_DESC_SEARCHABLE
 104         ,COLATTR_DESC_TABLE_NAME
 105         ,COLATTR_DESC_TYPE
 106         ,COLATTR_DESC_TYPE_NAME
 107         ,COLATTR_DESC_UNNAMED
 108         ,COLATTR_DESC_UNSIGNED
 109         ,COLATTR_DESC_UPDATABLE
 110 };
 111
 112 /*      SQLStatistics field position    */
 113 enum {
 114         STATS_CATALOG_NAME      = 0
 115         ,STATS_SCHEMA_NAME
 116         ,STATS_TABLE_NAME
 117         ,STATS_NON_UNIQUE
 118         ,STATS_INDEX_QUALIFIER
 119         ,STATS_INDEX_NAME
 120         ,STATS_TYPE
 121         ,STATS_SEQ_IN_INDEX
 122         ,STATS_COLUMN_NAME
 123         ,STATS_COLLATION
 124         ,STATS_CARDINALITY
 125         ,STATS_PAGES
 126         ,STATS_FILTER_CONDITION
 127         ,NUM_OF_STATS_FIELDS
 128 };
 129
 130 /*      SQLProcedureColumns field position      */
 131 enum {
 132         PROCOLS_PROCEDURE_CAT   = 0
 133         ,PROCOLS_PROCEDURE_SCHEM
 134         ,PROCOLS_PROCEDURE_NAME
 135         ,PROCOLS_COLUMN_NAME
 136         ,PROCOLS_COLUMN_TYPE
 137         ,PROCOLS_DATA_TYPE
 138         ,PROCOLS_TYPE_NAME
 139         ,PROCOLS_COLUMN_SIZE
 140         ,PROCOLS_BUFFER_LENGTH
 141         ,PROCOLS_DECIMAL_DIGITS
 142         ,PROCOLS_NUM_PREC_RADIX
 143         ,PROCOLS_NULLABLE
 144         ,PROCOLS_REMARKS
 145         ,PROCOLS_COLUMN_DEF
 146         ,PROCOLS_SQL_DATA_TYPE
 147         ,PROCOLS_SQL_DATETIME_SUB
 148         ,PROCOLS_CHAR_OCTET_LENGTH
 149         ,PROCOLS_ORDINAL_POSITION
 150         ,PROCOLS_IS_NULLABLE
 151         ,NUM_OF_PROCOLS_FIELDS
 152 };
 153 #endif /* __CARFUNC_H__ */