Db2 Input Tables in Db2 12
DSN_USERQUERY_TABLE Identifies statements whose access paths are influenced Column name...
Tag - Db2
Explain Tables in Db2 12
PLAN_TABLE Contains information about access paths for queries that were...
SQL Control Statements in Db2 12
SQL CONTROL STATEMENT >>____assignment-statement________________________________________________>< ǀ_CALL statement_______ǀ ǀ_CASE statement_______ǀ ǀ_compound-statement___ǀ ǀ_FOR...
Commands in Db2 12
-ACCESS DATABASE <_ ,_____________ >>__ACCESS DATABASE__(______database-name_ǀ________)_______________________> ǀ_*_____________________ǀ ǀ_dbname1:dbname2_______ǀ ǀ_dbname*_______________ǀ ǀ_*dbname_______________ǀ...
Language Elements in Db2 12
Special Registers >>__ _CURRENT APPLICATION ENCODING SCHEME_______________________ ______>< ǀ_CURRENT CLIENT_ACCTING____________________________________ǀ...
How to Read IBM® Syntax Diagrams for Db2 12
Read the syntax diagrams from left to right, from top...
Queries in Db2 12
subselect >>__select-clause__from-clause___________________________________________> ǀ_where-clause_ǀ >________________________________________________________________________> ǀ_group_by_clause_ǀ ǀ_having-clause_ǀ >________________________________________________________________________> ǀ_order-by-clause_ǀ ǀ_offset-clause_ǀ ǀ_fetch-clause_ǀ...
Table & Row Functions in Db2 12
Table Functions ADMIN_TASK_LIST >_ADMIN_TASK_LIST()_______________________________________________________> ADMIN_TASK_OUTPUT >_ADMIN_TASK_OUTPUT(_task-name_,_num-invocations)_________________________> ADMIN_TASK_STATUS >_ADMIN_TASK_STATUS(____________________)_________________________________> ǀ_max-history_ǀ XMLTABLE...