TD_DBQLParam | SQL Operators & User-Defined Functions | Teradata Vantage - 17.10 - TD_DBQLParam - 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

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.

Result Type

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.

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.