[ 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/ -> ANSI.pm (source)

   1  # $Id: ANSI.pm 8696 2007-01-24 23:12:38Z timbo $
   2  #
   3  # Copyright (c) 2002  Tim Bunce  Ireland
   4  #
   5  # Constant data describing ANSI CLI info types and return values for the
   6  # 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::ANSI;
  12  
  13  =head1 NAME
  14  
  15  DBI::Const::GetInfo::ANSI - ISO/IEC SQL/CLI 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  See: A.1 C header file SQLCLI.H, Page 316, 317.
  26  
  27  The API for this module is private and subject to change.
  28  
  29  =head1 REFERENCES
  30  
  31    ISO/IEC FCD 9075-3:200x Information technology - Database Languages -
  32    SQL - Part 3: Call-Level Interface (SQL/CLI)
  33  
  34    SC32 N00744 = WG3:VIE-005 = H2-2002-007
  35  
  36    Date: 2002-01-15
  37  
  38  =cut
  39  
  40  my
  41  $VERSION = sprintf("2.%06d", q$Revision: 8696 $ =~ /(\d+)/o);
  42  
  43  
  44  %InfoTypes =
  45  (
  46    SQL_ALTER_TABLE                     =>      86
  47  , SQL_CATALOG_NAME                    =>   10003
  48  , SQL_COLLATING_SEQUENCE              =>   10004
  49  , SQL_CURSOR_COMMIT_BEHAVIOR          =>      23
  50  , SQL_CURSOR_SENSITIVITY              =>   10001
  51  , SQL_DATA_SOURCE_NAME                =>       2
  52  , SQL_DATA_SOURCE_READ_ONLY           =>      25
  53  , SQL_DBMS_NAME                       =>      17
  54  , SQL_DBMS_VERSION                    =>      18
  55  , SQL_DEFAULT_TRANSACTION_ISOLATION   =>      26
  56  , SQL_DESCRIBE_PARAMETER              =>   10002
  57  , SQL_FETCH_DIRECTION                 =>       8
  58  , SQL_GETDATA_EXTENSIONS              =>      81
  59  , SQL_IDENTIFIER_CASE                 =>      28
  60  , SQL_INTEGRITY                       =>      73
  61  , SQL_MAXIMUM_CATALOG_NAME_LENGTH     =>      34
  62  , SQL_MAXIMUM_COLUMNS_IN_GROUP_BY     =>      97
  63  , SQL_MAXIMUM_COLUMNS_IN_ORDER_BY     =>      99
  64  , SQL_MAXIMUM_COLUMNS_IN_SELECT       =>     100
  65  , SQL_MAXIMUM_COLUMNS_IN_TABLE        =>     101
  66  , SQL_MAXIMUM_COLUMN_NAME_LENGTH      =>      30
  67  , SQL_MAXIMUM_CONCURRENT_ACTIVITIES   =>       1
  68  , SQL_MAXIMUM_CURSOR_NAME_LENGTH      =>      31
  69  , SQL_MAXIMUM_DRIVER_CONNECTIONS      =>       0
  70  , SQL_MAXIMUM_IDENTIFIER_LENGTH       =>   10005
  71  , SQL_MAXIMUM_SCHEMA_NAME_LENGTH      =>      32
  72  , SQL_MAXIMUM_STMT_OCTETS             =>   20000
  73  , SQL_MAXIMUM_STMT_OCTETS_DATA        =>   20001
  74  , SQL_MAXIMUM_STMT_OCTETS_SCHEMA      =>   20002
  75  , SQL_MAXIMUM_TABLES_IN_SELECT        =>     106
  76  , SQL_MAXIMUM_TABLE_NAME_LENGTH       =>      35
  77  , SQL_MAXIMUM_USER_NAME_LENGTH        =>     107
  78  , SQL_NULL_COLLATION                  =>      85
  79  , SQL_ORDER_BY_COLUMNS_IN_SELECT      =>      90
  80  , SQL_OUTER_JOIN_CAPABILITIES         =>     115
  81  , SQL_SCROLL_CONCURRENCY              =>      43
  82  , SQL_SEARCH_PATTERN_ESCAPE           =>      14
  83  , SQL_SERVER_NAME                     =>      13
  84  , SQL_SPECIAL_CHARACTERS              =>      94
  85  , SQL_TRANSACTION_CAPABLE             =>      46
  86  , SQL_TRANSACTION_ISOLATION_OPTION    =>      72
  87  , SQL_USER_NAME                       =>      47
  88  );
  89  
  90  =head2 %ReturnTypes
  91  
  92  See: Codes and data types for implementation information (Table 28), Page 85, 86.
  93  
  94  Mapped to ODBC datatype names.
  95  
  96  =cut
  97  
  98  %ReturnTypes =                                                 #          maxlen
  99  (
 100    SQL_ALTER_TABLE                     => 'SQLUINTEGER bitmask' # INTEGER
 101  , SQL_CATALOG_NAME                    => 'SQLCHAR'             # CHARACTER   (1)
 102  , SQL_COLLATING_SEQUENCE              => 'SQLCHAR'             # CHARACTER (254)
 103  , SQL_CURSOR_COMMIT_BEHAVIOR          => 'SQLUSMALLINT'        # SMALLINT
 104  , SQL_CURSOR_SENSITIVITY              => 'SQLUINTEGER'         # INTEGER
 105  , SQL_DATA_SOURCE_NAME                => 'SQLCHAR'             # CHARACTER (128)
 106  , SQL_DATA_SOURCE_READ_ONLY           => 'SQLCHAR'             # CHARACTER   (1)
 107  , SQL_DBMS_NAME                       => 'SQLCHAR'             # CHARACTER (254)
 108  , SQL_DBMS_VERSION                    => 'SQLCHAR'             # CHARACTER (254)
 109  , SQL_DEFAULT_TRANSACTION_ISOLATION   => 'SQLUINTEGER'         # INTEGER
 110  , SQL_DESCRIBE_PARAMETER              => 'SQLCHAR'             # CHARACTER   (1)
 111  , SQL_FETCH_DIRECTION                 => 'SQLUINTEGER bitmask' # INTEGER
 112  , SQL_GETDATA_EXTENSIONS              => 'SQLUINTEGER bitmask' # INTEGER
 113  , SQL_IDENTIFIER_CASE                 => 'SQLUSMALLINT'        # SMALLINT
 114  , SQL_INTEGRITY                       => 'SQLCHAR'             # CHARACTER   (1)
 115  , SQL_MAXIMUM_CATALOG_NAME_LENGTH     => 'SQLUSMALLINT'        # SMALLINT
 116  , SQL_MAXIMUM_COLUMNS_IN_GROUP_BY     => 'SQLUSMALLINT'        # SMALLINT
 117  , SQL_MAXIMUM_COLUMNS_IN_ORDER_BY     => 'SQLUSMALLINT'        # SMALLINT
 118  , SQL_MAXIMUM_COLUMNS_IN_SELECT       => 'SQLUSMALLINT'        # SMALLINT
 119  , SQL_MAXIMUM_COLUMNS_IN_TABLE        => 'SQLUSMALLINT'        # SMALLINT
 120  , SQL_MAXIMUM_COLUMN_NAME_LENGTH      => 'SQLUSMALLINT'        # SMALLINT
 121  , SQL_MAXIMUM_CONCURRENT_ACTIVITIES   => 'SQLUSMALLINT'        # SMALLINT
 122  , SQL_MAXIMUM_CURSOR_NAME_LENGTH      => 'SQLUSMALLINT'        # SMALLINT
 123  , SQL_MAXIMUM_DRIVER_CONNECTIONS      => 'SQLUSMALLINT'        # SMALLINT
 124  , SQL_MAXIMUM_IDENTIFIER_LENGTH       => 'SQLUSMALLINT'        # SMALLINT
 125  , SQL_MAXIMUM_SCHEMA_NAME_LENGTH      => 'SQLUSMALLINT'        # SMALLINT
 126  , SQL_MAXIMUM_STMT_OCTETS             => 'SQLUSMALLINT'        # SMALLINT
 127  , SQL_MAXIMUM_STMT_OCTETS_DATA        => 'SQLUSMALLINT'        # SMALLINT
 128  , SQL_MAXIMUM_STMT_OCTETS_SCHEMA      => 'SQLUSMALLINT'        # SMALLINT
 129  , SQL_MAXIMUM_TABLES_IN_SELECT        => 'SQLUSMALLINT'        # SMALLINT
 130  , SQL_MAXIMUM_TABLE_NAME_LENGTH       => 'SQLUSMALLINT'        # SMALLINT
 131  , SQL_MAXIMUM_USER_NAME_LENGTH        => 'SQLUSMALLINT'        # SMALLINT
 132  , SQL_NULL_COLLATION                  => 'SQLUSMALLINT'        # SMALLINT
 133  , SQL_ORDER_BY_COLUMNS_IN_SELECT      => 'SQLCHAR'             # CHARACTER   (1)
 134  , SQL_OUTER_JOIN_CAPABILITIES         => 'SQLUINTEGER bitmask' # INTEGER
 135  , SQL_SCROLL_CONCURRENCY              => 'SQLUINTEGER bitmask' # INTEGER
 136  , SQL_SEARCH_PATTERN_ESCAPE           => 'SQLCHAR'             # CHARACTER   (1)
 137  , SQL_SERVER_NAME                     => 'SQLCHAR'             # CHARACTER (128)
 138  , SQL_SPECIAL_CHARACTERS              => 'SQLCHAR'             # CHARACTER (254)
 139  , SQL_TRANSACTION_CAPABLE             => 'SQLUSMALLINT'        # SMALLINT
 140  , SQL_TRANSACTION_ISOLATION_OPTION    => 'SQLUINTEGER bitmask' # INTEGER
 141  , SQL_USER_NAME                       => 'SQLCHAR'             # CHARACTER (128)
 142  );
 143  
 144  =head2 %ReturnValues
 145  
 146  See: A.1 C header file SQLCLI.H, Page 317, 318.
 147  
 148  =cut
 149  
 150  $ReturnValues{SQL_ALTER_TABLE} =
 151  {
 152    SQL_AT_ADD_COLUMN                         => 0x00000001
 153  , SQL_AT_DROP_COLUMN                        => 0x00000002
 154  , SQL_AT_ALTER_COLUMN                       => 0x00000004
 155  , SQL_AT_ADD_CONSTRAINT                     => 0x00000008
 156  , SQL_AT_DROP_CONSTRAINT                    => 0x00000010
 157  };
 158  $ReturnValues{SQL_CURSOR_COMMIT_BEHAVIOR} =
 159  {
 160    SQL_CB_DELETE                             => 0
 161  , SQL_CB_CLOSE                              => 1
 162  , SQL_CB_PRESERVE                           => 2
 163  };
 164  $ReturnValues{SQL_FETCH_DIRECTION} =
 165  {
 166    SQL_FD_FETCH_NEXT                         => 0x00000001
 167  , SQL_FD_FETCH_FIRST                        => 0x00000002
 168  , SQL_FD_FETCH_LAST                         => 0x00000004
 169  , SQL_FD_FETCH_PRIOR                        => 0x00000008
 170  , SQL_FD_FETCH_ABSOLUTE                     => 0x00000010
 171  , SQL_FD_FETCH_RELATIVE                     => 0x00000020
 172  };
 173  $ReturnValues{SQL_GETDATA_EXTENSIONS} =
 174  {
 175    SQL_GD_ANY_COLUMN                         => 0x00000001
 176  , SQL_GD_ANY_ORDER                          => 0x00000002
 177  };
 178  $ReturnValues{SQL_IDENTIFIER_CASE} =
 179  {
 180    SQL_IC_UPPER                              => 1
 181  , SQL_IC_LOWER                              => 2
 182  , SQL_IC_SENSITIVE                          => 3
 183  , SQL_IC_MIXED                              => 4
 184  };
 185  $ReturnValues{SQL_NULL_COLLATION} =
 186  {
 187    SQL_NC_HIGH                               => 1
 188  , SQL_NC_LOW                                => 2
 189  };
 190  $ReturnValues{SQL_OUTER_JOIN_CAPABILITIES} =
 191  {
 192    SQL_OUTER_JOIN_LEFT                       => 0x00000001
 193  , SQL_OUTER_JOIN_RIGHT                      => 0x00000002
 194  , SQL_OUTER_JOIN_FULL                       => 0x00000004
 195  , SQL_OUTER_JOIN_NESTED                     => 0x00000008
 196  , SQL_OUTER_JOIN_NOT_ORDERED                => 0x00000010
 197  , SQL_OUTER_JOIN_INNER                      => 0x00000020
 198  , SQL_OUTER_JOIN_ALL_COMPARISON_OPS         => 0x00000040
 199  };
 200  $ReturnValues{SQL_SCROLL_CONCURRENCY} =
 201  {
 202    SQL_SCCO_READ_ONLY                        => 0x00000001
 203  , SQL_SCCO_LOCK                             => 0x00000002
 204  , SQL_SCCO_OPT_ROWVER                       => 0x00000004
 205  , SQL_SCCO_OPT_VALUES                       => 0x00000008
 206  };
 207  $ReturnValues{SQL_TRANSACTION_ACCESS_MODE} =
 208  {
 209    SQL_TRANSACTION_READ_ONLY                 => 0x00000001
 210  , SQL_TRANSACTION_READ_WRITE                => 0x00000002
 211  };
 212  $ReturnValues{SQL_TRANSACTION_CAPABLE} =
 213  {
 214    SQL_TC_NONE                               => 0
 215  , SQL_TC_DML                                => 1
 216  , SQL_TC_ALL                                => 2
 217  , SQL_TC_DDL_COMMIT                         => 3
 218  , SQL_TC_DDL_IGNORE                         => 4
 219  };
 220  $ReturnValues{SQL_TRANSACTION_ISOLATION} =
 221  {
 222    SQL_TRANSACTION_READ_UNCOMMITTED          => 0x00000001
 223  , SQL_TRANSACTION_READ_COMMITTED            => 0x00000002
 224  , SQL_TRANSACTION_REPEATABLE_READ           => 0x00000004
 225  , SQL_TRANSACTION_SERIALIZABLE              => 0x00000008
 226  };
 227  
 228  1;
 229  
 230  =head1 TODO
 231  
 232  Corrections, e.g.:
 233  
 234    SQL_TRANSACTION_ISOLATION_OPTION vs. SQL_TRANSACTION_ISOLATION
 235  
 236  =cut


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