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