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 |
One of the following EBCDIC characters: 'N' with mnemonic QERTSMN 'Y' with mnemonic QERTSMY |
|
|
QERASLLC |
One of the following EBCDIC characters: 'N' with mnemonic QERLCSN 'Y' with mnemonic QERLCSY |
|
|
QERASLUC (UpdatableCursorStatus for C) |
One of the following EBCDIC characters: 'N' with mnemonic QERUCRN 'Y' with mnemonic QERUCRY |
|
|
QERASLRI (referentialIntegrityStatus for C) |
One of the following EBCDIC characters: 'N' with mnemonic QERRFIN 'Y' with mnemonic QERRFIY |
|
|
QERASLEP |
One of the following EBCDIC characters: ’N’ with mnemonic QEREPSN 'Y''Y' with mnemonic QEREPSY |
|
|
QERASLSS |
One of the following EBCDIC characters: 'N' with mnemonic QERSSON 'Y' with mnemonic QERSSOY |
|
|
QERASLUP (upsertStatus for C) |
One of the following EBCDIC characters: 'N' with mnemonic QERUPSN 'Y' with mnemonic QERUPSY |
|
|
QERASLAO |
One of the following EBCDIC characters: 'N' with mnemonic QERAOPN 'Y' with mnemonic QERAOPY |
|
|
QERASLMI |
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 'Y' with mnemonic QERMRIY |
|
|
QERASLLO (lobStatus for C) |
'N' with mnemonic QERLOBN 'Y' with mnemonic QERLOBY |
|
|
QERASLER (extendedResponseStatus for C) |
'N' with mnemonic QERERSN 'Y' with mnemonic QERERSY |
|
|
QERASLTT |
One of the following EBCDIC characters: 'N' with mnemonic QERTMTN 'Y' with mnemonic QERTMTY |
|
|
QERASLEH (requestUsage for C) |
A two-byte unsigned integer containing either: 'N' with mnemonic QEREPHN ‘1‘ with mnemonic QEREPHY ‘2‘ with mnemonic QEREPHA |
|
|
QERASLRP |
One of the following EBCDIC characters: 'N' with mnemonic QERRPON 'Y' with mnemonic QERRPOI |
|
|
QERASLES (statementStatusStatus for C) |
'N' with mnemonic QERESSN 'Y' with mnemonic QERESSY |
|
|
QERASLUT |
One of the following EBCDIC characters: 'N' with mnemonic QERUDTN 'Y' with mnemonic QERUDTY |
|
|
QERASLRA |
One of the following EBCDIC characters: 'N' is QERRCAN 'Y' is QERRCAY |
|
|
QERASLSI |
One of the following EBCDIC characters: 'N' is QERSISN 'Y' is QERSISY |
|
|
QERASLID |
One of the following EBCDIC characters: 'N' is QERIDEN 'Y' is QERIDEY |
|
|
QERASLRD |
One of the following EBCDIC characters: 'N' is QERRIDN 'Y' is QERRIDY |
|
|
QERASLRS |
One of the following EBCDIC characters: 'Y' is QERRSSY (QER_Supported for C, SUPPORTED for COBOL, QER_SUPPORTED for PL/I). |
|
|
QERASLQB |
One of the following EBCDIC characters: 'N' is QERQBSN (QER_NotSupported for C, NOT‑SUPPORTED 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, COLUMN‑CORR‑STATUS for COBOL, COLUMN_CORR_STATUS for PL/I) is Column‑correlation‑status |
One of the following EBCDIC characters: 'N' is QERCCSN (QER_NotSupported for C, '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 |
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, SINGLE‑ROW for COBOL, QER_MERGE_USAGE_SINGLE_ROW for PL/I) 2 is QERMIUM (QER_MergeUsageMultiRow for C, MULTI‑ROW for COBOL, QER_MERGE_USAGE_MULTI_ROW for PL/I) |
|
|
QERASLLE |
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 |
A two-byte unsigned integer containing one of the following values: 0 is QERTOUN (QER_XformsOffUsageNone 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 |
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 |