15.10 - QEPITEM Field - Call-Level Interface Version 2

Teradata Call-Level Interface Version 2 Reference for Mainframe-Attached Systems

prodname
Call-Level Interface Version 2
vrm_release
15.10
category
Programming Reference
featnum
B035-2417-035K

In the QEPITEM field, the following are valid item codes:

 

Table 41: QEPITEM Field Valid Item Codes 

Item Code

Name

Description

1

InstallationId

The Installationid

2

Sessioncharacterset

A session's character set name.
This item code is deprecated by item code 46, which provides exactly the same functionality.

3

Transactionsemanticssupport

Defines whether Transactionsemantics are supported

4

Languageconformancesupport

Defines whether Languageconformance is supported

5

Updatablecursorsupport

Defines whether Updatablecursors are supported

6

Referentialintegritysupport

Defines whether Referentialintegrity is supported

7

Defaulttransactionsemantics

A server's default Transactionsemantics

8

Extendedparcelsizesupport

Defines whether parcel sizes greater than 32767 bytes are supported

9

CLIv2release

The CLIv2 release

10

Serverparallelismfactor

The extent of a server's parallel processing

11

Maximumsegmentsize

The maximum size of a data segment

12

TDPrelease

A TDP's release information

13

Singlesignonsupport

Defines whether Singlesignon is supported

14

Sessionuserid

A session's userid

15

UPSERTsupport

Defines whether UPSERT SQL is supported

16

Arrayoperationssupport

Defines whether EXECUTEFOR SQL is supported

17

MERGEINTOsupport

Defines whether MERGEINTO SQL is supported

18

Largeobjectsupport

Defines whether Largeobjects are supported

19

Timingprecisionrange

The range of Timingprecision values

20

Extendedresponsesupport

Defines whether response sizes greater than 65535 bytes are supported

21

Expandedparcelheaderusage

Defines which parcels allow the alternate parcel header

22

Timestamptypessupport

Defines whether Timestamptypes are supported

23

Utilitydata

Data of interest only to proprietary utilities.

24

Aggregatesupportlist

List of selected other query items.

25

Responsepositioningsupport

Defines whether repositioning of response data is supported.

26

Dataencryptionsupport

Whether dataencryption is supported.

27

Requestmessagerelease

Message table release information.

28

Availablecharactersets

The names of the server's available character sets.

29

Enhancedstatementstatussupport

Whether the server supports enhanced statement results.

30

Userdefinedtypessupport

Whether SQL supports user‑defined data types.

31

APHresponse

Defines which response parcels permit the alternate parcel header.

32

Availablelogonmechanisms

The names of the available logon mechanisms.

33

Defaultcharacterset

The default character set name from either the HSHSPB or a Teradata Database's default character set.

34

Databaserelease

The Teradata Database release and version.

35

CLIv2limits

Teradata Database limits affecting an application's values for CLIv2 settings.

36

SQLlimits

Teradata Database limits affecting an application's use of SQL statements.

37

Relaxedcallargs

Defines whether relaxation of SQL CALL arguments is supported.

38

Statementinfosupport

Defines whether StatementInformation parcels are supported.

39

Integer/decimalenlargement

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

ReturnIdentityDatasupport

Defines whether data may be returned in response to an SQL Insert operation when Identity columns are involved.

41

Resultsetssupport

Defines whether stored procedures may return the results of their SQL statements to the application.

42

QueryBandsupport

Defines whether the Teradata SQL SET QUERY_BAND statement is supported.

43

Mergeintousage

Defines whether and how the SQL MERGE INTO statement is supported.

44

Loggingerrorsusage

Defines whether and how the Teradata SQL LOGGING ERRORS clause is supported.

45

Proceduredata

Data of interest to external Stored Procedures.

46

Sessioncharacterset

The name of the character set for the session.

47

Columncorrelationsupport

Defines whether the Teradata SQL CREATE, UPDATE, DROP, and HELP CORRELATION statements are supported.

48

Utilitysession

Session date. Used internally, only by Teradata utilities.

49

Databaseaccesspath

For mainframe‑attached systems, defines a TDPid used to access the requested database.

50

Trustedsessionsupport

Defines whether the Teradata SQL SET QUERY_BAND PROXYUSER statement is honored rather than silently ignored.

51

LOBNamesupport

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.

56

Statement Status Usage

Provides the Statement Status Usage support level.

57

Integrated LOB

Returns information indicating if Smart LOB Response or Request is supported. Also returns MultiPart Mode and Elicit Response, which are required.