Trace Type Class IFCID Description ACCOUNTING 1 3 ALL ACCOUNTING 106 SYSTEM PARAMETERS IN EFFECT...
Mainframe Blog
Predicates in Db2 12
Predicate Type Indexable Stage 1 COL = value Y Y COL = noncol expr Y Y COL IS NULL Y Y COL op value...
Get Diagnostics in Db2 12
Statement Information Item Description Data type DB2_GET_DIAGNOSTICS _DIAGNOSTICS After a GET...
REXX SQLCA in Db2 12
Variable Contents SQLCODE The SQL return code SQLERRMC One or more tokens separated by X’FF’ that...
SQL Communication Area (SQLCA) in Db2 12
Assembler, COBOL, or PL/I Name C Name Data Type Purpose SQLCAID sqlcaid CHAR(8) ‘eye catcher’ for...
Db2 Limits in Db2 12
Identifier length limits Item Limit External-java-routine-name 1305 bytes Name of an alias...
Bind Parameters in Db2 12
Option Valid values Plan Pckg Trigr Qry ACQUIRE USE, ALLOCATE X Whether to acquire resources...
DSNZPARMs in Db2 12
Parameter Description Acceptable values (defaults appear in bold) Online ABEXP EXPLAIN processing...