← Index
NYTProf Performance Profile   « block view • line view • sub view »
For ddd2.pl
  Run on Tue May 25 16:52:24 2010
Reported on Tue May 25 16:56:45 2010

File /project/perl/lib/DBI/Const/GetInfo/ANSI.pm
Statements Executed 15
Statement Execution Time 339µs
Call graph for these subroutines as a Graphviz dot language file.
Line State
ments
Time
on line
Calls Time
in subs
Code
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
11package DBI::Const::GetInfo::ANSI;
12
13=head1 NAME
14
15DBI::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
23Information requested by GetInfo().
24
25See: A.1 C header file SQLCLI.H, Page 316, 317.
26
27The 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
40my
41167µs117µs$VERSION = sprintf("2.%06d", q$Revision: 8696 $ =~ /(\d+)/o);
# spent 17µs making 1 call to DBI::Const::GetInfo::ANSI::CORE:match
42
43
44148µs%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
92See: Codes and data types for implementation information (Table 28), Page 85, 86.
93
94Mapped to ODBC datatype names.
95
96=cut
97
98163µs%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
146See: A.1 C header file SQLCLI.H, Page 317, 318.
147
148=cut
149
150112µs$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};
15818µs$ReturnValues{SQL_CURSOR_COMMIT_BEHAVIOR} =
159{
160 SQL_CB_DELETE => 0
161, SQL_CB_CLOSE => 1
162, SQL_CB_PRESERVE => 2
163};
164110µs$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};
17316µs$ReturnValues{SQL_GETDATA_EXTENSIONS} =
174{
175 SQL_GD_ANY_COLUMN => 0x00000001
176, SQL_GD_ANY_ORDER => 0x00000002
177};
17818µs$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};
18517µs$ReturnValues{SQL_NULL_COLLATION} =
186{
187 SQL_NC_HIGH => 1
188, SQL_NC_LOW => 2
189};
190110µs$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};
200110µs$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};
20716µs$ReturnValues{SQL_TRANSACTION_ACCESS_MODE} =
208{
209 SQL_TRANSACTION_READ_ONLY => 0x00000001
210, SQL_TRANSACTION_READ_WRITE => 0x00000002
211};
21218µs$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};
22018µs$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
228168µs1;
229
230=head1 TODO
231
232Corrections, e.g.:
233
234 SQL_TRANSACTION_ISOLATION_OPTION vs. SQL_TRANSACTION_ISOLATION
235
236=cut