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. This item code is deprecated by item code 46 Session-character-set, which provides exactly the same information. |
| 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 Updatable-cursors are supported |
| 6 | Referential-integrity-support | Defines whether Referential-integrity is supported |
| 7 | Default-transaction-semantics | The default Transaction-semantics on the database |
| 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 parallel processing on the database |
| 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. This item is deprecated by item code 57, Integrated-LOB, whose QERILLO value provides exactly the same information. |
| 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 character sets installed and activated on the database. |
| 29 | Enhanced-statement-status-support | Whether the database 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 database's default character set. |
| 34 | Database-release | Vantage release and version. |
| 35 | CLIv2-limits | Database limits affecting an application's values for CLIv2 settings. |
| 36 | SQL-limits | 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 | Data of interest only to proprietary 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. This item is deprecated by item code 57, Integrated-LOB, whose QERILLN value provides exactly the same information. |
| 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 | Multiple-statement-errors-support | Defines whether multi-statement SQL requests may return errors for multiple statements in one response. |
| 56 | Statement-status-usage | Defines whether and when Statement-status parcels may be returned. |
| 57 | Integrated-LOB | Provides whether and how Large-objects (LOBs) are supported by the database. |
| 58 | Unicode Pass Through | Provides the Unicode Pass Through usage level. |
| 59 | StatementInformation-Request-usage | Defines whether StatementInformation parcels may be used in the DBCAREA Parameter-description-pointer area. |
| 60 | SET-TRANSFORM-support | Defines whether a request may contain a SET TRANSFORM SQL statement. |