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.
Order Now! Get your free Db2 collateral from BMC!
These postings are my own and do not necessarily represent BMC's position, strategies, or opinion.
See an error or have a suggestion? Please let us know by emailing blogs@bmc.com.