16.20 - Usage Notes - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Operators and User-Defined Functions

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

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.