Usage Notes - Advanced SQL Engine - Teradata Database

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
2023-04-27
dita:mapPath
fsi1592016213432.ditamap
dita:ditavalPath
fsi1592016213432.ditaval
dita:id
B035-1210
lifecycle
previous
Product Category
Teradata Vantage™

This function is activated as part of DIPSYSFNC, the DIP script executed when DIP ALL is executed. But the DIP script does not grant rights to TD_DBQLParam. DBC will have to be explicitly granted rights. For example:

GRANT EXECUTE FUNCTION ON TD_SYSFNLIB.TD_DBQLParam TO DBC WITH GRANT OPTION;

For queries that have parameter markers/positional parameters with question marks (?) in the query, variable names are now replaced with proper names only in DBQL’s ParamInfo logging to P1, P2 ... Pn. The numbering 1 to n stands for these parameter position from left to right as they appear in the query text.