QEPITEM Field
In the QEPITEM field, the following are valid item codes:
Item Code |
Name |
Description |
1 |
Installation‑Id |
The Installation‑id |
2 |
Session‑character‑set |
A session's character set name. |
3 |
Transaction‑semantics‑support |
Defines whether Transaction‑semantics are supported |
4 |
Language‑conformance‑support |
Defines whether Language‑conformance is supported |
5 |
Updatable‑cursor‑support |
Defines whether Updateble‑cursors are supported |
6 |
Referential‑integrity‑support |
Defines whether Referential‑integrity is supported |
7 |
Default‑transaction‑semantics |
A server's default Transaction‑semantics |
8 |
Extended‑parcel‑size‑support |
Defines whether parcel sizes greater than 32767 bytes are supported |
9 |
CLIv2‑release |
The CLIv2 release |
10 |
Server‑parallelism‑factor |
The extent of a server's parallel processing |
11 |
Maximum‑segment‑size |
The maximum size of a data segment |
12 |
TDP‑release |
A TDP's release information |
13 |
Single‑signon‑support |
Defines whether Single‑signon is supported |
14 |
Session‑userid |
A session's userid |
15 |
UPSERT‑support |
Defines whether UPSERT SQL is supported |
16 |
Array‑operations‑support |
Defines whether EXECUTE‑FOR SQL is supported |
17 |
MERGE‑INTO‑support |
Defines whether MERGE‑INTO SQL is supported |
18 |
Large‑object‑support |
Defines whether Large‑objects are supported |
19 |
Timing‑precision‑range |
The range of Timing‑precision values |
20 |
Extended‑response‑support |
Defines whether response sizes greater than 65535 bytes are supported |
21 |
Expanded‑parcel‑header‑usage |
Defines which parcels allow the alternate parcel header |
22 |
Timestamp‑types‑support |
Defines whether Timestamp‑types are supported |
23 |
Utility‑data |
Data of interest only to proprietary utilities. |
24 |
Aggregate‑support‑list |
List of selected other query items. |
25 |
Response‑positioning‑support |
Defines whether repositioning of response data is supported. |
26 |
Data‑encryption‑support |
Whether data‑encryption is supported. |
27 |
Request‑message‑release |
Message table release information. |
28 |
Available‑character‑sets |
The names of the server's available character sets. |
29 |
Enhanced‑statement‑status‑support |
Whether the server supports enhanced statement results. |
30 |
User‑defined‑types‑support |
Whether SQL supports user‑defined data types. |
31 |
APH‑response |
Defines which response parcels permit the alternate parcel header. |
32 |
Available‑logon‑mechanisms |
The names of the available logon mechanisms. |
33 |
Default‑character‑set |
The default character set name from either the HSHSPB or a Teradata Database's default character set. |
34 |
Database‑release |
The Teradata Database release and version. |
35 |
CLIv2‑limits |
Teradata Database limits affecting an application's values for CLIv2 settings. |
36 |
SQL‑limits |
Teradata Database limits affecting an application's use of SQL statements. |
37 |
Relaxed‑call‑args |
Defines whether relaxation of SQL CALL arguments is supported. |
38 |
Statement‑info‑support |
Defines whether StatementInformation parcels are supported. |
39 |
Integer/decimal‑enlargement |
Defines whether the BIGINT data type is supported, precision for DECIMAL data types may exceed 18, or the maximum precision for decimal data types in responses may be specified. |
40 |
Return‑Identity‑Data‑support |
Defines whether data may be returned in response to an SQL Insert operation when Identity columns are involved. |
41 |
Result‑sets‑support |
Defines whether stored procedures may return the results of their SQL statements to the application. |
42 |
QueryBand‑support |
Defines whether the Teradata SQL SET QUERY_BAND statement is supported. |
43 |
Merge‑into‑usage |
Defines whether and how the SQL MERGE INTO statement is supported. |
44 |
Logging‑errors‑usage |
Defines whether and how the Teradata SQL LOGGING ERRORS clause is supported. |
45 |
Procedure‑data |
Data of interest to external Stored Procedures. |
46 |
Session‑character‑set |
The name of the character set for the session. |
47 |
Column‑correlation‑support |
Defines whether the Teradata SQL CREATE, UPDATE, DROP, and HELP CORRELATION statements are supported. |
48 |
Utility‑session |
Session date. Used internally, only by Teradata utilities. |
49 |
Database‑access‑path |
For mainframe‑attached systems, defines a TDPid used to access the requested database. |
50 |
Trusted‑session‑support |
Defines whether the Teradata SQL SET QUERY_BAND PROXYUSER statement is honored rather than silently ignored. |
51 |
LOB‑Name‑support |
Defines whether the BY NAME phrase is permitted in the USING row descriptor in a request string. |
52 |
Transforms‑off‑usage |
Defines whether the constituent attributes of SQL Structured User Defined Types (UDTs) may be referenced. |
53 |
Trusted‑request‑support |
Defines whether a request may indicate whether it is trusted to use the Teradata SQL SET‘ QUERY_BAND='PROXYUSER=...' statement to change the session userid. |
54 |
Build‑information |
Session data of interest only to advanced applications building their own request parcels (DBCAREA option Request‑mode=B). |
55 |
Statement‑Independence‑support |
Defines whether the connected DBS support returns StatementError Parcels for certain multi‑statement queries. |