SQL iQuery and SQL Tools Installation

Use these instructions to install either product

SQL iQuery and SQL Tools are packaged as IBM i Licensed Program and are restored using the RSTLICPGM command.

Download IQUERY.ZIP or SQLTOOLS.ZIP
Unzip the file to produce the IQUERY.SAVF or SQLTOOLS.SAVF object onto your PC.
- Note: our IBM i V7R2 edition save files will be named SQLTOOLS72.SAVf and IQUERY72.SAVF
Upload the save file to library QGPL (or similar) on your IBM i system using FTP BINARY mode or another method.
- Here is link to a great article on how to upload .SAVF files from the PC to your IBM i system.
Delete any existing version of the product using DLTLICPGM
- For iQuery: DLTLICPGM LICPGM(2COZIQ7)
- For SQL TOOLS: DLTLICPGM LICPGM(2COZST2)
On the IBM i system, install the software by restoring the SQL iQuery Licensed Program, using the RSTLICPGM command, as follows:

SQL iQuery Install

Be sure to delete any existing install of iQuery before installing the new Version 7 release. Use DLTLICPGM 2COZIQn where n is the previously installed version number. Then do the following:

RSTLICPGM LICPGM(2COZIQ7) DEV(*SAVF) SAVF(QGPL/IQUERY)

or for V7R2

RSTLICPGM LICPGM(2COZIQ7) DEV(*SAVF) SAVF(QGPL/IQUERY72)

SQL Tools Install

RSTLICPGM LICPGM(2COZST2) DEV(*SAVF) SAVF(QGPL/SQLTOOLS)

or for V7R2

RSTLICPGM LICPGM(2COZST2) DEV(*SAVF) SAVF(QGPL/SQLTOOLS72)

At this point, the licensed program is installed on your system.

Using SQL Tools

To begin using SQL, familiarize yourself with the available SQL Functions and procedures in SQL Tools. The full documentation is available online for free, on this linked page.

Using SQL iQuery

To begin using SQL iQuery, run the RUNiQRY CL command and press F4. Otherise run the STRIQRY command to launch the iQuery menu.

STRIQRY

GO IQUERY

Once the menu appears, you can select one of the options to start using SQL iQuery (NOTE: This menu is a native IBM i menu and does not function in S/36E mode.)

SQL iQuery™ for IBM i Menu
Run SQL using iQuery
Run iQuery 
Work with Fields using iQuery

Option 1 prompts and runs the RUNIQRY 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 RUNIQRYF command. The run iQuery on a database file (RUNIQRYF) command 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 RUNIQRYF parameters is provided for field selection, sorting, and select/omit.

Option 3 prompts the WRKiQRY command. This command allows you to type in a File name and view the fields (columns) that make up the file. From this panel, you can use F10 to run the RUNiQRY command. You can select the fields you want to include in the query before pressing F10. The sequence of those fields may be specified while selecting them; similar to other interfaces on the system.

For examples of using the RUNIQRY and RUNIQRYF commands, visit our samples page

Product Information

Name: SQL iQuery™
Install Library: IQUERY
Product ID: 2COZ-IQ7
Built for IBM i release: V7R3M0
Runs on IBM i releases: v7.2 v7.3 v7.4 v7.5 and later compatible releases.
Run SQL statements using the SQL iQuery CL command: RUNIQRY
Run iQuery to query a file using CL-style parameters: RUNIQRYF