DB2 Scalar functions - Table functions - www.cadcobol.com.br


Volta ao Menu das scalar functions Volta ao Menu Principal

Desenvolvido por DORNELLES Carlos Alberto - Analista de Sistemas - Brasília DF. - cad_cobol@hotmail.com

DB2 Scalar functions - Table functions
Function Description
BASE_TABLE Returns both the object name and schema name of the object found after any alias chains have been resolved.
JSON_TABLE Returns a result table from the evaluation of SQL/JSON path expressions.
Each item in the result sequence of the row SQL/JSON path expression represents one or more rows in the result table.
UNNEST Returns a result table that includes a row for each element of the specified array.
XMLTABLE Returns a table from the evaluation of XQuery expressions, possibly using specified input arguments as XQuery variables.
Each sequence item in the result sequence of the row XQuery expression represents a row of the result table.


© Copyright IBM Corp.