Xml table expression

Description

An xmltable-expression specifies an invocation of the built-in XMLTABLE function which determines the intermediate result table. See XMLTABLE for more information.

Click here to navigate to the IBM DB2 docs page for this syntax.

XML Table Expressions are not supported in Snowflake. The output query can be malformed

Grammar Syntax

Sample Source Patterns

IBM DB2

Code 1

SELECT
   AValue
FROM
   XMLTABLE( 'stringValue' PASSING BY REF passingExpr AS AliasName) AS XMLTABLENAME

Snowflake

Code 1

SELECT
   AValue
FROM
-- ** MSC-ERROR - MSCEWI1084 - XMLTABLE IS NOT SUPPORTED BY SNOWFLAKE **
--   XMLTABLE( 'stringValue' PASSING BY REF passingExpr AS AliasName) AS XMLTABLENAME

Related EWIs

1. MSCEWI1084: XMLTABLE is not supported.