Specifying filter criteria
The LOADLOG table holds report and trace interval data for loaded data. You can use the trace start and end time, and the ID of the job step as criteria for filtering queries. This can be useful if you want to analyze only those trace records loaded by a specific user for a particular step at a certain time.
To specify filter criteria:
- On the View SQL page of the Query Execution window, click Time.
The Time setting area is displayed in the contents pane.
This area shows information from the LOADLOG table. It contains the user ID of the user that loaded the data, the trace-interval data, and the load-job step ID associated with the load job. For more information about this table, refer to The LOADLOG table.
- Select a column that holds the appropriate trace-start time, trace-end
time, or step-log ID and click Start time, End time,
or LOAD step.
The Select Table window is displayed.
- Select a table from the list and click OK.
The corresponding filter expression is displayed in the text field. You can combine expressions using the AND, OR, and NOT operators.
For example, if you clicked Start time, the filter expression comprises the table name, the trace start time column name, and the value of the trace start time of the selected row in the time-setting table. If you clicked LOAD step, the filter expression comprises the table name, the step-log ID column name, and the value of the step-log ID of the selected row in the time-setting table.
- Click Apply. The filter expression is inserted in the query at the current cursor position.