Query tab (non-AS/400 IBMi)
This tab allows the user to filter the data in the extraction phase (or initial loading).
Right-click a table to access its Properties, then click the
Query tab.
Enter the query content in the WHERE clause:
Select the the table from Table name list to display the list of columns of the table.
Double-click on the name of the column to see the different values. The maximum number of elements on the list is determined by the Max rec value.
After having inserted the WHERE clause, it is possible to test the query and see the result by clicking on Test.
The maximum number of elements in the list is determined by the Max rec value.
