Converts BLOB data into a CLOB of JSON format document with 1 to M mapping to each row in DBC.DBQLParamTbl.
ANSI Compliance
This statement is a Teradata extension to the ANSI SQL:2011 standard.
Syntax
[TD_SYSFNLIB.] TD_DBQLParam (DBC.DBLParamTbl.QueryID, DBC.DBQLParamTbl.paraminfo)
Syntax Elements
- TD_SYSFNLIB.
- Name of the database where the function is located.
- DBC.DBLParamTbl.QueryID
- The QueryID column in the following table: DBC.DBQLParamTbl.
- DBC.DBQLParamTbl.paraminfo
- The BLOB column in the following table: DBC.DBQLParamTbl.