image_pdfimage_print

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!

Get your free Reference Guide and Catalog Tables Poster for z/OS from BMC.
Order Now ›
Last updated: 04/01/2019

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.

About the author

Stephen Watts

Stephen Watts

Stephen Watts (Birmingham, AL) has worked at the intersection of IT and marketing for BMC Software since 2012.

Stephen contributes to a variety of publications including CIO.com, Search Engine Journal, ITSM.Tools, IT Chronicles, DZone, and CompTIA.

Run and Reinvent Your Business with BMC

BMC has unmatched experience in IT management, supporting 92 of the Forbes Global 100, and earning recognition as an ITSM Gartner Magic Quadrant Leader for six years running. Our solutions offer speed, agility, and efficiency to tackle business challenges in the areas of service management, automation, operations, and the mainframe. Learn more about BMC ›