Aggregate-support-list - Call-Level Interface Version 2

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

Product

Call-Level Interface Version 2

Release Number

15.00

Language

English (United States)

Last Update

2018-09-28

dita:id

B035-2417

lifecycle

Product Category

Teradata Tools and Utilities

Aggregate‑support‑list

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)
Item Code	Mnemonic	Field	Value
24	QEPIASL	QERASLTS (semanticsStatus for C) is Transaction‑ semantics‑support	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‑ conformance‑support	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‑cursor‑support	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‑ integrity‑support	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‑ size‑support	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‑signon‑support	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‑operations‑support	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‑INTO‑support	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‑object‑support	'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‑response‑support	'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‑types‑support	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‑parcel‑header‑usage	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‑positioning‑support	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‑statement‑status‑support	'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‑defined‑types‑support	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‑ARGS‑STATUS for COBOL, RELAXED_ARGS_STATUS for PL/I) is Relaxed‑call‑args‑support	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‑INFO‑STATUS for COBOL, STATEMENT_INFO_STATUS for PL/I) is Statement‑info‑support	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‑DECIMAL‑STATUS for COBOL, INTEGER‑DECIMAL_STATUS for PL/I) is Statement‑info‑support	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‑DATA‑STATUS for COBOL, RETURN_DATA_STATUS for PL/I) is Return‑Identity‑Data‑support	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‑SETS‑STATUS for COBOL, RESULT_SETS_STATUS for PL/I) is Result‑sets‑support	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 QueryBand‑support	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, 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‑INTO‑USAGE for COBOL, MERGE_INTO_USAGE for PL/I) is Merge‑into‑usage	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 (loggingerrorsUsage for C, LOGGING‑ERRORS‑USAGE for COBOL, LOGGING_ERRORS_USAGE for PL/I) is Logging‑errors‑usage	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