17.10 - Output - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Operators and User-Defined Functions

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
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.