The DBQLParamTbl logs the parameter variable name, type, position, and value for each parameter in a parameterized request. The table is populated if you specify the PARAMINFO option for the BEGIN/REPLACE QUERY LOGGING statement.
Note: This table may contain confidential user information and should be accessed only by trusted personnel with access to the user DBC password. For more information about the user DBC password, see Security Administration.
Row Values
The following table describes the fields in a DBQLParamTbl row.
|
DBC.DBQLParamTbl field |
Description |
|
CollectTimeStamp |
Time the query log was generated. |
|
ParamInfo |
Name, type, position, and value for each parameter in the parameterized request. Where the parameter marker or positional parameter is “?” in the request, DBQL replaces the variable names with system-generated names P1 to Pn. The numbering 1 to n stands for the parameter positions from left to right as they appear in the request text. |
|
ProcID |
ID of the processor that handled the request being logged. |
|
QueryID |
Query ID of the parameterized request. |
|
ZoneID |
Reserved for future use. |
The TD_DBQLParam embedded services function converts the contents of the BLOB type ParamInfo column into JavaScript Object Notation (JSON) format for use in diagnosing parameterized query problems.