SQL queries are used when downloading one or more files to your PC. An SQL query allows you to select specific records, how they are sorted, and how they are grouped. Press the "Options" button to connect to the server to retrieve the field information for each file selected. You may enter the SQL query directly into the editbox or use the SQL Query Options dialog to create SQL queries.
SQL Queries are supported through the BlueZone Host File Transfer (5250) Interface.
Launch an iSeries Display session.
Choose Transfer:Send/Receive... from the BlueZone MenuBar.
The Host File Transfer (5250) application will be displayed.
Choose Transfer:Transfer Setup from the Host File Transfer MenuBar.
The Transfer Setup dialog will be displayed.
Click the SQL tab
The SQL Query edit box will be displayed.
Access the SQL Query edit box as described above.
Click the Options... button at the bottom of the SQL Query edit box.
A Host Login dialog box will be displayed.
Log on to the host or click the Cancel button.
The SQL Query Options dialog will be displayed as shown here:
This is where you can build your SQL Query statements. Each tab represents an SQL Query condition.
The following list describes each condition:
Select - Determines which fields to transfer. This is required!
Where - One or more conditions that must occur for a record to be transferred.
Group by - Allows you to separate the result data into more than one group.
Having - One or more conditions that must occur by each summary record to be transferred.
Order by - specifies an order in which to return the rows.
Join by - specifies how the data from multiple files will be combined.
Each clause should be on a separate line. The default SQL query of SELECT * is used when there is no custom SQL query configured.
For example:
SELECT *
WHERE (t1.IMITM = t2.IMITM)
Related Topics: