MVS_FTPSQL/GetInfo.pm

filter: Statementstmt 70.5% 12 / 17 Branchbran n/a Conditioncond 0.0% 0 / 3 MC/DCmcdc 0.0% 0 / 2 Subroutinesub 40.0% 2 / 5 Podpod 0.0% 0 / 3 totaltotal 46.6% 14 / 30 CC 2 SCAR 11.0
CC
2
Cov
60%
sql_user_name
6.0
sql_keywords
2.0
sql_data_source_name
2.0
CRAP 3.0
« MVS_FTPSQL.pm ↑ Summary MVS_FTPSQL/TypeInfo.pm »
1 # Transfer this to lib/DBD/MVS_FTPSQL/GetInfo.pm
2
3 # The %info hash was automatically generated by
4 # DBI::DBD::Metadata::write_getinfo_pm v1.05.
5
6 package DBD::MVS_FTPSQL::GetInfo;
7
8 1 ▶use strict;
Subroutine BEGIN: called CC=1 SCAR=0.0
9 1 ▶use DBD::MVS_FTPSQL;
Subroutine BEGIN: called CC=1 SCAR=0.0
10
11 # Beware: not officially documented interfaces...
12 # use DBI::Const::GetInfoType qw(%GetInfoType);
13 # use DBI::Const::GetInfoReturn qw(%GetInfoReturnTypes %GetInfoReturnValues);
14
15 1 my $sql_driver = 'MVS_FTPSQL';
16 1 my $sql_ver_fmt = '%02d.%02d.%04d'; # ODBC version string: ##.##.#####
17 1 my $sql_driver_ver = sprintf $sql_ver_fmt, split (/\./, $DBD::MVS_FTPSQL::VERSION);
18
19 1 my @Keywords = qw(
20
21 HOST;PORT;DATABASE;UID;PWD;DSN
22 );
23
24
25 0 ▶sub sql_keywords {
Subroutine sql_keywords: not called CC=1 SCAR=6.9
Pod undocumented
26
27 0 return join ',', @Keywords;
28
29 }
30
31
32
33 0 ▶sub sql_data_source_name {
Subroutine sql_data_source_name: not called CC=1 SCAR=6.9
Pod undocumented
34 0 my $dbh = shift;
35 0 return "dbi:$sql_driver:" . $dbh->{Name};
36 }
37
38 0 ▶sub sql_user_name {
Subroutine sql_user_name: not called CC=2 SCAR=17.9
Pod undocumented
39 0 my $dbh = shift;
40 # CURRENT_USER is a non-standard attribute, probably undef
41 # Username is a standard DBI attribute
42 0 ▶ return $dbh->{CURRENT_USER} || $dbh->{Username};
Condition0%0/3
$dbh->{'CURRENT_USER'} || $dbh->{'Username'}
l!l&&r!l&&!r
000
MC/DC0%0/2
$dbh->{'CURRENT_USER'} || $dbh->{'Username'}
$dbh->{'CURRENT_USER'} $dbh->{'Username'}
Truth table0%0/3
A || B
A= $dbh->{'CURRENT_USER'}B= $dbh->{'Username'}
ABresult
1X1
011
000
43 }
44
45
46 our %info = (
47 20 => 'N', # SQL_ACCESSIBLE_PROCEDURES
48 19 => 'N', # SQL_ACCESSIBLE_TABLES
49 0 => 0, # SQL_ACTIVE_CONNECTIONS
50 116 => 1, # SQL_ACTIVE_ENVIRONMENTS
51 1 => 0, # SQL_ACTIVE_STATEMENTS
52 #db get_info failed: odbc_get_info/SQLGetInfo err=-1
53 # 169 => undef, # SQL_AGGREGATE_FUNCTIONS
54 117 => 0, # SQL_ALTER_DOMAIN
55 86 => 12393, # SQL_ALTER_TABLE
56 10021 => 0, # SQL_ASYNC_MODE
57 120 => 4, # SQL_BATCH_ROW_COUNT
58 121 => 15, # SQL_BATCH_SUPPORT
59 82 => 90, # SQL_BOOKMARK_PERSISTENCE
60 114 => 0, # SQL_CATALOG_LOCATION
61 10003 => 'N', # SQL_CATALOG_NAME
62 41 => '.', # SQL_CATALOG_NAME_SEPARATOR
63 42 => 'CATALOG', # SQL_CATALOG_TERM
64 92 => 0, # SQL_CATALOG_USAGE
65 10004 => '', # SQL_COLLATING_SEQUENCE
66 10004 => '', # SQL_COLLATION_SEQ
67 87 => 'Y', # SQL_COLUMN_ALIAS
68 22 => 0, # SQL_CONCAT_NULL_BEHAVIOR
69 53 => 0, # SQL_CONVERT_BIGINT
70 54 => 0, # SQL_CONVERT_BINARY
71 55 => 0, # SQL_CONVERT_BIT
72 56 => 0, # SQL_CONVERT_CHAR
73 57 => 0, # SQL_CONVERT_DATE
74 58 => 0, # SQL_CONVERT_DECIMAL
75 59 => 0, # SQL_CONVERT_DOUBLE
76 60 => 0, # SQL_CONVERT_FLOAT
77 48 => 1, # SQL_CONVERT_FUNCTIONS
78 #db get_info failed: odbc_get_info/SQLGetInfo err=-1
79 # 173 => undef, # SQL_CONVERT_GUID
80 61 => 0, # SQL_CONVERT_INTEGER
81 #db get_info failed: odbc_get_info/SQLGetInfo err=-1
82 # 123 => undef, # SQL_CONVERT_INTERVAL_DAY_TIME
83 #db get_info failed: odbc_get_info/SQLGetInfo err=-1
84 # 124 => undef, # SQL_CONVERT_INTERVAL_YEAR_MONTH
85 71 => 0, # SQL_CONVERT_LONGVARBINARY
86 62 => 0, # SQL_CONVERT_LONGVARCHAR
87 63 => 0, # SQL_CONVERT_NUMERIC
88 64 => 0, # SQL_CONVERT_REAL
89 65 => 0, # SQL_CONVERT_SMALLINT
90 66 => 0, # SQL_CONVERT_TIME
91 67 => 0, # SQL_CONVERT_TIMESTAMP
92 68 => 0, # SQL_CONVERT_TINYINT
93 69 => 0, # SQL_CONVERT_VARBINARY
94 70 => 0, # SQL_CONVERT_VARCHAR
95 #db get_info failed: odbc_get_info/SQLGetInfo err=-1
96 # 122 => undef, # SQL_CONVERT_WCHAR
97 #db get_info failed: odbc_get_info/SQLGetInfo err=-1
98 # 125 => undef, # SQL_CONVERT_WLONGVARCHAR
99 #db get_info failed: odbc_get_info/SQLGetInfo err=-1
100 # 126 => undef, # SQL_CONVERT_WVARCHAR
101 74 => 2, # SQL_CORRELATION_NAME
102 127 => 0, # SQL_CREATE_ASSERTION
103 128 => 0, # SQL_CREATE_CHARACTER_SET
104 129 => 0, # SQL_CREATE_COLLATION
105 130 => 0, # SQL_CREATE_DOMAIN
106 131 => 0, # SQL_CREATE_SCHEMA
107 132 => 1537, # SQL_CREATE_TABLE
108 133 => 0, # SQL_CREATE_TRANSLATION
109 134 => 3, # SQL_CREATE_VIEW
110 23 => 2, # SQL_CURSOR_COMMIT_BEHAVIOR
111 24 => 2, # SQL_CURSOR_ROLLBACK_BEHAVIOR
112 10001 => 0, # SQL_CURSOR_SENSITIVITY
113 16 => 'PG2DDSP', # SQL_DATABASE_NAME
114 2 => \&sql_data_source_name, # SQL_DATA_SOURCE_NAME
115 25 => 'N', # SQL_DATA_SOURCE_READ_ONLY
116 119 => 0, # SQL_DATETIME_LITERALS
117 17 => 'DB2', # SQL_DBMS_NAME
118 18 => '08.01.0000', # SQL_DBMS_VER
119 18 => '08.01.0000', # SQL_DBMS_VERSION
120 #db get_info failed: odbc_get_info/SQLGetInfo err=-1
121 # 170 => undef, # SQL_DDL_INDEX
122 26 => 2, # SQL_DEFAULT_TRANSACTION_ISOLATION
123 26 => 2, # SQL_DEFAULT_TXN_ISOLATION
124 10002 => 'Y', # SQL_DESCRIBE_PARAMETER
125 171 => '03.52.0002.0002', # SQL_DM_VER
126 3 => 157084600, # SQL_DRIVER_HDBC
127 # 135 => undef, # SQL_DRIVER_HDESC
128 4 => 157076488, # SQL_DRIVER_HENV
129 # 76 => undef, # SQL_DRIVER_HLIB
130 # 5 => undef, # SQL_DRIVER_HSTMT
131 1 6 => $INC{'DBD/MVS_FTPSQL.pm'}, # SQL_DRIVER_NAME
132 77 => '03.51', # SQL_DRIVER_ODBC_VER
133 7 => $sql_driver_ver, # SQL_DRIVER_VER
134 136 => 0, # SQL_DROP_ASSERTION
135 137 => 0, # SQL_DROP_CHARACTER_SET
136 138 => 0, # SQL_DROP_COLLATION
137 139 => 0, # SQL_DROP_DOMAIN
138 140 => 0, # SQL_DROP_SCHEMA
139 141 => 1, # SQL_DROP_TABLE
140 142 => 0, # SQL_DROP_TRANSLATION
141 143 => 1, # SQL_DROP_VIEW
142 144 => 0, # SQL_DYNAMIC_CURSOR_ATTRIBUTES1
143 145 => 0, # SQL_DYNAMIC_CURSOR_ATTRIBUTES2
144 27 => 'Y', # SQL_EXPRESSIONS_IN_ORDERBY
145 8 => 1, # SQL_FETCH_DIRECTION
146 84 => 0, # SQL_FILE_USAGE
147 146 => 57345, # SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES1
148 147 => 57345, # SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES2
149 81 => 3, # SQL_GETDATA_EXTENSIONS
150 88 => 1, # SQL_GROUP_BY
151 28 => 1, # SQL_IDENTIFIER_CASE
152 29 => '"', # SQL_IDENTIFIER_QUOTE_CHAR
153 148 => 3, # SQL_INDEX_KEYWORDS
154 149 => 0, # SQL_INFO_SCHEMA_VIEWS
155 #db get_info failed: odbc_get_info/SQLGetInfo err=-1
156 # 172 => undef, # SQL_INSERT_STATEMENT
157 73 => 'Y', # SQL_INTEGRITY
158 150 => 1048143, # SQL_KEYSET_CURSOR_ATTRIBUTES1
159 151 => 137, # SQL_KEYSET_CURSOR_ATTRIBUTES2
160 89 => \&sql_keywords, # SQL_KEYWORDS
161 113 => 'N', # SQL_LIKE_ESCAPE_CLAUSE
162 78 => 0, # SQL_LOCK_TYPES
163 34 => 0, # SQL_MAXIMUM_CATALOG_NAME_LENGTH
164 97 => 750, # SQL_MAXIMUM_COLUMNS_IN_GROUP_BY
165 98 => 64, # SQL_MAXIMUM_COLUMNS_IN_INDEX
166 99 => 750, # SQL_MAXIMUM_COLUMNS_IN_ORDER_BY
167 100 => 750, # SQL_MAXIMUM_COLUMNS_IN_SELECT
168 101 => 750, # SQL_MAXIMUM_COLUMNS_IN_TABLE
169 30 => 18, # SQL_MAXIMUM_COLUMN_NAME_LENGTH
170 1 => 0, # SQL_MAXIMUM_CONCURRENT_ACTIVITIES
171 31 => 18, # SQL_MAXIMUM_CURSOR_NAME_LENGTH
172 0 => 0, # SQL_MAXIMUM_DRIVER_CONNECTIONS
173 10005 => 18, # SQL_MAXIMUM_IDENTIFIER_LENGTH
174 102 => 254, # SQL_MAXIMUM_INDEX_SIZE
175 104 => 32706, # SQL_MAXIMUM_ROW_SIZE
176 32 => 32, # SQL_MAXIMUM_SCHEMA_NAME_LENGTH
177 105 => 32765, # SQL_MAXIMUM_STATEMENT_LENGTH
178 #db get_info failed: odbc_get_info/SQLGetInfo err=-1
179 # 20000 => undef, # SQL_MAXIMUM_STMT_OCTETS
180 #db get_info failed: odbc_get_info/SQLGetInfo err=-1
181 # 20001 => undef, # SQL_MAXIMUM_STMT_OCTETS_DATA
182 #db get_info failed: odbc_get_info/SQLGetInfo err=-1
183 # 20002 => undef, # SQL_MAXIMUM_STMT_OCTETS_SCHEMA
184 106 => 15, # SQL_MAXIMUM_TABLES_IN_SELECT
185 35 => 18, # SQL_MAXIMUM_TABLE_NAME_LENGTH
186 107 => 8, # SQL_MAXIMUM_USER_NAME_LENGTH
187 10022 => 0, # SQL_MAX_ASYNC_CONCURRENT_STATEMENTS
188 112 => 32704, # SQL_MAX_BINARY_LITERAL_LEN
189 34 => 0, # SQL_MAX_CATALOG_NAME_LEN
190 108 => 32704, # SQL_MAX_CHAR_LITERAL_LEN
191 97 => 750, # SQL_MAX_COLUMNS_IN_GROUP_BY
192 98 => 64, # SQL_MAX_COLUMNS_IN_INDEX
193 99 => 750, # SQL_MAX_COLUMNS_IN_ORDER_BY
194 100 => 750, # SQL_MAX_COLUMNS_IN_SELECT
195 101 => 750, # SQL_MAX_COLUMNS_IN_TABLE
196 30 => 18, # SQL_MAX_COLUMN_NAME_LEN
197 1 => 0, # SQL_MAX_CONCURRENT_ACTIVITIES
198 31 => 18, # SQL_MAX_CURSOR_NAME_LEN
199 0 => 0, # SQL_MAX_DRIVER_CONNECTIONS
200 10005 => 18, # SQL_MAX_IDENTIFIER_LEN
201 102 => 254, # SQL_MAX_INDEX_SIZE
202 32 => 32, # SQL_MAX_OWNER_NAME_LEN
203 33 => 32, # SQL_MAX_PROCEDURE_NAME_LEN
204 34 => 0, # SQL_MAX_QUALIFIER_NAME_LEN
205 104 => 32706, # SQL_MAX_ROW_SIZE
206 103 => 'Y', # SQL_MAX_ROW_SIZE_INCLUDES_LONG
207 32 => 32, # SQL_MAX_SCHEMA_NAME_LEN
208 105 => 32765, # SQL_MAX_STATEMENT_LEN
209 106 => 15, # SQL_MAX_TABLES_IN_SELECT
210 35 => 18, # SQL_MAX_TABLE_NAME_LEN
211 107 => 8, # SQL_MAX_USER_NAME_LEN
212 37 => 'N', # SQL_MULTIPLE_ACTIVE_TXN
213 36 => 'Y', # SQL_MULT_RESULT_SETS
214 111 => 'N', # SQL_NEED_LONG_DATA_LEN
215 75 => 1, # SQL_NON_NULLABLE_COLUMNS
216 85 => 0, # SQL_NULL_COLLATION
217 49 => 16711551, # SQL_NUMERIC_FUNCTIONS
218 9 => 2, # SQL_ODBC_API_CONFORMANCE
219 152 => 2, # SQL_ODBC_INTERFACE_CONFORMANCE
220 12 => 1, # SQL_ODBC_SAG_CLI_CONFORMANCE
221 15 => 2, # SQL_ODBC_SQL_CONFORMANCE
222 73 => 'Y', # SQL_ODBC_SQL_OPT_IEF
223 10 => '03.52', # SQL_ODBC_VER
224 115 => 127, # SQL_OJ_CAPABILITIES
225 90 => 'N', # SQL_ORDER_BY_COLUMNS_IN_SELECT
226 38 => 'Y', # SQL_OUTER_JOINS
227 115 => 127, # SQL_OUTER_JOIN_CAPABILITIES
228 39 => 'CREATOR', # SQL_OWNER_TERM
229 91 => 29, # SQL_OWNER_USAGE
230 153 => 1, # SQL_PARAM_ARRAY_ROW_COUNTS
231 154 => 1, # SQL_PARAM_ARRAY_SELECTS
232 80 => 7, # SQL_POSITIONED_STATEMENTS
233 79 => 31, # SQL_POS_OPERATIONS
234 21 => 'Y', # SQL_PROCEDURES
235 40 => 'stored procedures', # SQL_PROCEDURE_TERM
236 114 => 0, # SQL_QUALIFIER_LOCATION
237 41 => '.', # SQL_QUALIFIER_NAME_SEPARATOR
238 42 => 'CATALOG', # SQL_QUALIFIER_TERM
239 92 => 0, # SQL_QUALIFIER_USAGE
240 93 => 3, # SQL_QUOTED_IDENTIFIER_CASE
241 11 => 'N', # SQL_ROW_UPDATES
242 39 => 'CREATOR', # SQL_SCHEMA_TERM
243 91 => 29, # SQL_SCHEMA_USAGE
244 43 => 1, # SQL_SCROLL_CONCURRENCY
245 44 => 19, # SQL_SCROLL_OPTIONS
246 14 => '', # SQL_SEARCH_PATTERN_ESCAPE
247 13 => 'DCS5D15', # SQL_SERVER_NAME
248 94 => '@#', # SQL_SPECIAL_CHARACTERS
249 155 => 7, # SQL_SQL92_DATETIME_FUNCTIONS
250 156 => 11, # SQL_SQL92_FOREIGN_KEY_DELETE_RULE
251 157 => 0, # SQL_SQL92_FOREIGN_KEY_UPDATE_RULE
252 158 => 8048, # SQL_SQL92_GRANT
253 159 => 0, # SQL_SQL92_NUMERIC_VALUE_FUNCTIONS
254 160 => 15879, # SQL_SQL92_PREDICATES
255 161 => 344, # SQL_SQL92_RELATIONAL_JOIN_OPERATORS
256 162 => 13696, # SQL_SQL92_REVOKE
257 163 => 0, # SQL_SQL92_ROW_VALUE_CONSTRUCTOR
258 164 => 0, # SQL_SQL92_STRING_FUNCTIONS
259 165 => 5, # SQL_SQL92_VALUE_EXPRESSIONS
260 118 => 1, # SQL_SQL_CONFORMANCE
261 166 => 1, # SQL_STANDARD_CLI_CONFORMANCE
262 167 => 0, # SQL_STATIC_CURSOR_ATTRIBUTES1
263 168 => 131, # SQL_STATIC_CURSOR_ATTRIBUTES2
264 83 => 0, # SQL_STATIC_SENSITIVITY
265 50 => 335871, # SQL_STRING_FUNCTIONS
266 95 => 31, # SQL_SUBQUERIES
267 51 => 7, # SQL_SYSTEM_FUNCTIONS
268 45 => 'table', # SQL_TABLE_TERM
269 109 => 0, # SQL_TIMEDATE_ADD_INTERVALS
270 110 => 0, # SQL_TIMEDATE_DIFF_INTERVALS
271 52 => 8190, # SQL_TIMEDATE_FUNCTIONS
272 46 => 2, # SQL_TRANSACTION_CAPABLE
273 72 => 15, # SQL_TRANSACTION_ISOLATION_OPTION
274 46 => 2, # SQL_TXN_CAPABLE
275 72 => 15, # SQL_TXN_ISOLATION_OPTION
276 96 => 3, # SQL_UNION
277 96 => 3, # SQL_UNION_STATEMENT
278 47 => \&sql_user_name, # SQL_USER_NAME
279 10000 => 1996, # SQL_XOPEN_CLI_YEAR
280 );
281
282 1 1;
283
284 =head1 NAME
285
286 DBD::MVS_FTPSQL::GetInfo - SQL/CLI Constants for GetInfo
287
288 =head1 SYNOPSIS
289
290 The API for this module is private.
291
292 =head1 DESCRIPTION
293
294 Information requested by GetInfo().
295
296 =cut
297
298 __END__
« MVS_FTPSQL.pm ↑ Summary MVS_FTPSQL/TypeInfo.pm »