Converts BLOB data into a CLOB of JSON format document with 1 to M mapping to each row in DBC.DBQLParamTbl.
TD_DBQLParam is an embedded services system function.
TD_DBQLParam returns a JSON type document for each data parcel in the supplied BLOB data. If, for example, a request had 1 using row, the resulting number of JSON documents would be 1+1. If a request had n using rows, there would be n +1 JSON documents.
This statement is a Teradata extension to the ANSI SQL:2011 standard.
[TD_SYSFNLIB.] TD_DBQLParam (DBC.DBLParamTbl.QueryID, DBC.DBQLParamTbl.paraminfo)
- Name of the database where the function is located.
- The QueryID column in the following table: DBC.DBQLParamTbl.
- The BLOB column in the following table: DBC.DBQLParamTbl.