16.20 - TD_DBQLParam - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Operators and User-Defined Functions

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
April 2020
Content Type
Administration
Programming Reference
Publication ID
B035-1210-162K
Language
English (United States)

Purpose

Converts BLOB data into a CLOB of JSON format document with 1 to M mapping to each row in DBC.DBQLParamTbl.

Syntax



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.