Author - Stephen Watts

ARRAY_AGG Ordinary array aggregation:...

Catalog statistics that updatable and used for access path selection Table Statistics SYSIBM...

SYSIBM.XSRCOMPONENT Auxiliary table for BLOB column COMPONENT in SYSIBM.SYSXSROBJECTCOMPONENTS...

Check out the interactive Db2 12 for z/OS Catalog Tables index SYSIBM.IPLIST Allows multiple IP...

Status Code Status name Affected objects Corrective action(s) ACHKP Auxiliary CHECK pending Base...

Trace Type Class IFCID Description ACCOUNTING 1 3 ALL ACCOUNTING 106 SYSTEM PARAMETERS IN EFFECT...

Predicate Type Indexable Stage 1 COL = value Y Y COL = noncol expr Y Y COL IS NULL Y Y COL op value...

Statement Information Item Description Data type DB2_GET_DIAGNOSTICS _DIAGNOSTICS After a GET...

Variable Contents SQLCODE The SQL return code SQLERRMC One or more tokens separated by X’FF’ that...

Assembler, COBOL, or PL/I Name C Name Data Type Purpose SQLCAID sqlcaid CHAR(8) ‘eye catcher’ for...