SQL Query File™
Get to where you need to be
Join the 1889 users who have already discovered how SQL Query File solves their data access and reporting challenges with easy-to-use SQL.
SQL Query File for IBM i - Download
Download a fully functioning 60-day trial for IBM i v7.1 or later.
|Earliest Supported OS||Download Link||Downloads||Notes|
|IBM i V7R1M0||SQL Query File V7Rx||1889||Optimized for v7r1 and later. Check out the What's New log for the latest updates.|
|IBM i5/OS V5R4M0||SQL Query File V5R4||1155||Runs on v5r4 or v6r1
No-charge software license included)
SQL Query File works best with IBM i V7R1 and later. A Special Edition is available at no charge to systems running IBM i5/OS V5R4M0 and or IBM i V6R1M0. This license expires and the software stops operating when those systems are upgraded to IBM i v7.
SQL Query File is packaged as an IBM i Licensed Program and may be restored using the RSTLICPGM command.
- Download the COZQRYFxxx.ZIP file from the link above.
- Unzip the file to produce the COZQRYFxxx.SAVF object onto your PC.
- Upload the COZQRYFxxx.SAVF object to library QGPL (or similar) on your IBM i system using FTP or another method.
- If SQL Query File is already installed on your system, you
may need to delete the licensed program before continuing. To
delete the LP, run the following CL command:
- DLTLICPGM LICPGM(2COZQF2)
- On the IBM i system,restore the SQL Query File Licensed Program using the following RSTLICPGM 2COZQF2 command, (modify for the save file name, such as COZQRYF540 or COZQRYF710):
RSTLICPGM LICPGM(2COZQF2) DEV(*SAVF) SAVF(QGPL/COZQRYF710)
- Existing customers can stop here. If you already have a license key installed, you are finished.
- If you haven't already done so, Register your Company and IBM i Serial Number (note: trial users can skip this step but it can reduce work later on when ordering)
- Retrieve your SQL Query File Software License Key (you only need to do this once)
The RSTLICPGM restores the SQL Query File licensed program into library COZQRYF. It then creates proxy commands in QGPL. In most cases, you do not need to include the COZQRYF library on your library list due to these proxy commands being in QGPL and QGPL being part of the user's library list. If you do not have QGPL on your user's library list, or you delete the proxy commands from QGPL, you will need to add COZQRYF to the library list.
Using SQL Query File
To begin using SQL Query File, run the STRQRYF command.
Once the menu appears, you can select the RUNQRYF or RUNSQLF command. Both menu options automatically prompt and their commands are logged for F9 retrieval. The SQL Query File menu contains 3 options.
SQL Query File™ for IBM i Menu
- Run SQL using Query File
- Run Query File
- Work with Fields using Query File
Option 1 prompts and runs the RUNSQLF command, which allows you to directly enter SQL statements to be run, including the SELECT statement--but most SQL statements are supported.
Option 2 launches the RUNQRYF command. RUNQRYF is for those who wish to work with classic CL parameters, such as FILE and FLD, where you enter the file name and you get results. Customization of the RUNQRYF parameters is provided for field selection, sorting, and select/omit.
Option 3 prompts the WRKQRYF command. This command allows you to type in a File name. The file layout or record format (i.e., the list of fields that make up the file) is listed. From the Work with SQL Query File display, you can immediately press F10 to run a query over the data in the file, or you can select the fields you want to include in the query. The sequence of those fields may be specified while selecting them; similar to other interfaces on the system.
For examples of using the RUNQRYF and RUNSQLF commands, visit our samples page
- Name: SQL Query File™
- Install Library: COZQRYF
- Product ID: 2COZQF2
- Earliest IBM i release: V6R1M0 (limited use version available for V5R4M0)
- Run Query File CL Command: RUNQRYF
- Run SQL using Query File CL Command: RUNSQLF