All: The All page lets you view your entire query. The other tabbed SQL pages display only the clauses for that specific option.
From: The From clause lets you identify the name of the file or files where the data you want to transfer is stored.
Select: The Select clause lets you specify the particular fields you want to transfer from the AS/400 in the Select Query box.
Where:The Where clause lets you specify one or more conditions to determine which records are to be transferred from the selected fields. If you don't specify a Where clause, all records will be transferred. The Where clause is not required.
Group By: When transferring summary records, the Group By clause lets you separate records from the AS/400 files into more than one group.
Having: When transferring records, the Having clause lets you specify which summary records will be transferred.
Order By: When transferring files, the Order By clause lets you sort the result of the Select clause. The records will be sorted in the order specified. If you do not specify any order, the records will be transferred but they will not be sorted.
Join By: The Join By clause is required if you specify more than two files in the From clause. The Join By clause determines how to join records from the specified files. You provide the names of the fields you want to use to join the records.