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
>_XMLTABLE_(______________________________row-xquery-expression-constant___>
ǀxmlnamespaces-declaration_,_ǀ
>__________________________________________________________________________>
ǀ <__ ,____________________________ ǀ ǀ _BY REF_ ǀ ǀ ǀ_PASSING_ǀ________ǀ_____row-xquery-argument________ǀ___ǀ >__________________________________________________________________________>
ǀ </__><__ ,_____________________________________ ǀ
ǀ_COLUMNS_____xml-table-regular-column-definition_____ǀ_)_ǀ
ǀ_xml-table-ordinality-column-definition_ǀ
Row-xquery-argument:
>_xquery-context-item-expression_________________________________________> ǀ_xquery-variable-expression_AS_identifier_ǀ
Xml-table-regular-column-definition:
>_column-name_data-type__________________________________________________> ǀ_default-clause_________________________ǀ ǀ_PATH_column-xquery-expression-constant_ǀ
Xml-table-ordinality-column-definition:
>_column-name_FOR ORDINALITY_____________________________________________>
Row Functions
UNPACK
>_UNPACK(expression)_____________________________________________________>
</__>
Disclaimer: This Db2® 12 for z/OS Reference Guide was developed to help users in their daily activities in administrating and programming in Db2 for z/OS. There are no guarantees expressed or implied with the contents in this guide. We want to provide a quality and useful reference for users. Please notify us of any mistakes or errors in this reference guide at blogs@bmc.com. Db2 is a registered trademark of the IBM Corporation.
