15.10 - Aggregate-support-list - 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

Aggregate‑support‑list might be used to obtain the results for several queries useful when establishing a connection.

Refers to the TDP whose TDP identifier is addressed by the QEPTIDP field and has length specified by the QEPTLEN field. Since they do not apply, the QEPRQST and QEPTOKEN fields must contain binary zeroes.

Returns a list of pre-determined items that also can be queried individually. The format of, and values returned for, each item are exactly the same as when that item is queried individually. As new support-type items are added in the future, they will also be added to this aggregate list. Therefore, the length of the result may vary depending on the version of CLIv2 or TDP.

Note: Since there is only one return code for all items, item-specific errors cannot all be reported. Instead, that item will return a value of 'N' (no support).

 

Item Code

Mnemonic

Response DBQERASL(DbqerASL for C)

Field

Value

24

QEPIASL

QERASLTS
(semanticsStatus for C)
is Transaction
semanticssupport

One of the following EBCDIC characters:

'N' with mnemonic QERTSMN
(QER_NotSupported for C)
(QERASLTSN for COBOL)

'Y' with mnemonic QERTSMY
(QER_Supported for C)
(QERASLTSY for COBOL)

 

 

QERASLLC
(conformanceStatus for C)
is Language
conformancesupport

One of the following EBCDIC characters:

'N' with mnemonic QERLCSN
(QER_NotSupported for C)
(QERASLLCN for COBOL)

'Y' with mnemonic QERLCSY
(QER_Supported for C)
(QERASLLCY for COBOL)

 

 

QERASLUC (UpdatableCursorStatus for C)
is Updatable
cursorsupport

One of the following EBCDIC characters:

'N' with mnemonic QERUCRN
(QER_NotSupported for C)
(QERASLUCN for COBOL)

'Y' with mnemonic QERUCRY
(QER_Supported for C)
(QERASLUCY for COBOL)

 

 

QERASLRI (referentialIntegrityStatus for C)
is Referential
integritysupport

One of the following EBCDIC characters:

'N' with mnemonic QERRFIN
(QER_NotSupported for C) (QERASLRIN for COBOL)

'Y' with mnemonic QERRFIY
(QER_Supported for C) (QERASLRIY for COBOL)

 

 

QERASLEP
(extendedParcelStatus for C)
is Extended
parcel sizesupport

One of the following EBCDIC characters:

’N’ with mnemonic QEREPSN
(QER_NotSupported for C) (QERASLEPN for COBOL)

'Y''Y' with mnemonic QEREPSY
(QER_Supported for C) (QERASLEPY for COBOL)

 

 

QERASLSS
(singleSignonStatus for C)
is Single
signonsupport

One of the following EBCDIC characters:

'N' with mnemonic QERSSON
(QER_NotSupported for C)
(QERASLSSN for COBOL)

'Y' with mnemonic QERSSOY
(QER_Supported for C)
(QERASLSSY for COBOL)

 

 

QERASLUP (upsertStatus for C)
is UPSERT
support

One of the following EBCDIC characters:

'N' with mnemonic QERUPSN
(QER_NotSupported for C)
(QERASLUPN for COBOL)

'Y' with mnemonic QERUPSY
(QER_Supported for C)
(QERASLUPY for COBOL)

 

 

QERASLAO
(arrayOpsStatus for C)
is Array
operationssupport

One of the following EBCDIC characters:

'N' with mnemonic QERAOPN
(QER_NotSupported for C)

'Y' with mnemonic QERAOPY
(QER_Supported for C)

 

 

QERASLMI
(mergeIntoStatus for C)
is MERGE
INTOsupport

This value is deprecated: new development should use the QERASLMU value later in this list.

One of the following EBCDIC characters:

'N' with mnemonic QERMRIN
(QER_NotSupported for C)
(QERASLMIN for COBOL)

'Y' with mnemonic QERMRIY
(QER_Supported for C)
(QERASLMIY for COBOL)

 

 

QERASLLO (lobStatus for C)
is Large
objectsupport

'N' with mnemonic QERLOBN
(QER_NotSupported for C)
(QERASLLON for COBOL)

'Y' with mnemonic QERLOBY
(QER_Supported for C)
(QERASLLOY for COBOL)

 

 

