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: IBM i V7R2 zip and savf files are named SQLTOOLS72.ZIP→ SQLTOOLS72.SAVF and iQUERY72.ZIP→ iQUERY72.SAVF
- Upload the save file to library QGPL (or similar) on your IBM i system using FTP BINARY mode or another method.
- Delete any existing version of the product using DLTLICPGM. (Use go licpgm to determine which version is installed.)
- For iQuery: DLTLICPGM LICPGM(2COZIQx)
- For SQL TOOLS: DLTLICPGM LICPGM(2COZSTx) Where x is the installed version number
- 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 SQL iQuery before installing the new Version 8 release. Use DLTLICPGM 2COZIQn where n is the previously installed version number. Then do the following:
For IBM i V7R3M0 and later releases
RSTLICPGM LICPGM(2COZIQ8) DEV(*SAVF) SAVF(QGPL/IQUERY)
For IBM i V7R2M0 only
RSTLICPGM LICPGM(2COZIQ8) DEV(*SAVF) SAVF(QGPL/IQUERY72)
SQL Tools Install
For IBM i V7R3M0 and later releases
RSTLICPGM LICPGM(2COZST3) DEV(*SAVF) SAVF(QGPL/SQLTOOLS)
For IBM i V7R2M0 only
RSTLICPGM LICPGM(2COZST3) 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
or
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