Mainframe Blog

Table & Row Functions in Db2 12

< 1 minute read
Stephen Watts

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_ǀ

(This article is part of our Db2 Guide. Use the right-hand menu to navigate.)

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.


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 Brings the A-Game

BMC works with 86% of the Forbes Global 50 and customers and partners around the world to create their future. With our history of innovation, industry-leading automation, operations, and service management solutions, combined with unmatched flexibility, we help organizations free up time and space to become an Autonomous Digital Enterprise that conquers the opportunities ahead.
Learn more about BMC ›

About the author

Stephen Watts

Stephen Watts (Birmingham, AL) contributes to a variety of publications including, Search Engine Journal, ITSM.Tools, IT Chronicles, DZone, and CompTIA.