QERASLER (extendedResponseStatus for C)
is Extended
responsesupport

'N' with mnemonic QERERSN
(QER_NotSupported for C)
(QERASLERN for COBOL)

'Y' with mnemonic QERERSY
(QER_Supported for C)
(QERASLERY for COBOL)

 

 

QERASLTT
(timingTypesStatus for C)
is Timestamp
typessupport

One of the following EBCDIC characters:

'N' with mnemonic QERTMTN
(QER_NotSupported for C)
(QERASLTTN for COBOL)

'Y' with mnemonic QERTMTY
(QER_Supported for C)
(QERASLTTY for COBOL)

 

 

QERASLEH (requestUsage for C)
is Expanded
parcelheaderusage

A two-byte unsigned integer containing either:

'N' with mnemonic QEREPHN
(QER_RequestUsageNone for C)
(QERASLEHN for COBOL)

‘1‘ with mnemonic QEREPHY
(QER_RequestUsageSubset1 for C)
(QERASLEHY for COBOL)

‘2‘ with mnemonic QEREPHA
(QER_RequestUsageSubset2 for C)
(QERASLEHI for COBOL)

 

 

QERASLRP
(responsePositioningStatus for C)
is Response
positioningsupport

One of the following EBCDIC characters:

'N' with mnemonic QERRPON
(QER_NotSupported for C)
(QERASLRPN for COBOL)

'Y' with mnemonic QERRPOI
(QER_Supported for C)
(QERASLRPI for COBOL)

 

 

QERASLES (statementStatusStatus for C)
is Enhanced
statementstatussupport

'N' with mnemonic QERESSN
(QER_NotSupported for C)
(QERASLESN for COBOL)

'Y' with mnemonic QERESSY
(QER_Supported for C)
(QERASLESY for COBOL)

 

 

QERASLUT
(userTypesStatus for C)
is User
definedtypessupport

One of the following EBCDIC characters:

'N' with mnemonic QERUDTN
(QER_NotSupported for C)
(QERASLUTN for COBOL),

'Y' with mnemonic QERUDTY
(QER_Supported for C)
(QERASLUTY for COBOL)

 

 

QERASLRA
(relaxedArgsStatus for C, RELAXED
ARGSSTATUS for COBOL, RELAXED_ARGS_STATUS
for PL/I)
is Relaxedcallargssupport

One of the following EBCDIC characters:

'N' is QERRCAN
(QER_NotSupported for C,
NOT
SUPPORTED for COBOL, QER_NOT_SUPPORTED
for PL/I)

'Y' is QERRCAY
(QER_Supported for C, SUPPORTED for COBOL, QER_SUPPORTED for PL/I)

 

 

QERASLSI
(statementInfoStatus for C, STATEMENT
INFOSTATUS
for COBOL, STATEMENT_INFO_STATUS
for PL/I)
is Statementinfosupport

One of the following EBCDIC characters:

'N' is QERSISN
(QER_NotSupported for C,
NOT
SUPPORTED for COBOL, QER_NOT_SUPPORTED
for PL/I)

'Y' is QERSISY
(QER_Supported for C, SUPPORTED for COBOL, QER_SUPPORTED for PL/I

 

 

QERASLID
(integerDecimalStatus for C,
INTEGE
DECIMALSTATUS for COBOL,
INTEGERDECIMAL_STATUS
for PL/I)
is Statementinfosupport

One of the following EBCDIC characters:

'N' is QERIDEN
(QER_NotSupported for C,
NOT
SUPPORTED for COBOL, QER_NOT_SUPPORTED
for PL/I)

'Y' is QERIDEY
(QER_Supported for C, SUPPORTED for COBOL, QER_SUPPORTED for PL/I)

 

 

QERASLRD
(returnDataStatus for C,
RETURN
DATASTATUS for COBOL, RETURN_DATA_STATUS
for PL/I)
is ReturnIdentityDatasupport

One of the following EBCDIC characters:

'N' is QERRIDN
(QER_NotSupported for C,
NOT
SUPPORTED for COBOL, QER_NOT_SUPPORTED
for PL/I)

'Y' is QERRIDY
(QER_Supported for C, SUPPORTED for COBOL, QER_SUPPORTED for PL/I)

 

 

QERASLRS
resultSetsStatus for C,
RESULT
SETSSTATUS for COBOL, RESULT_SETS_STATUS for PL/I) is Resultsetssupport

