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.
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.