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
Release Date
July 2021
Content Type
Administration
Programming Reference
Publication ID
B035-1210-171K
Language
English (United States)

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.