Is it possible to catch inserted varibles in logging?

Database
Enthusiast

Is it possible to catch inserted varibles in logging?

quick question.

Is it possible to capture, in the dbc.qrylog, variables being inserting into queries?   For example if a user run a query from a BI tool such a select * from YXZ.Stuff where stuff='abc'.  We are getting '?' in the variable locations.

Any help will be appreciated. 

1 REPLY
Enthusiast

Re: Is it possible to catch inserted varibles in logging?

prior to Teradata database version 15.00, no there isn't an easy way to capture values from parameterized queries.  In Teradata database version 15.00 there is a new dbql table called DBQLParamTBL which when enabled will store the parameters for the sql that is run.