17.10 - Output - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Operators and User-Defined Functions

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-08-13
dita:mapPath
fsi1592016213432.ditamap
dita:ditavalPath
fsi1592016213432.ditaval

The following help statement provides detailed description of the function argument and output parameters.

help function TD_SYSFNLIB.TD_DBQLParam;
Column Data Type Description
QID DECIMAL(18,0) Input parameter QueryID from DBC.DBQLParamTbl.QueryID.
Data BLOB Input parameter BLOB data from DBC.DBQLParamTbl.ParamInfo.
QueryID DECIMAL(18,0) Output table column #1 (Foreign Key) System wide unique value to join DBQL tables.
RowNum INTEGER Output table column #2 Row number indicating the sequence of ParamInfo and Data Record JSON documents.
ParamJSON CLOB Output table column #3 Parameter and data rows in JSON format.