SQL Query Select page

Use the Select Options page to create a Select clause in your SQL query. You can specify the particular fields you want to transfer from the AS/400 in the Select Query box. If you want to select all fields enter an asterisk (*). A Select statement can contain a maximum of 256 fields. If the file contains more than 256 fields, you cannot use the asterisk to transfer all fields. The Select clause is always required.