[ Index ]

PHP Cross Reference of Unnamed Project

title

Body

[close]

/se3-unattended/var/se3/unattended/install/linuxaux/opt/perl/lib/site_perl/5.10.0/i586-linux-thread-multi/DBI/Const/GetInfo/ -> ODBC.pm (source)

   1  # $Id: ODBC.pm 11373 2008-06-02 19:01:33Z timbo $
   2  #
   3  # Copyright (c) 2002  Tim Bunce  Ireland
   4  #
   5  # Constant data describing Microsoft ODBC info types and return values
   6  # for the SQLGetInfo() method of ODBC.
   7  #
   8  # You may distribute under the terms of either the GNU General Public
   9  # License or the Artistic License, as specified in the Perl README file.
  10  
  11  package DBI::Const::GetInfo::ODBC;
  12  
  13  =head1 NAME
  14  
  15  DBI::Const::GetInfo::ODBC - ODBC Constants for GetInfo
  16  
  17  =head1 SYNOPSIS
  18  
  19   The API for this module is private and subject to change.
  20  
  21  =head1 DESCRIPTION
  22  
  23  Information requested by GetInfo().
  24  
  25  The API for this module is private and subject to change.   
  26  
  27  =head1 REFERENCES
  28  
  29    MDAC SDK 2.6
  30    ODBC version number (0x0351)
  31  
  32    sql.h
  33    sqlext.h
  34  
  35  =cut
  36  
  37  my
  38  $VERSION = sprintf("2.%06d", q$Revision: 11373 $ =~ /(\d+)/o);
  39  
  40  
  41  %InfoTypes =
  42  (
  43    SQL_ACCESSIBLE_PROCEDURES           =>    20
  44  , SQL_ACCESSIBLE_TABLES               =>    19
  45  , SQL_ACTIVE_CONNECTIONS              =>     0
  46  , SQL_ACTIVE_ENVIRONMENTS             =>   116
  47  , SQL_ACTIVE_STATEMENTS               =>     1
  48  , SQL_AGGREGATE_FUNCTIONS             =>   169
  49  , SQL_ALTER_DOMAIN                    =>   117
  50  , SQL_ALTER_TABLE                     =>    86
  51  , SQL_ASYNC_MODE                      => 10021
  52  , SQL_BATCH_ROW_COUNT                 =>   120
  53  , SQL_BATCH_SUPPORT                   =>   121
  54  , SQL_BOOKMARK_PERSISTENCE            =>    82
  55  , SQL_CATALOG_LOCATION                =>   114  # SQL_QUALIFIER_LOCATION
  56  , SQL_CATALOG_NAME                    => 10003
  57  , SQL_CATALOG_NAME_SEPARATOR          =>    41  # SQL_QUALIFIER_NAME_SEPARATOR
  58  , SQL_CATALOG_TERM                    =>    42  # SQL_QUALIFIER_TERM
  59  , SQL_CATALOG_USAGE                   =>    92  # SQL_QUALIFIER_USAGE
  60  , SQL_COLLATION_SEQ                   => 10004
  61  , SQL_COLUMN_ALIAS                    =>    87
  62  , SQL_CONCAT_NULL_BEHAVIOR            =>    22
  63  , SQL_CONVERT_BIGINT                  =>    53
  64  , SQL_CONVERT_BINARY                  =>    54
  65  , SQL_CONVERT_BIT                     =>    55
  66  , SQL_CONVERT_CHAR                    =>    56
  67  , SQL_CONVERT_DATE                    =>    57
  68  , SQL_CONVERT_DECIMAL                 =>    58
  69  , SQL_CONVERT_DOUBLE                  =>    59
  70  , SQL_CONVERT_FLOAT                   =>    60
  71  , SQL_CONVERT_FUNCTIONS               =>    48
  72  , SQL_CONVERT_GUID                    =>   173
  73  , SQL_CONVERT_INTEGER                 =>    61
  74  , SQL_CONVERT_INTERVAL_DAY_TIME       =>   123
  75  , SQL_CONVERT_INTERVAL_YEAR_MONTH     =>   124
  76  , SQL_CONVERT_LONGVARBINARY           =>    71
  77  , SQL_CONVERT_LONGVARCHAR             =>    62
  78  , SQL_CONVERT_NUMERIC                 =>    63
  79  , SQL_CONVERT_REAL                    =>    64
  80  , SQL_CONVERT_SMALLINT                =>    65
  81  , SQL_CONVERT_TIME                    =>    66
  82  , SQL_CONVERT_TIMESTAMP               =>    67
  83  , SQL_CONVERT_TINYINT                 =>    68
  84  , SQL_CONVERT_VARBINARY               =>    69
  85  , SQL_CONVERT_VARCHAR                 =>    70
  86  , SQL_CONVERT_WCHAR                   =>   122
  87  , SQL_CONVERT_WLONGVARCHAR            =>   125
  88  , SQL_CONVERT_WVARCHAR                =>   126
  89  , SQL_CORRELATION_NAME                =>    74
  90  , SQL_CREATE_ASSERTION                =>   127
  91  , SQL_CREATE_CHARACTER_SET            =>   128
  92  , SQL_CREATE_COLLATION                =>   129
  93  , SQL_CREATE_DOMAIN                   =>   130
  94  , SQL_CREATE_SCHEMA                   =>   131
  95  , SQL_CREATE_TABLE                    =>   132
  96  , SQL_CREATE_TRANSLATION              =>   133
  97  , SQL_CREATE_VIEW                     =>   134
  98  , SQL_CURSOR_COMMIT_BEHAVIOR          =>    23
  99  , SQL_CURSOR_ROLLBACK_BEHAVIOR        =>    24
 100  , SQL_CURSOR_SENSITIVITY              => 10001
 101  , SQL_DATA_SOURCE_NAME                =>     2
 102  , SQL_DATA_SOURCE_READ_ONLY           =>    25
 103  , SQL_DATABASE_NAME                   =>    16 
 104  , SQL_DATETIME_LITERALS               =>   119
 105  , SQL_DBMS_NAME                       =>    17
 106  , SQL_DBMS_VER                        =>    18
 107  , SQL_DDL_INDEX                       =>   170
 108  , SQL_DEFAULT_TXN_ISOLATION           =>    26
 109  , SQL_DESCRIBE_PARAMETER              => 10002
 110  , SQL_DM_VER                          =>   171
 111  , SQL_DRIVER_HDBC                     =>     3
 112  , SQL_DRIVER_HDESC                    =>   135
 113  , SQL_DRIVER_HENV                     =>     4
 114  , SQL_DRIVER_HLIB                     =>    76
 115  , SQL_DRIVER_HSTMT                    =>     5
 116  , SQL_DRIVER_NAME                     =>     6
 117  , SQL_DRIVER_ODBC_VER                 =>    77
 118  , SQL_DRIVER_VER                      =>     7
 119  , SQL_DROP_ASSERTION                  =>   136
 120  , SQL_DROP_CHARACTER_SET              =>   137
 121  , SQL_DROP_COLLATION                  =>   138
 122  , SQL_DROP_DOMAIN                     =>   139
 123  , SQL_DROP_SCHEMA                     =>   140
 124  , SQL_DROP_TABLE                      =>   141
 125  , SQL_DROP_TRANSLATION                =>   142
 126  , SQL_DROP_VIEW                       =>   143
 127  , SQL_DYNAMIC_CURSOR_ATTRIBUTES1      =>   144
 128  , SQL_DYNAMIC_CURSOR_ATTRIBUTES2      =>   145
 129  , SQL_EXPRESSIONS_IN_ORDERBY          =>    27
 130  , SQL_FETCH_DIRECTION                 =>     8
 131  , SQL_FILE_USAGE                      =>    84
 132  , SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES1 =>   146
 133  , SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES2 =>   147
 134  , SQL_GETDATA_EXTENSIONS              =>    81
 135  , SQL_GROUP_BY                        =>    88
 136  , SQL_IDENTIFIER_CASE                 =>    28
 137  , SQL_IDENTIFIER_QUOTE_CHAR           =>    29
 138  , SQL_INDEX_KEYWORDS                  =>   148
 139  # SQL_INFO_DRIVER_START               =>  1000
 140  # SQL_INFO_FIRST                      =>     0
 141  # SQL_INFO_LAST                       =>   114  # SQL_QUALIFIER_LOCATION
 142  , SQL_INFO_SCHEMA_VIEWS               =>   149
 143  , SQL_INSERT_STATEMENT                =>   172
 144  , SQL_INTEGRITY                       =>    73
 145  , SQL_KEYSET_CURSOR_ATTRIBUTES1       =>   150
 146  , SQL_KEYSET_CURSOR_ATTRIBUTES2       =>   151
 147  , SQL_KEYWORDS                        =>    89
 148  , SQL_LIKE_ESCAPE_CLAUSE              =>   113
 149  , SQL_LOCK_TYPES                      =>    78
 150  , SQL_MAXIMUM_CATALOG_NAME_LENGTH     =>    34  # SQL_MAX_CATALOG_NAME_LEN
 151  , SQL_MAXIMUM_COLUMNS_IN_GROUP_BY     =>    97  # SQL_MAX_COLUMNS_IN_GROUP_BY
 152  , SQL_MAXIMUM_COLUMNS_IN_INDEX        =>    98  # SQL_MAX_COLUMNS_IN_INDEX
 153  , SQL_MAXIMUM_COLUMNS_IN_ORDER_BY     =>    99  # SQL_MAX_COLUMNS_IN_ORDER_BY
 154  , SQL_MAXIMUM_COLUMNS_IN_SELECT       =>   100  # SQL_MAX_COLUMNS_IN_SELECT
 155  , SQL_MAXIMUM_COLUMN_NAME_LENGTH      =>    30  # SQL_MAX_COLUMN_NAME_LEN
 156  , SQL_MAXIMUM_CONCURRENT_ACTIVITIES   =>     1  # SQL_MAX_CONCURRENT_ACTIVITIES
 157  , SQL_MAXIMUM_CURSOR_NAME_LENGTH      =>    31  # SQL_MAX_CURSOR_NAME_LEN
 158  , SQL_MAXIMUM_DRIVER_CONNECTIONS      =>     0  # SQL_MAX_DRIVER_CONNECTIONS
 159  , SQL_MAXIMUM_IDENTIFIER_LENGTH       => 10005  # SQL_MAX_IDENTIFIER_LEN
 160  , SQL_MAXIMUM_INDEX_SIZE              =>   102  # SQL_MAX_INDEX_SIZE
 161  , SQL_MAXIMUM_ROW_SIZE                =>   104  # SQL_MAX_ROW_SIZE
 162  , SQL_MAXIMUM_SCHEMA_NAME_LENGTH      =>    32  # SQL_MAX_SCHEMA_NAME_LEN
 163  , SQL_MAXIMUM_STATEMENT_LENGTH        =>   105  # SQL_MAX_STATEMENT_LEN
 164  , SQL_MAXIMUM_TABLES_IN_SELECT        =>   106  # SQL_MAX_TABLES_IN_SELECT
 165  , SQL_MAXIMUM_USER_NAME_LENGTH        =>   107  # SQL_MAX_USER_NAME_LEN
 166  , SQL_MAX_ASYNC_CONCURRENT_STATEMENTS => 10022
 167  , SQL_MAX_BINARY_LITERAL_LEN          =>   112
 168  , SQL_MAX_CATALOG_NAME_LEN            =>    34
 169  , SQL_MAX_CHAR_LITERAL_LEN            =>   108
 170  , SQL_MAX_COLUMNS_IN_GROUP_BY         =>    97
 171  , SQL_MAX_COLUMNS_IN_INDEX            =>    98
 172  , SQL_MAX_COLUMNS_IN_ORDER_BY         =>    99
 173  , SQL_MAX_COLUMNS_IN_SELECT           =>   100
 174  , SQL_MAX_COLUMNS_IN_TABLE            =>   101
 175  , SQL_MAX_COLUMN_NAME_LEN             =>    30
 176  , SQL_MAX_CONCURRENT_ACTIVITIES       =>     1
 177  , SQL_MAX_CURSOR_NAME_LEN             =>    31
 178  , SQL_MAX_DRIVER_CONNECTIONS          =>     0
 179  , SQL_MAX_IDENTIFIER_LEN              => 10005
 180  , SQL_MAX_INDEX_SIZE                  =>   102
 181  , SQL_MAX_OWNER_NAME_LEN              =>    32
 182  , SQL_MAX_PROCEDURE_NAME_LEN          =>    33
 183  , SQL_MAX_QUALIFIER_NAME_LEN          =>    34
 184  , SQL_MAX_ROW_SIZE                    =>   104
 185  , SQL_MAX_ROW_SIZE_INCLUDES_LONG      =>   103
 186  , SQL_MAX_SCHEMA_NAME_LEN             =>    32
 187  , SQL_MAX_STATEMENT_LEN               =>   105
 188  , SQL_MAX_TABLES_IN_SELECT            =>   106
 189  , SQL_MAX_TABLE_NAME_LEN              =>    35
 190  , SQL_MAX_USER_NAME_LEN               =>   107
 191  , SQL_MULTIPLE_ACTIVE_TXN             =>    37
 192  , SQL_MULT_RESULT_SETS                =>    36
 193  , SQL_NEED_LONG_DATA_LEN              =>   111
 194  , SQL_NON_NULLABLE_COLUMNS            =>    75
 195  , SQL_NULL_COLLATION                  =>    85
 196  , SQL_NUMERIC_FUNCTIONS               =>    49
 197  , SQL_ODBC_API_CONFORMANCE            =>     9
 198  , SQL_ODBC_INTERFACE_CONFORMANCE      =>   152
 199  , SQL_ODBC_SAG_CLI_CONFORMANCE        =>    12
 200  , SQL_ODBC_SQL_CONFORMANCE            =>    15
 201  , SQL_ODBC_SQL_OPT_IEF                =>    73
 202  , SQL_ODBC_VER                        =>    10
 203  , SQL_OJ_CAPABILITIES                 =>   115
 204  , SQL_ORDER_BY_COLUMNS_IN_SELECT      =>    90
 205  , SQL_OUTER_JOINS                     =>    38
 206  , SQL_OUTER_JOIN_CAPABILITIES         =>   115  # SQL_OJ_CAPABILITIES
 207  , SQL_OWNER_TERM                      =>    39
 208  , SQL_OWNER_USAGE                     =>    91
 209  , SQL_PARAM_ARRAY_ROW_COUNTS          =>   153
 210  , SQL_PARAM_ARRAY_SELECTS             =>   154
 211  , SQL_POSITIONED_STATEMENTS           =>    80
 212  , SQL_POS_OPERATIONS                  =>    79
 213  , SQL_PROCEDURES                      =>    21
 214  , SQL_PROCEDURE_TERM                  =>    40
 215  , SQL_QUALIFIER_LOCATION              =>   114
 216  , SQL_QUALIFIER_NAME_SEPARATOR        =>    41
 217  , SQL_QUALIFIER_TERM                  =>    42
 218  , SQL_QUALIFIER_USAGE                 =>    92
 219  , SQL_QUOTED_IDENTIFIER_CASE          =>    93
 220  , SQL_ROW_UPDATES                     =>    11
 221  , SQL_SCHEMA_TERM                     =>    39  # SQL_OWNER_TERM
 222  , SQL_SCHEMA_USAGE                    =>    91  # SQL_OWNER_USAGE
 223  , SQL_SCROLL_CONCURRENCY              =>    43
 224  , SQL_SCROLL_OPTIONS                  =>    44
 225  , SQL_SEARCH_PATTERN_ESCAPE           =>    14
 226  , SQL_SERVER_NAME                     =>    13
 227  , SQL_SPECIAL_CHARACTERS              =>    94
 228  , SQL_SQL92_DATETIME_FUNCTIONS        =>   155
 229  , SQL_SQL92_FOREIGN_KEY_DELETE_RULE   =>   156
 230  , SQL_SQL92_FOREIGN_KEY_UPDATE_RULE   =>   157
 231  , SQL_SQL92_GRANT                     =>   158
 232  , SQL_SQL92_NUMERIC_VALUE_FUNCTIONS   =>   159
 233  , SQL_SQL92_PREDICATES                =>   160
 234  , SQL_SQL92_RELATIONAL_JOIN_OPERATORS =>   161
 235  , SQL_SQL92_REVOKE                    =>   162
 236  , SQL_SQL92_ROW_VALUE_CONSTRUCTOR     =>   163
 237  , SQL_SQL92_STRING_FUNCTIONS          =>   164
 238  , SQL_SQL92_VALUE_EXPRESSIONS         =>   165
 239  , SQL_SQL_CONFORMANCE                 =>   118
 240  , SQL_STANDARD_CLI_CONFORMANCE        =>   166
 241  , SQL_STATIC_CURSOR_ATTRIBUTES1       =>   167
 242  , SQL_STATIC_CURSOR_ATTRIBUTES2       =>   168
 243  , SQL_STATIC_SENSITIVITY              =>    83
 244  , SQL_STRING_FUNCTIONS                =>    50
 245  , SQL_SUBQUERIES                      =>    95
 246  , SQL_SYSTEM_FUNCTIONS                =>    51
 247  , SQL_TABLE_TERM                      =>    45
 248  , SQL_TIMEDATE_ADD_INTERVALS          =>   109
 249  , SQL_TIMEDATE_DIFF_INTERVALS         =>   110
 250  , SQL_TIMEDATE_FUNCTIONS              =>    52
 251  , SQL_TRANSACTION_CAPABLE             =>    46  # SQL_TXN_CAPABLE
 252  , SQL_TRANSACTION_ISOLATION_OPTION    =>    72  # SQL_TXN_ISOLATION_OPTION
 253  , SQL_TXN_CAPABLE                     =>    46
 254  , SQL_TXN_ISOLATION_OPTION            =>    72
 255  , SQL_UNION                           =>    96
 256  , SQL_UNION_STATEMENT                 =>    96  # SQL_UNION
 257  , SQL_USER_NAME                       =>    47
 258  , SQL_XOPEN_CLI_YEAR                  => 10000
 259  );
 260  
 261  =head2 %ReturnTypes
 262  
 263  See: mk:@MSITStore:X:\dm\cli\mdac\sdk26\Docs\odbc.chm::/htm/odbcsqlgetinfo.htm
 264  
 265    =>     : alias
 266    => !!! : edited
 267  
 268  =cut
 269  
 270  %ReturnTypes =
 271  (
 272    SQL_ACCESSIBLE_PROCEDURES           => 'SQLCHAR'             #    20
 273  , SQL_ACCESSIBLE_TABLES               => 'SQLCHAR'             #    19
 274  , SQL_ACTIVE_CONNECTIONS              => 'SQLUSMALLINT'        #     0  =>
 275  , SQL_ACTIVE_ENVIRONMENTS             => 'SQLUSMALLINT'        #   116
 276  , SQL_ACTIVE_STATEMENTS               => 'SQLUSMALLINT'        #     1  =>
 277  , SQL_AGGREGATE_FUNCTIONS             => 'SQLUINTEGER bitmask' #   169
 278  , SQL_ALTER_DOMAIN                    => 'SQLUINTEGER bitmask' #   117
 279  , SQL_ALTER_TABLE                     => 'SQLUINTEGER bitmask' #    86
 280  , SQL_ASYNC_MODE                      => 'SQLUINTEGER'         # 10021
 281  , SQL_BATCH_ROW_COUNT                 => 'SQLUINTEGER bitmask' #   120
 282  , SQL_BATCH_SUPPORT                   => 'SQLUINTEGER bitmask' #   121
 283  , SQL_BOOKMARK_PERSISTENCE            => 'SQLUINTEGER bitmask' #    82
 284  , SQL_CATALOG_LOCATION                => 'SQLUSMALLINT'        #   114
 285  , SQL_CATALOG_NAME                    => 'SQLCHAR'             # 10003
 286  , SQL_CATALOG_NAME_SEPARATOR          => 'SQLCHAR'             #    41
 287  , SQL_CATALOG_TERM                    => 'SQLCHAR'             #    42
 288  , SQL_CATALOG_USAGE                   => 'SQLUINTEGER bitmask' #    92
 289  , SQL_COLLATION_SEQ                   => 'SQLCHAR'             # 10004
 290  , SQL_COLUMN_ALIAS                    => 'SQLCHAR'             #    87
 291  , SQL_CONCAT_NULL_BEHAVIOR            => 'SQLUSMALLINT'        #    22
 292  , SQL_CONVERT_BIGINT                  => 'SQLUINTEGER bitmask' #    53
 293  , SQL_CONVERT_BINARY                  => 'SQLUINTEGER bitmask' #    54
 294  , SQL_CONVERT_BIT                     => 'SQLUINTEGER bitmask' #    55
 295  , SQL_CONVERT_CHAR                    => 'SQLUINTEGER bitmask' #    56
 296  , SQL_CONVERT_DATE                    => 'SQLUINTEGER bitmask' #    57
 297  , SQL_CONVERT_DECIMAL                 => 'SQLUINTEGER bitmask' #    58
 298  , SQL_CONVERT_DOUBLE                  => 'SQLUINTEGER bitmask' #    59
 299  , SQL_CONVERT_FLOAT                   => 'SQLUINTEGER bitmask' #    60
 300  , SQL_CONVERT_FUNCTIONS               => 'SQLUINTEGER bitmask' #    48
 301  , SQL_CONVERT_GUID                    => 'SQLUINTEGER bitmask' #   173
 302  , SQL_CONVERT_INTEGER                 => 'SQLUINTEGER bitmask' #    61
 303  , SQL_CONVERT_INTERVAL_DAY_TIME       => 'SQLUINTEGER bitmask' #   123
 304  , SQL_CONVERT_INTERVAL_YEAR_MONTH     => 'SQLUINTEGER bitmask' #   124
 305  , SQL_CONVERT_LONGVARBINARY           => 'SQLUINTEGER bitmask' #    71
 306  , SQL_CONVERT_LONGVARCHAR             => 'SQLUINTEGER bitmask' #    62
 307  , SQL_CONVERT_NUMERIC                 => 'SQLUINTEGER bitmask' #    63
 308  , SQL_CONVERT_REAL                    => 'SQLUINTEGER bitmask' #    64
 309  , SQL_CONVERT_SMALLINT                => 'SQLUINTEGER bitmask' #    65
 310  , SQL_CONVERT_TIME                    => 'SQLUINTEGER bitmask' #    66
 311  , SQL_CONVERT_TIMESTAMP               => 'SQLUINTEGER bitmask' #    67
 312  , SQL_CONVERT_TINYINT                 => 'SQLUINTEGER bitmask' #    68
 313  , SQL_CONVERT_VARBINARY               => 'SQLUINTEGER bitmask' #    69
 314  , SQL_CONVERT_VARCHAR                 => 'SQLUINTEGER bitmask' #    70
 315  , SQL_CONVERT_WCHAR                   => 'SQLUINTEGER bitmask' #   122  => !!!
 316  , SQL_CONVERT_WLONGVARCHAR            => 'SQLUINTEGER bitmask' #   125  => !!!
 317  , SQL_CONVERT_WVARCHAR                => 'SQLUINTEGER bitmask' #   126  => !!!
 318  , SQL_CORRELATION_NAME                => 'SQLUSMALLINT'        #    74
 319  , SQL_CREATE_ASSERTION                => 'SQLUINTEGER bitmask' #   127
 320  , SQL_CREATE_CHARACTER_SET            => 'SQLUINTEGER bitmask' #   128
 321  , SQL_CREATE_COLLATION                => 'SQLUINTEGER bitmask' #   129
 322  , SQL_CREATE_DOMAIN                   => 'SQLUINTEGER bitmask' #   130
 323  , SQL_CREATE_SCHEMA                   => 'SQLUINTEGER bitmask' #   131
 324  , SQL_CREATE_TABLE                    => 'SQLUINTEGER bitmask' #   132
 325  , SQL_CREATE_TRANSLATION              => 'SQLUINTEGER bitmask' #   133
 326  , SQL_CREATE_VIEW                     => 'SQLUINTEGER bitmask' #   134
 327  , SQL_CURSOR_COMMIT_BEHAVIOR          => 'SQLUSMALLINT'        #    23
 328  , SQL_CURSOR_ROLLBACK_BEHAVIOR        => 'SQLUSMALLINT'        #    24
 329  , SQL_CURSOR_SENSITIVITY              => 'SQLUINTEGER'         # 10001
 330  , SQL_DATA_SOURCE_NAME                => 'SQLCHAR'             #     2
 331  , SQL_DATA_SOURCE_READ_ONLY           => 'SQLCHAR'             #    25
 332  , SQL_DATABASE_NAME                   => 'SQLCHAR'             #    16 
 333  , SQL_DATETIME_LITERALS               => 'SQLUINTEGER bitmask' #   119
 334  , SQL_DBMS_NAME                       => 'SQLCHAR'             #    17
 335  , SQL_DBMS_VER                        => 'SQLCHAR'             #    18
 336  , SQL_DDL_INDEX                       => 'SQLUINTEGER bitmask' #   170
 337  , SQL_DEFAULT_TXN_ISOLATION           => 'SQLUINTEGER'         #    26
 338  , SQL_DESCRIBE_PARAMETER              => 'SQLCHAR'             # 10002
 339  , SQL_DM_VER                          => 'SQLCHAR'             #   171
 340  , SQL_DRIVER_HDBC                     => 'SQLUINTEGER'         #     3
 341  , SQL_DRIVER_HDESC                    => 'SQLUINTEGER'         #   135
 342  , SQL_DRIVER_HENV                     => 'SQLUINTEGER'         #     4
 343  , SQL_DRIVER_HLIB                     => 'SQLUINTEGER'         #    76
 344  , SQL_DRIVER_HSTMT                    => 'SQLUINTEGER'         #     5
 345  , SQL_DRIVER_NAME                     => 'SQLCHAR'             #     6
 346  , SQL_DRIVER_ODBC_VER                 => 'SQLCHAR'             #    77
 347  , SQL_DRIVER_VER                      => 'SQLCHAR'             #     7
 348  , SQL_DROP_ASSERTION                  => 'SQLUINTEGER bitmask' #   136
 349  , SQL_DROP_CHARACTER_SET              => 'SQLUINTEGER bitmask' #   137
 350  , SQL_DROP_COLLATION                  => 'SQLUINTEGER bitmask' #   138
 351  , SQL_DROP_DOMAIN                     => 'SQLUINTEGER bitmask' #   139
 352  , SQL_DROP_SCHEMA                     => 'SQLUINTEGER bitmask' #   140
 353  , SQL_DROP_TABLE                      => 'SQLUINTEGER bitmask' #   141
 354  , SQL_DROP_TRANSLATION                => 'SQLUINTEGER bitmask' #   142
 355  , SQL_DROP_VIEW                       => 'SQLUINTEGER bitmask' #   143
 356  , SQL_DYNAMIC_CURSOR_ATTRIBUTES1      => 'SQLUINTEGER bitmask' #   144
 357  , SQL_DYNAMIC_CURSOR_ATTRIBUTES2      => 'SQLUINTEGER bitmask' #   145
 358  , SQL_EXPRESSIONS_IN_ORDERBY          => 'SQLCHAR'             #    27
 359  , SQL_FETCH_DIRECTION                 => 'SQLUINTEGER bitmask' #     8  => !!!
 360  , SQL_FILE_USAGE                      => 'SQLUSMALLINT'        #    84
 361  , SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES1 => 'SQLUINTEGER bitmask' #   146
 362  , SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES2 => 'SQLUINTEGER bitmask' #   147
 363  , SQL_GETDATA_EXTENSIONS              => 'SQLUINTEGER bitmask' #    81
 364  , SQL_GROUP_BY                        => 'SQLUSMALLINT'        #    88
 365  , SQL_IDENTIFIER_CASE                 => 'SQLUSMALLINT'        #    28
 366  , SQL_IDENTIFIER_QUOTE_CHAR           => 'SQLCHAR'             #    29
 367  , SQL_INDEX_KEYWORDS                  => 'SQLUINTEGER bitmask' #   148
 368  # SQL_INFO_DRIVER_START               => ''                    #  1000  =>
 369  # SQL_INFO_FIRST                      => 'SQLUSMALLINT'        #     0  =>
 370  # SQL_INFO_LAST                       => 'SQLUSMALLINT'        #   114  =>
 371  , SQL_INFO_SCHEMA_VIEWS               => 'SQLUINTEGER bitmask' #   149
 372  , SQL_INSERT_STATEMENT                => 'SQLUINTEGER bitmask' #   172
 373  , SQL_INTEGRITY                       => 'SQLCHAR'             #    73
 374  , SQL_KEYSET_CURSOR_ATTRIBUTES1       => 'SQLUINTEGER bitmask' #   150
 375  , SQL_KEYSET_CURSOR_ATTRIBUTES2       => 'SQLUINTEGER bitmask' #   151
 376  , SQL_KEYWORDS                        => 'SQLCHAR'             #    89
 377  , SQL_LIKE_ESCAPE_CLAUSE              => 'SQLCHAR'             #   113
 378  , SQL_LOCK_TYPES                      => 'SQLUINTEGER bitmask' #    78  => !!!
 379  , SQL_MAXIMUM_CATALOG_NAME_LENGTH     => 'SQLUSMALLINT'        #    34  =>
 380  , SQL_MAXIMUM_COLUMNS_IN_GROUP_BY     => 'SQLUSMALLINT'        #    97  =>
 381  , SQL_MAXIMUM_COLUMNS_IN_INDEX        => 'SQLUSMALLINT'        #    98  =>
 382  , SQL_MAXIMUM_COLUMNS_IN_ORDER_BY     => 'SQLUSMALLINT'        #    99  =>
 383  , SQL_MAXIMUM_COLUMNS_IN_SELECT       => 'SQLUSMALLINT'        #   100  =>
 384  , SQL_MAXIMUM_COLUMN_NAME_LENGTH      => 'SQLUSMALLINT'        #    30  =>
 385  , SQL_MAXIMUM_CONCURRENT_ACTIVITIES   => 'SQLUSMALLINT'        #     1  =>
 386  , SQL_MAXIMUM_CURSOR_NAME_LENGTH      => 'SQLUSMALLINT'        #    31  =>
 387  , SQL_MAXIMUM_DRIVER_CONNECTIONS      => 'SQLUSMALLINT'        #     0  =>
 388  , SQL_MAXIMUM_IDENTIFIER_LENGTH       => 'SQLUSMALLINT'        # 10005  =>
 389  , SQL_MAXIMUM_INDEX_SIZE              => 'SQLUINTEGER'         #   102  =>
 390  , SQL_MAXIMUM_ROW_SIZE                => 'SQLUINTEGER'         #   104  =>
 391  , SQL_MAXIMUM_SCHEMA_NAME_LENGTH      => 'SQLUSMALLINT'        #    32  =>
 392  , SQL_MAXIMUM_STATEMENT_LENGTH        => 'SQLUINTEGER'         #   105  =>
 393  , SQL_MAXIMUM_TABLES_IN_SELECT        => 'SQLUSMALLINT'        #   106  =>
 394  , SQL_MAXIMUM_USER_NAME_LENGTH        => 'SQLUSMALLINT'        #   107  =>
 395  , SQL_MAX_ASYNC_CONCURRENT_STATEMENTS => 'SQLUINTEGER'         # 10022
 396  , SQL_MAX_BINARY_LITERAL_LEN          => 'SQLUINTEGER'         #   112
 397  , SQL_MAX_CATALOG_NAME_LEN            => 'SQLUSMALLINT'        #    34
 398  , SQL_MAX_CHAR_LITERAL_LEN            => 'SQLUINTEGER'         #   108
 399  , SQL_MAX_COLUMNS_IN_GROUP_BY         => 'SQLUSMALLINT'        #    97
 400  , SQL_MAX_COLUMNS_IN_INDEX            => 'SQLUSMALLINT'        #    98
 401  , SQL_MAX_COLUMNS_IN_ORDER_BY         => 'SQLUSMALLINT'        #    99
 402  , SQL_MAX_COLUMNS_IN_SELECT           => 'SQLUSMALLINT'        #   100
 403  , SQL_MAX_COLUMNS_IN_TABLE            => 'SQLUSMALLINT'        #   101
 404  , SQL_MAX_COLUMN_NAME_LEN             => 'SQLUSMALLINT'        #    30
 405  , SQL_MAX_CONCURRENT_ACTIVITIES       => 'SQLUSMALLINT'        #     1
 406  , SQL_MAX_CURSOR_NAME_LEN             => 'SQLUSMALLINT'        #    31
 407  , SQL_MAX_DRIVER_CONNECTIONS          => 'SQLUSMALLINT'        #     0
 408  , SQL_MAX_IDENTIFIER_LEN              => 'SQLUSMALLINT'        # 10005
 409  , SQL_MAX_INDEX_SIZE                  => 'SQLUINTEGER'         #   102
 410  , SQL_MAX_OWNER_NAME_LEN              => 'SQLUSMALLINT'        #    32  =>
 411  , SQL_MAX_PROCEDURE_NAME_LEN          => 'SQLUSMALLINT'        #    33
 412  , SQL_MAX_QUALIFIER_NAME_LEN          => 'SQLUSMALLINT'        #    34  =>
 413  , SQL_MAX_ROW_SIZE                    => 'SQLUINTEGER'         #   104
 414  , SQL_MAX_ROW_SIZE_INCLUDES_LONG      => 'SQLCHAR'             #   103
 415  , SQL_MAX_SCHEMA_NAME_LEN             => 'SQLUSMALLINT'        #    32
 416  , SQL_MAX_STATEMENT_LEN               => 'SQLUINTEGER'         #   105
 417  , SQL_MAX_TABLES_IN_SELECT            => 'SQLUSMALLINT'        #   106
 418  , SQL_MAX_TABLE_NAME_LEN              => 'SQLUSMALLINT'        #    35
 419  , SQL_MAX_USER_NAME_LEN               => 'SQLUSMALLINT'        #   107
 420  , SQL_MULTIPLE_ACTIVE_TXN             => 'SQLCHAR'             #    37
 421  , SQL_MULT_RESULT_SETS                => 'SQLCHAR'             #    36
 422  , SQL_NEED_LONG_DATA_LEN              => 'SQLCHAR'             #   111
 423  , SQL_NON_NULLABLE_COLUMNS            => 'SQLUSMALLINT'        #    75
 424  , SQL_NULL_COLLATION                  => 'SQLUSMALLINT'        #    85
 425  , SQL_NUMERIC_FUNCTIONS               => 'SQLUINTEGER bitmask' #    49
 426  , SQL_ODBC_API_CONFORMANCE            => 'SQLUSMALLINT'        #     9  => !!!
 427  , SQL_ODBC_INTERFACE_CONFORMANCE      => 'SQLUINTEGER'         #   152
 428  , SQL_ODBC_SAG_CLI_CONFORMANCE        => 'SQLUSMALLINT'        #    12  => !!!
 429  , SQL_ODBC_SQL_CONFORMANCE            => 'SQLUSMALLINT'        #    15  => !!!
 430  , SQL_ODBC_SQL_OPT_IEF                => 'SQLCHAR'             #    73  =>
 431  , SQL_ODBC_VER                        => 'SQLCHAR'             #    10
 432  , SQL_OJ_CAPABILITIES                 => 'SQLUINTEGER bitmask' #   115
 433  , SQL_ORDER_BY_COLUMNS_IN_SELECT      => 'SQLCHAR'             #    90
 434  , SQL_OUTER_JOINS                     => 'SQLCHAR'             #    38  => !!!
 435  , SQL_OUTER_JOIN_CAPABILITIES         => 'SQLUINTEGER bitmask' #   115  =>
 436  , SQL_OWNER_TERM                      => 'SQLCHAR'             #    39  =>
 437  , SQL_OWNER_USAGE                     => 'SQLUINTEGER bitmask' #    91  =>
 438  , SQL_PARAM_ARRAY_ROW_COUNTS          => 'SQLUINTEGER'         #   153
 439  , SQL_PARAM_ARRAY_SELECTS             => 'SQLUINTEGER'         #   154
 440  , SQL_POSITIONED_STATEMENTS           => 'SQLUINTEGER bitmask' #    80  => !!!
 441  , SQL_POS_OPERATIONS                  => 'SQLINTEGER bitmask'  #    79
 442  , SQL_PROCEDURES                      => 'SQLCHAR'             #    21
 443  , SQL_PROCEDURE_TERM                  => 'SQLCHAR'             #    40
 444  , SQL_QUALIFIER_LOCATION              => 'SQLUSMALLINT'        #   114  =>
 445  , SQL_QUALIFIER_NAME_SEPARATOR        => 'SQLCHAR'             #    41  =>
 446  , SQL_QUALIFIER_TERM                  => 'SQLCHAR'             #    42  =>
 447  , SQL_QUALIFIER_USAGE                 => 'SQLUINTEGER bitmask' #    92  =>
 448  , SQL_QUOTED_IDENTIFIER_CASE          => 'SQLUSMALLINT'        #    93
 449  , SQL_ROW_UPDATES                     => 'SQLCHAR'             #    11
 450  , SQL_SCHEMA_TERM                     => 'SQLCHAR'             #    39
 451  , SQL_SCHEMA_USAGE                    => 'SQLUINTEGER bitmask' #    91
 452  , SQL_SCROLL_CONCURRENCY              => 'SQLUINTEGER bitmask' #    43  => !!!
 453  , SQL_SCROLL_OPTIONS                  => 'SQLUINTEGER bitmask' #    44
 454  , SQL_SEARCH_PATTERN_ESCAPE           => 'SQLCHAR'             #    14
 455  , SQL_SERVER_NAME                     => 'SQLCHAR'             #    13
 456  , SQL_SPECIAL_CHARACTERS              => 'SQLCHAR'             #    94
 457  , SQL_SQL92_DATETIME_FUNCTIONS        => 'SQLUINTEGER bitmask' #   155
 458  , SQL_SQL92_FOREIGN_KEY_DELETE_RULE   => 'SQLUINTEGER bitmask' #   156
 459  , SQL_SQL92_FOREIGN_KEY_UPDATE_RULE   => 'SQLUINTEGER bitmask' #   157
 460  , SQL_SQL92_GRANT                     => 'SQLUINTEGER bitmask' #   158
 461  , SQL_SQL92_NUMERIC_VALUE_FUNCTIONS   => 'SQLUINTEGER bitmask' #   159
 462  , SQL_SQL92_PREDICATES                => 'SQLUINTEGER bitmask' #   160
 463  , SQL_SQL92_RELATIONAL_JOIN_OPERATORS => 'SQLUINTEGER bitmask' #   161
 464  , SQL_SQL92_REVOKE                    => 'SQLUINTEGER bitmask' #   162
 465  , SQL_SQL92_ROW_VALUE_CONSTRUCTOR     => 'SQLUINTEGER bitmask' #   163
 466  , SQL_SQL92_STRING_FUNCTIONS          => 'SQLUINTEGER bitmask' #   164
 467  , SQL_SQL92_VALUE_EXPRESSIONS         => 'SQLUINTEGER bitmask' #   165
 468  , SQL_SQL_CONFORMANCE                 => 'SQLUINTEGER'         #   118
 469  , SQL_STANDARD_CLI_CONFORMANCE        => 'SQLUINTEGER bitmask' #   166
 470  , SQL_STATIC_CURSOR_ATTRIBUTES1       => 'SQLUINTEGER bitmask' #   167
 471  , SQL_STATIC_CURSOR_ATTRIBUTES2       => 'SQLUINTEGER bitmask' #   168
 472  , SQL_STATIC_SENSITIVITY              => 'SQLUINTEGER bitmask' #    83  => !!!
 473  , SQL_STRING_FUNCTIONS                => 'SQLUINTEGER bitmask' #    50
 474  , SQL_SUBQUERIES                      => 'SQLUINTEGER bitmask' #    95
 475  , SQL_SYSTEM_FUNCTIONS                => 'SQLUINTEGER bitmask' #    51
 476  , SQL_TABLE_TERM                      => 'SQLCHAR'             #    45
 477  , SQL_TIMEDATE_ADD_INTERVALS          => 'SQLUINTEGER bitmask' #   109
 478  , SQL_TIMEDATE_DIFF_INTERVALS         => 'SQLUINTEGER bitmask' #   110
 479  , SQL_TIMEDATE_FUNCTIONS              => 'SQLUINTEGER bitmask' #    52
 480  , SQL_TRANSACTION_CAPABLE             => 'SQLUSMALLINT'        #    46  =>
 481  , SQL_TRANSACTION_ISOLATION_OPTION    => 'SQLUINTEGER bitmask' #    72  =>
 482  , SQL_TXN_CAPABLE                     => 'SQLUSMALLINT'        #    46
 483  , SQL_TXN_ISOLATION_OPTION            => 'SQLUINTEGER bitmask' #    72
 484  , SQL_UNION                           => 'SQLUINTEGER bitmask' #    96
 485  , SQL_UNION_STATEMENT                 => 'SQLUINTEGER bitmask' #    96  =>
 486  , SQL_USER_NAME                       => 'SQLCHAR'             #    47
 487  , SQL_XOPEN_CLI_YEAR                  => 'SQLCHAR'             # 10000
 488  );
 489  
 490  =head2 %ReturnValues
 491  
 492  See: sql.h, sqlext.h
 493  Edited:
 494    SQL_TXN_ISOLATION_OPTION
 495  
 496  =cut
 497  
 498  $ReturnValues{SQL_AGGREGATE_FUNCTIONS} =
 499  {
 500    SQL_AF_AVG                                => 0x00000001
 501  , SQL_AF_COUNT                              => 0x00000002
 502  , SQL_AF_MAX                                => 0x00000004
 503  , SQL_AF_MIN                                => 0x00000008
 504  , SQL_AF_SUM                                => 0x00000010
 505  , SQL_AF_DISTINCT                           => 0x00000020
 506  , SQL_AF_ALL                                => 0x00000040
 507  };
 508  $ReturnValues{SQL_ALTER_DOMAIN} =
 509  {
 510    SQL_AD_CONSTRAINT_NAME_DEFINITION         => 0x00000001
 511  , SQL_AD_ADD_DOMAIN_CONSTRAINT              => 0x00000002
 512  , SQL_AD_DROP_DOMAIN_CONSTRAINT             => 0x00000004
 513  , SQL_AD_ADD_DOMAIN_DEFAULT                 => 0x00000008
 514  , SQL_AD_DROP_DOMAIN_DEFAULT                => 0x00000010
 515  , SQL_AD_ADD_CONSTRAINT_INITIALLY_DEFERRED  => 0x00000020
 516  , SQL_AD_ADD_CONSTRAINT_INITIALLY_IMMEDIATE => 0x00000040
 517  , SQL_AD_ADD_CONSTRAINT_DEFERRABLE          => 0x00000080
 518  , SQL_AD_ADD_CONSTRAINT_NON_DEFERRABLE      => 0x00000100
 519  };
 520  $ReturnValues{SQL_ALTER_TABLE} =
 521  {
 522    SQL_AT_ADD_COLUMN                         => 0x00000001
 523  , SQL_AT_DROP_COLUMN                        => 0x00000002
 524  , SQL_AT_ADD_CONSTRAINT                     => 0x00000008
 525  , SQL_AT_ADD_COLUMN_SINGLE                  => 0x00000020
 526  , SQL_AT_ADD_COLUMN_DEFAULT                 => 0x00000040
 527  , SQL_AT_ADD_COLUMN_COLLATION               => 0x00000080
 528  , SQL_AT_SET_COLUMN_DEFAULT                 => 0x00000100
 529  , SQL_AT_DROP_COLUMN_DEFAULT                => 0x00000200
 530  , SQL_AT_DROP_COLUMN_CASCADE                => 0x00000400
 531  , SQL_AT_DROP_COLUMN_RESTRICT               => 0x00000800
 532  , SQL_AT_ADD_TABLE_CONSTRAINT               => 0x00001000
 533  , SQL_AT_DROP_TABLE_CONSTRAINT_CASCADE      => 0x00002000
 534  , SQL_AT_DROP_TABLE_CONSTRAINT_RESTRICT     => 0x00004000
 535  , SQL_AT_CONSTRAINT_NAME_DEFINITION         => 0x00008000
 536  , SQL_AT_CONSTRAINT_INITIALLY_DEFERRED      => 0x00010000
 537  , SQL_AT_CONSTRAINT_INITIALLY_IMMEDIATE     => 0x00020000
 538  , SQL_AT_CONSTRAINT_DEFERRABLE              => 0x00040000
 539  , SQL_AT_CONSTRAINT_NON_DEFERRABLE          => 0x00080000
 540  };
 541  $ReturnValues{SQL_ASYNC_MODE} =
 542  {
 543    SQL_AM_NONE                               => 0
 544  , SQL_AM_CONNECTION                         => 1
 545  , SQL_AM_STATEMENT                          => 2
 546  };
 547  $ReturnValues{SQL_ATTR_MAX_ROWS} =
 548  {
 549    SQL_CA2_MAX_ROWS_SELECT                   => 0x00000080
 550  , SQL_CA2_MAX_ROWS_INSERT                   => 0x00000100
 551  , SQL_CA2_MAX_ROWS_DELETE                   => 0x00000200
 552  , SQL_CA2_MAX_ROWS_UPDATE                   => 0x00000400
 553  , SQL_CA2_MAX_ROWS_CATALOG                  => 0x00000800
 554  # SQL_CA2_MAX_ROWS_AFFECTS_ALL              =>
 555  };
 556  $ReturnValues{SQL_ATTR_SCROLL_CONCURRENCY} =
 557  {
 558    SQL_CA2_READ_ONLY_CONCURRENCY             => 0x00000001
 559  , SQL_CA2_LOCK_CONCURRENCY                  => 0x00000002
 560  , SQL_CA2_OPT_ROWVER_CONCURRENCY            => 0x00000004
 561  , SQL_CA2_OPT_VALUES_CONCURRENCY            => 0x00000008
 562  , SQL_CA2_SENSITIVITY_ADDITIONS             => 0x00000010
 563  , SQL_CA2_SENSITIVITY_DELETIONS             => 0x00000020
 564  , SQL_CA2_SENSITIVITY_UPDATES               => 0x00000040
 565  };
 566  $ReturnValues{SQL_BATCH_ROW_COUNT} =
 567  {
 568    SQL_BRC_PROCEDURES                        => 0x0000001
 569  , SQL_BRC_EXPLICIT                          => 0x0000002
 570  , SQL_BRC_ROLLED_UP                         => 0x0000004
 571  };
 572  $ReturnValues{SQL_BATCH_SUPPORT} =
 573  {
 574    SQL_BS_SELECT_EXPLICIT                    => 0x00000001
 575  , SQL_BS_ROW_COUNT_EXPLICIT                 => 0x00000002
 576  , SQL_BS_SELECT_PROC                        => 0x00000004
 577  , SQL_BS_ROW_COUNT_PROC                     => 0x00000008
 578  };
 579  $ReturnValues{SQL_BOOKMARK_PERSISTENCE} =
 580  {
 581    SQL_BP_CLOSE                              => 0x00000001
 582  , SQL_BP_DELETE                             => 0x00000002
 583  , SQL_BP_DROP                               => 0x00000004
 584  , SQL_BP_TRANSACTION                        => 0x00000008
 585  , SQL_BP_UPDATE                             => 0x00000010
 586  , SQL_BP_OTHER_HSTMT                        => 0x00000020
 587  , SQL_BP_SCROLL                             => 0x00000040
 588  };
 589  $ReturnValues{SQL_CATALOG_LOCATION} =
 590  {
 591    SQL_CL_START                              => 0x0001  # SQL_QL_START
 592  , SQL_CL_END                                => 0x0002  # SQL_QL_END
 593  };
 594  $ReturnValues{SQL_CATALOG_USAGE} =
 595  {
 596    SQL_CU_DML_STATEMENTS                     => 0x00000001  # SQL_QU_DML_STATEMENTS
 597  , SQL_CU_PROCEDURE_INVOCATION               => 0x00000002  # SQL_QU_PROCEDURE_INVOCATION
 598  , SQL_CU_TABLE_DEFINITION                   => 0x00000004  # SQL_QU_TABLE_DEFINITION
 599  , SQL_CU_INDEX_DEFINITION                   => 0x00000008  # SQL_QU_INDEX_DEFINITION
 600  , SQL_CU_PRIVILEGE_DEFINITION               => 0x00000010  # SQL_QU_PRIVILEGE_DEFINITION
 601  };
 602  $ReturnValues{SQL_CONCAT_NULL_BEHAVIOR} =
 603  {
 604    SQL_CB_NULL                               => 0x0000
 605  , SQL_CB_NON_NULL                           => 0x0001
 606  };
 607  $ReturnValues{SQL_CONVERT_} =
 608  {
 609    SQL_CVT_CHAR                              => 0x00000001
 610  , SQL_CVT_NUMERIC                           => 0x00000002
 611  , SQL_CVT_DECIMAL                           => 0x00000004
 612  , SQL_CVT_INTEGER                           => 0x00000008
 613  , SQL_CVT_SMALLINT                          => 0x00000010
 614  , SQL_CVT_FLOAT                             => 0x00000020
 615  , SQL_CVT_REAL                              => 0x00000040
 616  , SQL_CVT_DOUBLE                            => 0x00000080
 617  , SQL_CVT_VARCHAR                           => 0x00000100
 618  , SQL_CVT_LONGVARCHAR                       => 0x00000200
 619  , SQL_CVT_BINARY                            => 0x00000400
 620  , SQL_CVT_VARBINARY                         => 0x00000800
 621  , SQL_CVT_BIT                               => 0x00001000
 622  , SQL_CVT_TINYINT                           => 0x00002000
 623  , SQL_CVT_BIGINT                            => 0x00004000
 624  , SQL_CVT_DATE                              => 0x00008000
 625  , SQL_CVT_TIME                              => 0x00010000
 626  , SQL_CVT_TIMESTAMP                         => 0x00020000
 627  , SQL_CVT_LONGVARBINARY                     => 0x00040000
 628  , SQL_CVT_INTERVAL_YEAR_MONTH               => 0x00080000
 629  , SQL_CVT_INTERVAL_DAY_TIME                 => 0x00100000
 630  , SQL_CVT_WCHAR                             => 0x00200000
 631  , SQL_CVT_WLONGVARCHAR                      => 0x00400000
 632  , SQL_CVT_WVARCHAR                          => 0x00800000
 633  , SQL_CVT_GUID                              => 0x01000000
 634  };
 635  $ReturnValues{SQL_CONVERT_BIGINT             } = $ReturnValues{SQL_CONVERT_};
 636  $ReturnValues{SQL_CONVERT_BINARY             } = $ReturnValues{SQL_CONVERT_};
 637  $ReturnValues{SQL_CONVERT_BIT                } = $ReturnValues{SQL_CONVERT_};
 638  $ReturnValues{SQL_CONVERT_CHAR               } = $ReturnValues{SQL_CONVERT_};
 639  $ReturnValues{SQL_CONVERT_DATE               } = $ReturnValues{SQL_CONVERT_};
 640  $ReturnValues{SQL_CONVERT_DECIMAL            } = $ReturnValues{SQL_CONVERT_};
 641  $ReturnValues{SQL_CONVERT_DOUBLE             } = $ReturnValues{SQL_CONVERT_};
 642  $ReturnValues{SQL_CONVERT_FLOAT              } = $ReturnValues{SQL_CONVERT_};
 643  $ReturnValues{SQL_CONVERT_GUID               } = $ReturnValues{SQL_CONVERT_};
 644  $ReturnValues{SQL_CONVERT_INTEGER            } = $ReturnValues{SQL_CONVERT_};
 645  $ReturnValues{SQL_CONVERT_INTERVAL_DAY_TIME  } = $ReturnValues{SQL_CONVERT_};
 646  $ReturnValues{SQL_CONVERT_INTERVAL_YEAR_MONTH} = $ReturnValues{SQL_CONVERT_};
 647  $ReturnValues{SQL_CONVERT_LONGVARBINARY      } = $ReturnValues{SQL_CONVERT_};
 648  $ReturnValues{SQL_CONVERT_LONGVARCHAR        } = $ReturnValues{SQL_CONVERT_};
 649  $ReturnValues{SQL_CONVERT_NUMERIC            } = $ReturnValues{SQL_CONVERT_};
 650  $ReturnValues{SQL_CONVERT_REAL               } = $ReturnValues{SQL_CONVERT_};
 651  $ReturnValues{SQL_CONVERT_SMALLINT           } = $ReturnValues{SQL_CONVERT_};
 652  $ReturnValues{SQL_CONVERT_TIME               } = $ReturnValues{SQL_CONVERT_};
 653  $ReturnValues{SQL_CONVERT_TIMESTAMP          } = $ReturnValues{SQL_CONVERT_};
 654  $ReturnValues{SQL_CONVERT_TINYINT            } = $ReturnValues{SQL_CONVERT_};
 655  $ReturnValues{SQL_CONVERT_VARBINARY          } = $ReturnValues{SQL_CONVERT_};
 656  $ReturnValues{SQL_CONVERT_VARCHAR            } = $ReturnValues{SQL_CONVERT_};
 657  $ReturnValues{SQL_CONVERT_WCHAR              } = $ReturnValues{SQL_CONVERT_};
 658  $ReturnValues{SQL_CONVERT_WLONGVARCHAR       } = $ReturnValues{SQL_CONVERT_};
 659  $ReturnValues{SQL_CONVERT_WVARCHAR           } = $ReturnValues{SQL_CONVERT_};
 660  
 661  $ReturnValues{SQL_CONVERT_FUNCTIONS} =
 662  {
 663    SQL_FN_CVT_CONVERT                        => 0x00000001
 664  , SQL_FN_CVT_CAST                           => 0x00000002
 665  };
 666  $ReturnValues{SQL_CORRELATION_NAME} =
 667  {
 668    SQL_CN_NONE                               => 0x0000
 669  , SQL_CN_DIFFERENT                          => 0x0001
 670  , SQL_CN_ANY                                => 0x0002
 671  };
 672  $ReturnValues{SQL_CREATE_ASSERTION} =
 673  {
 674    SQL_CA_CREATE_ASSERTION                   => 0x00000001
 675  , SQL_CA_CONSTRAINT_INITIALLY_DEFERRED      => 0x00000010
 676  , SQL_CA_CONSTRAINT_INITIALLY_IMMEDIATE     => 0x00000020
 677  , SQL_CA_CONSTRAINT_DEFERRABLE              => 0x00000040
 678  , SQL_CA_CONSTRAINT_NON_DEFERRABLE          => 0x00000080
 679  };
 680  $ReturnValues{SQL_CREATE_CHARACTER_SET} =
 681  {
 682    SQL_CCS_CREATE_CHARACTER_SET              => 0x00000001
 683  , SQL_CCS_COLLATE_CLAUSE                    => 0x00000002
 684  , SQL_CCS_LIMITED_COLLATION                 => 0x00000004
 685  };
 686  $ReturnValues{SQL_CREATE_COLLATION} =
 687  {
 688    SQL_CCOL_CREATE_COLLATION                 => 0x00000001
 689  };
 690  $ReturnValues{SQL_CREATE_DOMAIN} =
 691  {
 692    SQL_CDO_CREATE_DOMAIN                     => 0x00000001
 693  , SQL_CDO_DEFAULT                           => 0x00000002
 694  , SQL_CDO_CONSTRAINT                        => 0x00000004
 695  , SQL_CDO_COLLATION                         => 0x00000008
 696  , SQL_CDO_CONSTRAINT_NAME_DEFINITION        => 0x00000010
 697  , SQL_CDO_CONSTRAINT_INITIALLY_DEFERRED     => 0x00000020
 698  , SQL_CDO_CONSTRAINT_INITIALLY_IMMEDIATE    => 0x00000040
 699  , SQL_CDO_CONSTRAINT_DEFERRABLE             => 0x00000080
 700  , SQL_CDO_CONSTRAINT_NON_DEFERRABLE         => 0x00000100
 701  };
 702  $ReturnValues{SQL_CREATE_SCHEMA} =
 703  {
 704    SQL_CS_CREATE_SCHEMA                      => 0x00000001
 705  , SQL_CS_AUTHORIZATION                      => 0x00000002
 706  , SQL_CS_DEFAULT_CHARACTER_SET              => 0x00000004
 707  };
 708  $ReturnValues{SQL_CREATE_TABLE} =
 709  {
 710    SQL_CT_CREATE_TABLE                       => 0x00000001
 711  , SQL_CT_COMMIT_PRESERVE                    => 0x00000002
 712  , SQL_CT_COMMIT_DELETE                      => 0x00000004
 713  , SQL_CT_GLOBAL_TEMPORARY                   => 0x00000008
 714  , SQL_CT_LOCAL_TEMPORARY                    => 0x00000010
 715  , SQL_CT_CONSTRAINT_INITIALLY_DEFERRED      => 0x00000020
 716  , SQL_CT_CONSTRAINT_INITIALLY_IMMEDIATE     => 0x00000040
 717  , SQL_CT_CONSTRAINT_DEFERRABLE              => 0x00000080
 718  , SQL_CT_CONSTRAINT_NON_DEFERRABLE          => 0x00000100
 719  , SQL_CT_COLUMN_CONSTRAINT                  => 0x00000200
 720  , SQL_CT_COLUMN_DEFAULT                     => 0x00000400
 721  , SQL_CT_COLUMN_COLLATION                   => 0x00000800
 722  , SQL_CT_TABLE_CONSTRAINT                   => 0x00001000
 723  , SQL_CT_CONSTRAINT_NAME_DEFINITION         => 0x00002000
 724  };
 725  $ReturnValues{SQL_CREATE_TRANSLATION} =
 726  {
 727    SQL_CTR_CREATE_TRANSLATION                => 0x00000001
 728  };
 729  $ReturnValues{SQL_CREATE_VIEW} =
 730  {
 731    SQL_CV_CREATE_VIEW                        => 0x00000001
 732  , SQL_CV_CHECK_OPTION                       => 0x00000002
 733  , SQL_CV_CASCADED                           => 0x00000004
 734  , SQL_CV_LOCAL                              => 0x00000008
 735  };
 736  $ReturnValues{SQL_CURSOR_COMMIT_BEHAVIOR} =
 737  {
 738    SQL_CB_DELETE                             => 0
 739  , SQL_CB_CLOSE                              => 1
 740  , SQL_CB_PRESERVE                           => 2
 741  };
 742  $ReturnValues{SQL_CURSOR_ROLLBACK_BEHAVIOR} = $ReturnValues{SQL_CURSOR_COMMIT_BEHAVIOR};
 743  
 744  $ReturnValues{SQL_CURSOR_SENSITIVITY} =
 745  {
 746    SQL_UNSPECIFIED                           => 0
 747  , SQL_INSENSITIVE                           => 1
 748  , SQL_SENSITIVE                             => 2
 749  };
 750  $ReturnValues{SQL_DATETIME_LITERALS} =
 751  {
 752    SQL_DL_SQL92_DATE                         => 0x00000001
 753  , SQL_DL_SQL92_TIME                         => 0x00000002
 754  , SQL_DL_SQL92_TIMESTAMP                    => 0x00000004
 755  , SQL_DL_SQL92_INTERVAL_YEAR                => 0x00000008
 756  , SQL_DL_SQL92_INTERVAL_MONTH               => 0x00000010
 757  , SQL_DL_SQL92_INTERVAL_DAY                 => 0x00000020
 758  , SQL_DL_SQL92_INTERVAL_HOUR                => 0x00000040
 759  , SQL_DL_SQL92_INTERVAL_MINUTE              => 0x00000080
 760  , SQL_DL_SQL92_INTERVAL_SECOND              => 0x00000100
 761  , SQL_DL_SQL92_INTERVAL_YEAR_TO_MONTH       => 0x00000200
 762  , SQL_DL_SQL92_INTERVAL_DAY_TO_HOUR         => 0x00000400
 763  , SQL_DL_SQL92_INTERVAL_DAY_TO_MINUTE       => 0x00000800
 764  , SQL_DL_SQL92_INTERVAL_DAY_TO_SECOND       => 0x00001000
 765  , SQL_DL_SQL92_INTERVAL_HOUR_TO_MINUTE      => 0x00002000
 766  , SQL_DL_SQL92_INTERVAL_HOUR_TO_SECOND      => 0x00004000
 767  , SQL_DL_SQL92_INTERVAL_MINUTE_TO_SECOND    => 0x00008000
 768  };
 769  $ReturnValues{SQL_DDL_INDEX} =
 770  {
 771    SQL_DI_CREATE_INDEX                       => 0x00000001
 772  , SQL_DI_DROP_INDEX                         => 0x00000002
 773  };
 774  $ReturnValues{SQL_DIAG_CURSOR_ROW_COUNT} =
 775  {
 776    SQL_CA2_CRC_EXACT                         => 0x00001000
 777  , SQL_CA2_CRC_APPROXIMATE                   => 0x00002000
 778  , SQL_CA2_SIMULATE_NON_UNIQUE               => 0x00004000
 779  , SQL_CA2_SIMULATE_TRY_UNIQUE               => 0x00008000
 780  , SQL_CA2_SIMULATE_UNIQUE                   => 0x00010000
 781  };
 782  $ReturnValues{SQL_DROP_ASSERTION} =
 783  {
 784    SQL_DA_DROP_ASSERTION                     => 0x00000001
 785  };
 786  $ReturnValues{SQL_DROP_CHARACTER_SET} =
 787  {
 788    SQL_DCS_DROP_CHARACTER_SET                => 0x00000001
 789  };
 790  $ReturnValues{SQL_DROP_COLLATION} =
 791  {
 792    SQL_DC_DROP_COLLATION                     => 0x00000001
 793  };
 794  $ReturnValues{SQL_DROP_DOMAIN} =
 795  {
 796    SQL_DD_DROP_DOMAIN                        => 0x00000001
 797  , SQL_DD_RESTRICT                           => 0x00000002
 798  , SQL_DD_CASCADE                            => 0x00000004
 799  };
 800  $ReturnValues{SQL_DROP_SCHEMA} =
 801  {
 802    SQL_DS_DROP_SCHEMA                        => 0x00000001
 803  , SQL_DS_RESTRICT                           => 0x00000002
 804  , SQL_DS_CASCADE                            => 0x00000004
 805  };
 806  $ReturnValues{SQL_DROP_TABLE} =
 807  {
 808    SQL_DT_DROP_TABLE                         => 0x00000001
 809  , SQL_DT_RESTRICT                           => 0x00000002
 810  , SQL_DT_CASCADE                            => 0x00000004
 811  };
 812  $ReturnValues{SQL_DROP_TRANSLATION} =
 813  {
 814    SQL_DTR_DROP_TRANSLATION                  => 0x00000001
 815  };
 816  $ReturnValues{SQL_DROP_VIEW} =
 817  {
 818    SQL_DV_DROP_VIEW                          => 0x00000001
 819  , SQL_DV_RESTRICT                           => 0x00000002
 820  , SQL_DV_CASCADE                            => 0x00000004
 821  };
 822  $ReturnValues{SQL_CURSOR_ATTRIBUTES1} =
 823  {
 824    SQL_CA1_NEXT                              => 0x00000001
 825  , SQL_CA1_ABSOLUTE                          => 0x00000002
 826  , SQL_CA1_RELATIVE                          => 0x00000004
 827  , SQL_CA1_BOOKMARK                          => 0x00000008
 828  , SQL_CA1_LOCK_NO_CHANGE                    => 0x00000040
 829  , SQL_CA1_LOCK_EXCLUSIVE                    => 0x00000080
 830  , SQL_CA1_LOCK_UNLOCK                       => 0x00000100
 831  , SQL_CA1_POS_POSITION                      => 0x00000200
 832  , SQL_CA1_POS_UPDATE                        => 0x00000400
 833  , SQL_CA1_POS_DELETE                        => 0x00000800
 834  , SQL_CA1_POS_REFRESH                       => 0x00001000
 835  , SQL_CA1_POSITIONED_UPDATE                 => 0x00002000
 836  , SQL_CA1_POSITIONED_DELETE                 => 0x00004000
 837  , SQL_CA1_SELECT_FOR_UPDATE                 => 0x00008000
 838  , SQL_CA1_BULK_ADD                          => 0x00010000
 839  , SQL_CA1_BULK_UPDATE_BY_BOOKMARK           => 0x00020000
 840  , SQL_CA1_BULK_DELETE_BY_BOOKMARK           => 0x00040000
 841  , SQL_CA1_BULK_FETCH_BY_BOOKMARK            => 0x00080000
 842  };
 843  $ReturnValues{     SQL_DYNAMIC_CURSOR_ATTRIBUTES1} = $ReturnValues{SQL_CURSOR_ATTRIBUTES1};
 844  $ReturnValues{SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES1} = $ReturnValues{SQL_CURSOR_ATTRIBUTES1};
 845  $ReturnValues{      SQL_KEYSET_CURSOR_ATTRIBUTES1} = $ReturnValues{SQL_CURSOR_ATTRIBUTES1};
 846  $ReturnValues{      SQL_STATIC_CURSOR_ATTRIBUTES1} = $ReturnValues{SQL_CURSOR_ATTRIBUTES1};
 847  
 848  $ReturnValues{SQL_CURSOR_ATTRIBUTES2} =
 849  {
 850    SQL_CA2_READ_ONLY_CONCURRENCY             => 0x00000001
 851  , SQL_CA2_LOCK_CONCURRENCY                  => 0x00000002
 852  , SQL_CA2_OPT_ROWVER_CONCURRENCY            => 0x00000004
 853  , SQL_CA2_OPT_VALUES_CONCURRENCY            => 0x00000008
 854  , SQL_CA2_SENSITIVITY_ADDITIONS             => 0x00000010
 855  , SQL_CA2_SENSITIVITY_DELETIONS             => 0x00000020
 856  , SQL_CA2_SENSITIVITY_UPDATES               => 0x00000040
 857  , SQL_CA2_MAX_ROWS_SELECT                   => 0x00000080
 858  , SQL_CA2_MAX_ROWS_INSERT                   => 0x00000100
 859  , SQL_CA2_MAX_ROWS_DELETE                   => 0x00000200
 860  , SQL_CA2_MAX_ROWS_UPDATE                   => 0x00000400
 861  , SQL_CA2_MAX_ROWS_CATALOG                  => 0x00000800
 862  , SQL_CA2_CRC_EXACT                         => 0x00001000
 863  , SQL_CA2_CRC_APPROXIMATE                   => 0x00002000
 864  , SQL_CA2_SIMULATE_NON_UNIQUE               => 0x00004000
 865  , SQL_CA2_SIMULATE_TRY_UNIQUE               => 0x00008000
 866  , SQL_CA2_SIMULATE_UNIQUE                   => 0x00010000
 867  };
 868  $ReturnValues{     SQL_DYNAMIC_CURSOR_ATTRIBUTES2} = $ReturnValues{SQL_CURSOR_ATTRIBUTES2};
 869  $ReturnValues{SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES2} = $ReturnValues{SQL_CURSOR_ATTRIBUTES2};
 870  $ReturnValues{      SQL_KEYSET_CURSOR_ATTRIBUTES2} = $ReturnValues{SQL_CURSOR_ATTRIBUTES2};
 871  $ReturnValues{      SQL_STATIC_CURSOR_ATTRIBUTES2} = $ReturnValues{SQL_CURSOR_ATTRIBUTES2};
 872  
 873  $ReturnValues{SQL_FETCH_DIRECTION} =
 874  {
 875    SQL_FD_FETCH_NEXT                         => 0x00000001
 876  , SQL_FD_FETCH_FIRST                        => 0x00000002
 877  , SQL_FD_FETCH_LAST                         => 0x00000004
 878  , SQL_FD_FETCH_PRIOR                        => 0x00000008
 879  , SQL_FD_FETCH_ABSOLUTE                     => 0x00000010
 880  , SQL_FD_FETCH_RELATIVE                     => 0x00000020
 881  , SQL_FD_FETCH_RESUME                       => 0x00000040
 882  , SQL_FD_FETCH_BOOKMARK                     => 0x00000080
 883  };
 884  $ReturnValues{SQL_FILE_USAGE} =
 885  {
 886    SQL_FILE_NOT_SUPPORTED                    => 0x0000
 887  , SQL_FILE_TABLE                            => 0x0001
 888  , SQL_FILE_QUALIFIER                        => 0x0002
 889  , SQL_FILE_CATALOG                          => 0x0002  # SQL_FILE_QUALIFIER
 890  };
 891  $ReturnValues{SQL_GETDATA_EXTENSIONS} =
 892  {
 893    SQL_GD_ANY_COLUMN                         => 0x00000001
 894  , SQL_GD_ANY_ORDER                          => 0x00000002
 895  , SQL_GD_BLOCK                              => 0x00000004
 896  , SQL_GD_BOUND                              => 0x00000008
 897  };
 898  $ReturnValues{SQL_GROUP_BY} =
 899  {
 900    SQL_GB_NOT_SUPPORTED                      => 0x0000
 901  , SQL_GB_GROUP_BY_EQUALS_SELECT             => 0x0001
 902  , SQL_GB_GROUP_BY_CONTAINS_SELECT           => 0x0002
 903  , SQL_GB_NO_RELATION                        => 0x0003
 904  , SQL_GB_COLLATE                            => 0x0004
 905  };
 906  $ReturnValues{SQL_IDENTIFIER_CASE} =
 907  {
 908    SQL_IC_UPPER                              => 1
 909  , SQL_IC_LOWER                              => 2
 910  , SQL_IC_SENSITIVE                          => 3
 911  , SQL_IC_MIXED                              => 4
 912  };
 913  $ReturnValues{SQL_INDEX_KEYWORDS} =
 914  {
 915    SQL_IK_NONE                               => 0x00000000
 916  , SQL_IK_ASC                                => 0x00000001
 917  , SQL_IK_DESC                               => 0x00000002
 918  # SQL_IK_ALL                                =>
 919  };
 920  $ReturnValues{SQL_INFO_SCHEMA_VIEWS} =
 921  {
 922    SQL_ISV_ASSERTIONS                        => 0x00000001
 923  , SQL_ISV_CHARACTER_SETS                    => 0x00000002
 924  , SQL_ISV_CHECK_CONSTRAINTS                 => 0x00000004
 925  , SQL_ISV_COLLATIONS                        => 0x00000008
 926  , SQL_ISV_COLUMN_DOMAIN_USAGE               => 0x00000010
 927  , SQL_ISV_COLUMN_PRIVILEGES                 => 0x00000020
 928  , SQL_ISV_COLUMNS                           => 0x00000040
 929  , SQL_ISV_CONSTRAINT_COLUMN_USAGE           => 0x00000080
 930  , SQL_ISV_CONSTRAINT_TABLE_USAGE            => 0x00000100
 931  , SQL_ISV_DOMAIN_CONSTRAINTS                => 0x00000200
 932  , SQL_ISV_DOMAINS                           => 0x00000400
 933  , SQL_ISV_KEY_COLUMN_USAGE                  => 0x00000800
 934  , SQL_ISV_REFERENTIAL_CONSTRAINTS           => 0x00001000
 935  , SQL_ISV_SCHEMATA                          => 0x00002000
 936  , SQL_ISV_SQL_LANGUAGES                     => 0x00004000
 937  , SQL_ISV_TABLE_CONSTRAINTS                 => 0x00008000
 938  , SQL_ISV_TABLE_PRIVILEGES                  => 0x00010000
 939  , SQL_ISV_TABLES                            => 0x00020000
 940  , SQL_ISV_TRANSLATIONS                      => 0x00040000
 941  , SQL_ISV_USAGE_PRIVILEGES                  => 0x00080000
 942  , SQL_ISV_VIEW_COLUMN_USAGE                 => 0x00100000
 943  , SQL_ISV_VIEW_TABLE_USAGE                  => 0x00200000
 944  , SQL_ISV_VIEWS                             => 0x00400000
 945  };
 946  $ReturnValues{SQL_INSERT_STATEMENT} =
 947  {
 948    SQL_IS_INSERT_LITERALS                    => 0x00000001
 949  , SQL_IS_INSERT_SEARCHED                    => 0x00000002
 950  , SQL_IS_SELECT_INTO                        => 0x00000004
 951  };
 952  $ReturnValues{SQL_LOCK_TYPES} =
 953  {
 954    SQL_LCK_NO_CHANGE                         => 0x00000001
 955  , SQL_LCK_EXCLUSIVE                         => 0x00000002
 956  , SQL_LCK_UNLOCK                            => 0x00000004
 957  };
 958  $ReturnValues{SQL_NON_NULLABLE_COLUMNS} =
 959  {
 960    SQL_NNC_NULL                              => 0x0000
 961  , SQL_NNC_NON_NULL                          => 0x0001
 962  };
 963  $ReturnValues{SQL_NULL_COLLATION} =
 964  {
 965    SQL_NC_HIGH                               => 0
 966  , SQL_NC_LOW                                => 1
 967  , SQL_NC_START                              => 0x0002
 968  , SQL_NC_END                                => 0x0004
 969  };
 970  $ReturnValues{SQL_NUMERIC_FUNCTIONS} =
 971  {
 972    SQL_FN_NUM_ABS                            => 0x00000001
 973  , SQL_FN_NUM_ACOS                           => 0x00000002
 974  , SQL_FN_NUM_ASIN                           => 0x00000004
 975  , SQL_FN_NUM_ATAN                           => 0x00000008
 976  , SQL_FN_NUM_ATAN2                          => 0x00000010
 977  , SQL_FN_NUM_CEILING                        => 0x00000020
 978  , SQL_FN_NUM_COS                            => 0x00000040
 979  , SQL_FN_NUM_COT                            => 0x00000080
 980  , SQL_FN_NUM_EXP                            => 0x00000100
 981  , SQL_FN_NUM_FLOOR                          => 0x00000200
 982  , SQL_FN_NUM_LOG                            => 0x00000400
 983  , SQL_FN_NUM_MOD                            => 0x00000800
 984  , SQL_FN_NUM_SIGN                           => 0x00001000
 985  , SQL_FN_NUM_SIN                            => 0x00002000
 986  , SQL_FN_NUM_SQRT                           => 0x00004000
 987  , SQL_FN_NUM_TAN                            => 0x00008000
 988  , SQL_FN_NUM_PI                             => 0x00010000
 989  , SQL_FN_NUM_RAND                           => 0x00020000
 990  , SQL_FN_NUM_DEGREES                        => 0x00040000
 991  , SQL_FN_NUM_LOG10                          => 0x00080000
 992  , SQL_FN_NUM_POWER                          => 0x00100000
 993  , SQL_FN_NUM_RADIANS                        => 0x00200000
 994  , SQL_FN_NUM_ROUND                          => 0x00400000
 995  , SQL_FN_NUM_TRUNCATE                       => 0x00800000
 996  };
 997  $ReturnValues{SQL_ODBC_API_CONFORMANCE} =
 998  {
 999    SQL_OAC_NONE                              => 0x0000
1000  , SQL_OAC_LEVEL1                            => 0x0001
1001  , SQL_OAC_LEVEL2                            => 0x0002
1002  };
1003  $ReturnValues{SQL_ODBC_INTERFACE_CONFORMANCE} =
1004  {
1005    SQL_OIC_CORE                              => 1
1006  , SQL_OIC_LEVEL1                            => 2
1007  , SQL_OIC_LEVEL2                            => 3
1008  };
1009  $ReturnValues{SQL_ODBC_SAG_CLI_CONFORMANCE} =
1010  {
1011    SQL_OSCC_NOT_COMPLIANT                    => 0x0000
1012  , SQL_OSCC_COMPLIANT                        => 0x0001
1013  };
1014  $ReturnValues{SQL_ODBC_SQL_CONFORMANCE} =
1015  {
1016    SQL_OSC_MINIMUM                           => 0x0000
1017  , SQL_OSC_CORE                              => 0x0001
1018  , SQL_OSC_EXTENDED                          => 0x0002
1019  };
1020  $ReturnValues{SQL_OJ_CAPABILITIES} =
1021  {
1022    SQL_OJ_LEFT                               => 0x00000001
1023  , SQL_OJ_RIGHT                              => 0x00000002
1024  , SQL_OJ_FULL                               => 0x00000004
1025  , SQL_OJ_NESTED                             => 0x00000008
1026  , SQL_OJ_NOT_ORDERED                        => 0x00000010
1027  , SQL_OJ_INNER                              => 0x00000020
1028  , SQL_OJ_ALL_COMPARISON_OPS                 => 0x00000040
1029  };
1030  $ReturnValues{SQL_OWNER_USAGE} =
1031  {
1032    SQL_OU_DML_STATEMENTS                     => 0x00000001
1033  , SQL_OU_PROCEDURE_INVOCATION               => 0x00000002
1034  , SQL_OU_TABLE_DEFINITION                   => 0x00000004
1035  , SQL_OU_INDEX_DEFINITION                   => 0x00000008
1036  , SQL_OU_PRIVILEGE_DEFINITION               => 0x00000010
1037  };
1038  $ReturnValues{SQL_PARAM_ARRAY_ROW_COUNTS} =
1039  {
1040    SQL_PARC_BATCH                            => 1
1041  , SQL_PARC_NO_BATCH                         => 2
1042  };
1043  $ReturnValues{SQL_PARAM_ARRAY_SELECTS} =
1044  {
1045    SQL_PAS_BATCH                             => 1
1046  , SQL_PAS_NO_BATCH                          => 2
1047  , SQL_PAS_NO_SELECT                         => 3
1048  };
1049  $ReturnValues{SQL_POSITIONED_STATEMENTS} =
1050  {
1051    SQL_PS_POSITIONED_DELETE                  => 0x00000001
1052  , SQL_PS_POSITIONED_UPDATE                  => 0x00000002
1053  , SQL_PS_SELECT_FOR_UPDATE                  => 0x00000004
1054  };
1055  $ReturnValues{SQL_POS_OPERATIONS} =
1056  {
1057    SQL_POS_POSITION                          => 0x00000001
1058  , SQL_POS_REFRESH                           => 0x00000002
1059  , SQL_POS_UPDATE                            => 0x00000004
1060  , SQL_POS_DELETE                            => 0x00000008
1061  , SQL_POS_ADD                               => 0x00000010
1062  };
1063  $ReturnValues{SQL_QUALIFIER_LOCATION} =
1064  {
1065    SQL_QL_START                              => 0x0001
1066  , SQL_QL_END                                => 0x0002
1067  };
1068  $ReturnValues{SQL_QUALIFIER_USAGE} =
1069  {
1070    SQL_QU_DML_STATEMENTS                     => 0x00000001
1071  , SQL_QU_PROCEDURE_INVOCATION               => 0x00000002
1072  , SQL_QU_TABLE_DEFINITION                   => 0x00000004
1073  , SQL_QU_INDEX_DEFINITION                   => 0x00000008
1074  , SQL_QU_PRIVILEGE_DEFINITION               => 0x00000010
1075  };
1076  $ReturnValues{SQL_QUOTED_IDENTIFIER_CASE}   = $ReturnValues{SQL_IDENTIFIER_CASE};
1077  
1078  $ReturnValues{SQL_SCHEMA_USAGE} =
1079  {
1080    SQL_SU_DML_STATEMENTS                     => 0x00000001  # SQL_OU_DML_STATEMENTS
1081  , SQL_SU_PROCEDURE_INVOCATION               => 0x00000002  # SQL_OU_PROCEDURE_INVOCATION
1082  , SQL_SU_TABLE_DEFINITION                   => 0x00000004  # SQL_OU_TABLE_DEFINITION
1083  , SQL_SU_INDEX_DEFINITION                   => 0x00000008  # SQL_OU_INDEX_DEFINITION
1084  , SQL_SU_PRIVILEGE_DEFINITION               => 0x00000010  # SQL_OU_PRIVILEGE_DEFINITION
1085  };
1086  $ReturnValues{SQL_SCROLL_CONCURRENCY} =
1087  {
1088    SQL_SCCO_READ_ONLY                        => 0x00000001
1089  , SQL_SCCO_LOCK                             => 0x00000002
1090  , SQL_SCCO_OPT_ROWVER                       => 0x00000004
1091  , SQL_SCCO_OPT_VALUES                       => 0x00000008
1092  };
1093  $ReturnValues{SQL_SCROLL_OPTIONS} =
1094  {
1095    SQL_SO_FORWARD_ONLY                       => 0x00000001
1096  , SQL_SO_KEYSET_DRIVEN                      => 0x00000002
1097  , SQL_SO_DYNAMIC                            => 0x00000004
1098  , SQL_SO_MIXED                              => 0x00000008
1099  , SQL_SO_STATIC                             => 0x00000010
1100  };
1101  $ReturnValues{SQL_SQL92_DATETIME_FUNCTIONS} =
1102  {
1103    SQL_SDF_CURRENT_DATE                      => 0x00000001
1104  , SQL_SDF_CURRENT_TIME                      => 0x00000002
1105  , SQL_SDF_CURRENT_TIMESTAMP                 => 0x00000004
1106  };
1107  $ReturnValues{SQL_SQL92_FOREIGN_KEY_DELETE_RULE} =
1108  {
1109    SQL_SFKD_CASCADE                          => 0x00000001
1110  , SQL_SFKD_NO_ACTION                        => 0x00000002
1111  , SQL_SFKD_SET_DEFAULT                      => 0x00000004
1112  , SQL_SFKD_SET_NULL                         => 0x00000008
1113  };
1114  $ReturnValues{SQL_SQL92_FOREIGN_KEY_UPDATE_RULE} =
1115  {
1116    SQL_SFKU_CASCADE                          => 0x00000001
1117  , SQL_SFKU_NO_ACTION                        => 0x00000002
1118  , SQL_SFKU_SET_DEFAULT                      => 0x00000004
1119  , SQL_SFKU_SET_NULL                         => 0x00000008
1120  };
1121  $ReturnValues{SQL_SQL92_GRANT} =
1122  {
1123    SQL_SG_USAGE_ON_DOMAIN                    => 0x00000001
1124  , SQL_SG_USAGE_ON_CHARACTER_SET             => 0x00000002
1125  , SQL_SG_USAGE_ON_COLLATION                 => 0x00000004
1126  , SQL_SG_USAGE_ON_TRANSLATION               => 0x00000008
1127  , SQL_SG_WITH_GRANT_OPTION                  => 0x00000010
1128  , SQL_SG_DELETE_TABLE                       => 0x00000020
1129  , SQL_SG_INSERT_TABLE                       => 0x00000040
1130  , SQL_SG_INSERT_COLUMN                      => 0x00000080
1131  , SQL_SG_REFERENCES_TABLE                   => 0x00000100
1132  , SQL_SG_REFERENCES_COLUMN                  => 0x00000200
1133  , SQL_SG_SELECT_TABLE                       => 0x00000400
1134  , SQL_SG_UPDATE_TABLE                       => 0x00000800
1135  , SQL_SG_UPDATE_COLUMN                      => 0x00001000
1136  };
1137  $ReturnValues{SQL_SQL92_NUMERIC_VALUE_FUNCTIONS} =
1138  {
1139    SQL_SNVF_BIT_LENGTH                       => 0x00000001
1140  , SQL_SNVF_CHAR_LENGTH                      => 0x00000002
1141  , SQL_SNVF_CHARACTER_LENGTH                 => 0x00000004
1142  , SQL_SNVF_EXTRACT                          => 0x00000008
1143  , SQL_SNVF_OCTET_LENGTH                     => 0x00000010
1144  , SQL_SNVF_POSITION                         => 0x00000020
1145  };
1146  $ReturnValues{SQL_SQL92_PREDICATES} =
1147  {
1148    SQL_SP_EXISTS                             => 0x00000001
1149  , SQL_SP_ISNOTNULL                          => 0x00000002
1150  , SQL_SP_ISNULL                             => 0x00000004
1151  , SQL_SP_MATCH_FULL                         => 0x00000008
1152  , SQL_SP_MATCH_PARTIAL                      => 0x00000010
1153  , SQL_SP_MATCH_UNIQUE_FULL                  => 0x00000020
1154  , SQL_SP_MATCH_UNIQUE_PARTIAL               => 0x00000040
1155  , SQL_SP_OVERLAPS                           => 0x00000080
1156  , SQL_SP_UNIQUE                             => 0x00000100
1157  , SQL_SP_LIKE                               => 0x00000200
1158  , SQL_SP_IN                                 => 0x00000400
1159  , SQL_SP_BETWEEN                            => 0x00000800
1160  , SQL_SP_COMPARISON                         => 0x00001000
1161  , SQL_SP_QUANTIFIED_COMPARISON              => 0x00002000
1162  };
1163  $ReturnValues{SQL_SQL92_RELATIONAL_JOIN_OPERATORS} =
1164  {
1165    SQL_SRJO_CORRESPONDING_CLAUSE             => 0x00000001
1166  , SQL_SRJO_CROSS_JOIN                       => 0x00000002
1167  , SQL_SRJO_EXCEPT_JOIN                      => 0x00000004
1168  , SQL_SRJO_FULL_OUTER_JOIN                  => 0x00000008
1169  , SQL_SRJO_INNER_JOIN                       => 0x00000010
1170  , SQL_SRJO_INTERSECT_JOIN                   => 0x00000020
1171  , SQL_SRJO_LEFT_OUTER_JOIN                  => 0x00000040
1172  , SQL_SRJO_NATURAL_JOIN                     => 0x00000080
1173  , SQL_SRJO_RIGHT_OUTER_JOIN                 => 0x00000100
1174  , SQL_SRJO_UNION_JOIN                       => 0x00000200
1175  };
1176  $ReturnValues{SQL_SQL92_REVOKE} =
1177  {
1178    SQL_SR_USAGE_ON_DOMAIN                    => 0x00000001
1179  , SQL_SR_USAGE_ON_CHARACTER_SET             => 0x00000002
1180  , SQL_SR_USAGE_ON_COLLATION                 => 0x00000004
1181  , SQL_SR_USAGE_ON_TRANSLATION               => 0x00000008
1182  , SQL_SR_GRANT_OPTION_FOR                   => 0x00000010
1183  , SQL_SR_CASCADE                            => 0x00000020
1184  , SQL_SR_RESTRICT                           => 0x00000040
1185  , SQL_SR_DELETE_TABLE                       => 0x00000080
1186  , SQL_SR_INSERT_TABLE                       => 0x00000100
1187  , SQL_SR_INSERT_COLUMN                      => 0x00000200
1188  , SQL_SR_REFERENCES_TABLE                   => 0x00000400
1189  , SQL_SR_REFERENCES_COLUMN                  => 0x00000800
1190  , SQL_SR_SELECT_TABLE                       => 0x00001000
1191  , SQL_SR_UPDATE_TABLE                       => 0x00002000
1192  , SQL_SR_UPDATE_COLUMN                      => 0x00004000
1193  };
1194  $ReturnValues{SQL_SQL92_ROW_VALUE_CONSTRUCTOR} =
1195  {
1196    SQL_SRVC_VALUE_EXPRESSION                 => 0x00000001
1197  , SQL_SRVC_NULL                             => 0x00000002
1198  , SQL_SRVC_DEFAULT                          => 0x00000004
1199  , SQL_SRVC_ROW_SUBQUERY                     => 0x00000008
1200  };
1201  $ReturnValues{SQL_SQL92_STRING_FUNCTIONS} =
1202  {
1203    SQL_SSF_CONVERT                           => 0x00000001
1204  , SQL_SSF_LOWER                             => 0x00000002
1205  , SQL_SSF_UPPER                             => 0x00000004
1206  , SQL_SSF_SUBSTRING                         => 0x00000008
1207  , SQL_SSF_TRANSLATE                         => 0x00000010
1208  , SQL_SSF_TRIM_BOTH                         => 0x00000020
1209  , SQL_SSF_TRIM_LEADING                      => 0x00000040
1210  , SQL_SSF_TRIM_TRAILING                     => 0x00000080
1211  };
1212  $ReturnValues{SQL_SQL92_VALUE_EXPRESSIONS} =
1213  {
1214    SQL_SVE_CASE                              => 0x00000001
1215  , SQL_SVE_CAST                              => 0x00000002
1216  , SQL_SVE_COALESCE                          => 0x00000004
1217  , SQL_SVE_NULLIF                            => 0x00000008
1218  };
1219  $ReturnValues{SQL_SQL_CONFORMANCE} =
1220  {
1221    SQL_SC_SQL92_ENTRY                        => 0x00000001
1222  , SQL_SC_FIPS127_2_TRANSITIONAL             => 0x00000002
1223  , SQL_SC_SQL92_INTERMEDIATE                 => 0x00000004
1224  , SQL_SC_SQL92_FULL                         => 0x00000008
1225  };
1226  $ReturnValues{SQL_STANDARD_CLI_CONFORMANCE} =
1227  {
1228    SQL_SCC_XOPEN_CLI_VERSION1                => 0x00000001
1229  , SQL_SCC_ISO92_CLI                         => 0x00000002
1230  };
1231  $ReturnValues{SQL_STATIC_SENSITIVITY} =
1232  {
1233    SQL_SS_ADDITIONS                          => 0x00000001
1234  , SQL_SS_DELETIONS                          => 0x00000002
1235  , SQL_SS_UPDATES                            => 0x00000004
1236  };
1237  $ReturnValues{SQL_STRING_FUNCTIONS} =
1238  {
1239    SQL_FN_STR_CONCAT                         => 0x00000001
1240  , SQL_FN_STR_INSERT                         => 0x00000002
1241  , SQL_FN_STR_LEFT                           => 0x00000004
1242  , SQL_FN_STR_LTRIM                          => 0x00000008
1243  , SQL_FN_STR_LENGTH                         => 0x00000010
1244  , SQL_FN_STR_LOCATE                         => 0x00000020
1245  , SQL_FN_STR_LCASE                          => 0x00000040
1246  , SQL_FN_STR_REPEAT                         => 0x00000080
1247  , SQL_FN_STR_REPLACE                        => 0x00000100
1248  , SQL_FN_STR_RIGHT                          => 0x00000200
1249  , SQL_FN_STR_RTRIM                          => 0x00000400
1250  , SQL_FN_STR_SUBSTRING                      => 0x00000800
1251  , SQL_FN_STR_UCASE                          => 0x00001000
1252  , SQL_FN_STR_ASCII                          => 0x00002000
1253  , SQL_FN_STR_CHAR                           => 0x00004000
1254  , SQL_FN_STR_DIFFERENCE                     => 0x00008000
1255  , SQL_FN_STR_LOCATE_2                       => 0x00010000
1256  , SQL_FN_STR_SOUNDEX                        => 0x00020000
1257  , SQL_FN_STR_SPACE                          => 0x00040000
1258  , SQL_FN_STR_BIT_LENGTH                     => 0x00080000
1259  , SQL_FN_STR_CHAR_LENGTH                    => 0x00100000
1260  , SQL_FN_STR_CHARACTER_LENGTH               => 0x00200000
1261  , SQL_FN_STR_OCTET_LENGTH                   => 0x00400000
1262  , SQL_FN_STR_POSITION                       => 0x00800000
1263  };
1264  $ReturnValues{SQL_SUBQUERIES} =
1265  {
1266    SQL_SQ_COMPARISON                         => 0x00000001
1267  , SQL_SQ_EXISTS                             => 0x00000002
1268  , SQL_SQ_IN                                 => 0x00000004
1269  , SQL_SQ_QUANTIFIED                         => 0x00000008
1270  , SQL_SQ_CORRELATED_SUBQUERIES              => 0x00000010
1271  };
1272  $ReturnValues{SQL_SYSTEM_FUNCTIONS} =
1273  {
1274    SQL_FN_SYS_USERNAME                       => 0x00000001
1275  , SQL_FN_SYS_DBNAME                         => 0x00000002
1276  , SQL_FN_SYS_IFNULL                         => 0x00000004
1277  };
1278  $ReturnValues{SQL_TIMEDATE_ADD_INTERVALS} =
1279  {
1280    SQL_FN_TSI_FRAC_SECOND                    => 0x00000001
1281  , SQL_FN_TSI_SECOND                         => 0x00000002
1282  , SQL_FN_TSI_MINUTE                         => 0x00000004
1283  , SQL_FN_TSI_HOUR                           => 0x00000008
1284  , SQL_FN_TSI_DAY                            => 0x00000010
1285  , SQL_FN_TSI_WEEK                           => 0x00000020
1286  , SQL_FN_TSI_MONTH                          => 0x00000040
1287  , SQL_FN_TSI_QUARTER                        => 0x00000080
1288  , SQL_FN_TSI_YEAR                           => 0x00000100
1289  };
1290  $ReturnValues{SQL_TIMEDATE_FUNCTIONS} =
1291  {
1292    SQL_FN_TD_NOW                             => 0x00000001
1293  , SQL_FN_TD_CURDATE                         => 0x00000002
1294  , SQL_FN_TD_DAYOFMONTH                      => 0x00000004
1295  , SQL_FN_TD_DAYOFWEEK                       => 0x00000008
1296  , SQL_FN_TD_DAYOFYEAR                       => 0x00000010
1297  , SQL_FN_TD_MONTH                           => 0x00000020
1298  , SQL_FN_TD_QUARTER                         => 0x00000040
1299  , SQL_FN_TD_WEEK                            => 0x00000080
1300  , SQL_FN_TD_YEAR                            => 0x00000100
1301  , SQL_FN_TD_CURTIME                         => 0x00000200
1302  , SQL_FN_TD_HOUR                            => 0x00000400
1303  , SQL_FN_TD_MINUTE                          => 0x00000800
1304  , SQL_FN_TD_SECOND                          => 0x00001000
1305  , SQL_FN_TD_TIMESTAMPADD                    => 0x00002000
1306  , SQL_FN_TD_TIMESTAMPDIFF                   => 0x00004000
1307  , SQL_FN_TD_DAYNAME                         => 0x00008000
1308  , SQL_FN_TD_MONTHNAME                       => 0x00010000
1309  , SQL_FN_TD_CURRENT_DATE                    => 0x00020000
1310  , SQL_FN_TD_CURRENT_TIME                    => 0x00040000
1311  , SQL_FN_TD_CURRENT_TIMESTAMP               => 0x00080000
1312  , SQL_FN_TD_EXTRACT                         => 0x00100000
1313  };
1314  $ReturnValues{SQL_TXN_CAPABLE} =
1315  {
1316    SQL_TC_NONE                               => 0
1317  , SQL_TC_DML                                => 1
1318  , SQL_TC_ALL                                => 2
1319  , SQL_TC_DDL_COMMIT                         => 3
1320  , SQL_TC_DDL_IGNORE                         => 4
1321  };
1322  $ReturnValues{SQL_TRANSACTION_ISOLATION_OPTION} =
1323  {
1324    SQL_TRANSACTION_READ_UNCOMMITTED          => 0x00000001  # SQL_TXN_READ_UNCOMMITTED
1325  , SQL_TRANSACTION_READ_COMMITTED            => 0x00000002  # SQL_TXN_READ_COMMITTED
1326  , SQL_TRANSACTION_REPEATABLE_READ           => 0x00000004  # SQL_TXN_REPEATABLE_READ
1327  , SQL_TRANSACTION_SERIALIZABLE              => 0x00000008  # SQL_TXN_SERIALIZABLE
1328  };
1329  $ReturnValues{SQL_DEFAULT_TRANSACTION_ISOLATION} = $ReturnValues{SQL_TRANSACTION_ISOLATION_OPTION};
1330  
1331  $ReturnValues{SQL_TXN_ISOLATION_OPTION} =
1332  {
1333    SQL_TXN_READ_UNCOMMITTED                  => 0x00000001
1334  , SQL_TXN_READ_COMMITTED                    => 0x00000002
1335  , SQL_TXN_REPEATABLE_READ                   => 0x00000004
1336  , SQL_TXN_SERIALIZABLE                      => 0x00000008
1337  };
1338  $ReturnValues{SQL_DEFAULT_TXN_ISOLATION} = $ReturnValues{SQL_TXN_ISOLATION_OPTION};
1339  
1340  $ReturnValues{SQL_TXN_VERSIONING} =
1341  {
1342    SQL_TXN_VERSIONING                        => 0x00000010
1343  };
1344  $ReturnValues{SQL_UNION} =
1345  {
1346    SQL_U_UNION                               => 0x00000001
1347  , SQL_U_UNION_ALL                           => 0x00000002
1348  };
1349  $ReturnValues{SQL_UNION_STATEMENT} =
1350  {
1351    SQL_US_UNION                              => 0x00000001  # SQL_U_UNION
1352  , SQL_US_UNION_ALL                          => 0x00000002  # SQL_U_UNION_ALL
1353  };
1354  
1355  1;
1356  
1357  =head1 TODO
1358  
1359    Corrections?
1360    SQL_NULL_COLLATION: ODBC vs ANSI
1361    Unique values for $ReturnValues{...}?, e.g. SQL_FILE_USAGE
1362  
1363  =cut


Generated: Tue Mar 17 22:47:18 2015 Cross-referenced by PHPXref 0.7.1