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. This collateral helps DB2 for z/OS users with daily activities in administering and programming for DB2 on z/OS.


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.

BMC Bring the A-Game

From core to cloud to edge, BMC delivers the software and services that enable nearly 10,000 global customers, including 84% of the Forbes Global 100, to thrive in their ongoing evolution to an Autonomous Digital Enterprise.
Learn more about BMC ›

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.