Identifier length limits Item Limit External-java-routine-name 1305 bytes Name of an alias...
Author - Stephen Watts
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...
Db2 Input Tables in Db2 12
DSN_USERQUERY_TABLE Identifies statements whose access paths are influenced Column name Data type...
Explain Tables in Db2 12
PLAN_TABLE Contains information about access paths for queries that were explained or hints. Column...
SQL Control Statements in Db2 12
SQL CONTROL STATEMENT >>____assignment...
Commands in Db2 12
-ACCESS DATABASE <_ ,_____________ >>__ACCESS DATABASE__(______database...
Language Elements in Db2 12
Special Registers >>__ _CURRENT APPLICATION ENCODING SCHEME_______________________...
How to Read IBM® Syntax Diagrams for Db2 12
Read the syntax diagrams from left to right, from top to bottom, following the path of the line...
Queries in Db2 12
subselect >>__select-clause__from-clause___________________________________________>...