SQL Options

When receiving files from the AS/400, you can use SQL (Structured Query Language) commands to construct queries that let you download specific files and records to your PC. You can create both simple and complex queries using the SQL property pages. The SQL property pages provide tools that let you build queries one step at a time, and specify the files, fields, and records you want to receive. You access the SQL property pages by choosing the Edit SQL button in the AS/400 File Transfer window.

in this section

Receiving files from the AS/400 using SQL options
SQL query options
SQL Query from page
SQL Query Select page
SQL Query Where page
SQL Query Group By page
SQL Query Having page
SQL Query Order By page
SQL Query Join By page