One of the following EBCDIC characters:
'N' is QERRSSN (QER_NotSupported for C,
NOT
SUPPORTED for COBOL, QER_NOT_SUPPORTED for PL/I)

'Y' is QERRSSY (QER_Supported for C, SUPPORTED for COBOL, QER_SUPPORTED for PL/I).

 

 

QERASLQB
(queryBandStatus for C, QUERYBAND
STATUS for COBOL, QUERYBAND_STATUS for PL/I) is QueryBandsupport

One of the following EBCDIC characters:

'N' is QERQBSN (QER_NotSupported for C, NOTSUPPORTED for COBOL, QER_NOT_SUPPORTED for PL/I)

'Y' is QERQBSY (QER_Supported for C, SUPPORTED for COBOL, QER_SUPPORTED for PL/I)

 

 

QERASLCC (columnCorrStatus for C, COLUMNCORRSTATUS for COBOL, COLUMN_CORR_STATUS for PL/I) is Columncorrelationstatus

One of the following EBCDIC characters:

'N' is QERCCSN (QER_NotSupported for C,
NOT
SUPPORTED for COBOL, QER_NOT_SUPPORTED for PL/I)

'Y' is QERCCSY (QER_Supported for C, SUPPORTED for COBOL, QER_SUPPORTED for PL/I).

For applications that support multiple releases of CLIv2, a downlevel CLIv2 could return binary zeroes, which is interpreted as 'N'.

 

 

QERASLMU
(mergeIntoUsage for C, MERGE
INTOUSAGE for COBOL, MERGE_INTO_USAGE for PL/I) is Mergeintousage

A two-byte unsigned integer containing one of the following values:

0 is QERMIUN (QER_MergeUsageNone for C, NOT_SUPPORTED for COBOL, QER_MERGE_USAGE_NONE for PL/I)

1 is QERMIUS (QER_MergeUsageSingleRow for C, SINGLEROW for COBOL, QER_MERGE_USAGE_SINGLE_ROW for PL/I)

2 is QERMIUM (QER_MergeUsageMultiRow for C, MULTIROW for COBOL, QER_MERGE_USAGE_MULTI_ROW for PL/I)

 

 

QERASLLE
(loggingerrorsUsage for C, LOGGING
ERRORSUSAGE for COBOL, LOGGING_ERRORS_USAGE for PL/I) is Loggingerrorsusage

A two-byte unsigned integer containing one of the following values:

0 is QERLEUN (QER_LoggingUsageNone for C, NOT_SUPPORTED for COBOL, QER_LOGGING_USAGE_NONE for PL/I),

1 is QERLEUM (QER_LoggingUsageMerge for C, QERASLLEM for COBOL, QER_LOGGING_USAGE_MERGE for PL/I)

 

 

QERASLTO
(transformsOffUsage for C, TRANSFORMS‑OFF‑USAGE
for COBOL, TRANSFORMS_OFF_USAGE
for PL/I) is Transforms‑off‑usage

A two-byte unsigned integer containing one of the following values:

0 is QERTOUN (QER_XformsOffUsageNone
for C,
NOT_SUPPORTED for COBOL, QER_XFORMS_OFF_NONE
for PL/I),

1 is QERTOUS (QER_XformsOffUsageStruct for C, STRUCTURED for COBOL, QER_XFORMS_OFF_STRUCT for PL/I)

2 is QERTOUP (QER_XformsOffUsagePeriod for C, PERIOD for COBOL, QER_XFORMS_OFF_PERIOD for PL/I)

24

QEPIASL

QERASLSU
(stmtStatusUsage; for C, STMT-STATUS-USAGE for COBOL, STMT_STATUS_USAGE for PL/I) is Statement Status Usage

A two-byte unsigned integer containing one of the following values:

0 is QERSSUN (QER_StmtStatusNone for C, NOT-SUPPORTED for COBOL, QER_STMT_STATUS_NONE for PL/I) for Not Supported

1 is QERSSU1 (QER_StmtStatusLevel1 for C, LEVEL1 for COBOL, QER_STMT_STATUS_L1 for PL/I) for Level 1 Supported