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 is based in Birmingham, AL and began working at BMC Software in 2012. Stephen holds a degree in Philosophy from Auburn University and is currently enrolled in the MS in Information Systems - Enterprise Technology Management program at University of Colorado Denver.

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