DOWNLOAD

www.cozTools.com

www.MidrangeNews.com

Contact Us

COZTOOLS

SQL iQueryBETA Installation

SQL iQuery is packaged as an IBM i Licensed Program and may be restored using the RSTLICPGM command.

  1. Download IQUERYxxx.ZIP file from the downloads page.
  2. Unzip the file to produce the IQUERY.SAVF object onto your PC.
  3. Upload the IQUERY.SAVF object to library QGPL (or similar) on your IBM i system using FTP BINARY mode or another method.
  4. If SQL iQuery is already installed on your system, you need to delete the licensed program before continuing.
    • IF YOU DO NOT WANT TO REPLACE YOUR LICENSED iQuery with THIS BETA, DO NOT INSTALL THIS BETA
    • To delete the LP, run the following CL command:
    • DLTLICPGM LICPGM(2COZIQ4)
  5. On the IBM i system, install the software by restoring the SQL iQuery Licensed Program, using the RSTLICPGM command, as follows:
RSTLICPGM LICPGM(2COZIQ5) DEV(*SAVF) SAVF(QGPL/IQUERY)

The RSTLICPGM restores the SQL iQuery licensed program into library IQUERY, and does the following:

  1. If this is the first time installing SQL iQuery, it installs a one-time temporary license key, valid for 60 days.
  2. Creates proxy commands RUNIQRY, RUNIQRYF, and WRKiQRY in QGPL. This allows use of the product without the need for its library IQUERY being on the library list.
  3. Builds several SQL Functions in both the IQUERY library.
  4. Creates the IQUERY (SQL iQuery) Menu. Use STRIQRY to go to the menu, or the classic "GO IQUERY" command.

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

  1. Run SQL using iQuery
  2. Run iQuery
  3. 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-IQ5
  • Built for IBM i release: V7R2M0
  • Run iQuery CL Command: RUNIQRY
  • Run SQL using iQuery CL Command: RUNIQRY

Copyright © 2014-2019 Cozzi Productions, Inc. All Rights Reserved.