← Back to SQL iQuery

SQL Tools™ for

Version 3 Rel. 1 now available!

SQL Tools is the SQL Functions you need for IBM i. It seemlessly integrates with your existing in-house applications, RPG IV, IBM SQL, and modern 3rd-party applications.

Download a trial copy for free using the link below or order your license today. We offer an easy annual license subscription.

You can try out SQL Tools for free on your own IBM i partition, or over on our partner site: PUB400. Not a PUB400 member? Set up a free account and start using IBM i V7R5 in minutes. Then simply use IBM ACS, SQL iQuery, or good old RPG IV with embedded SQL to run any of the available SQL Tools functions. It really is that easy.

The table below contains links to everything you need. Select the download arrow next to IBM i version your running to downlaod the SQLTools build for that version/release.

To initiate a purchase or longer trial period, send us an email with your IBM i Version and System Serial Number (QSRLNBR) by clicking here ⇛

SQL Tools Documentation Index

Each SQL Tool name includes a link to it's documentation. We use SQL Tools inside of SQL iQuery to produce these pages. Click or tap the SQL Tool name (below) to view it's documentation.

For example, to read the on-line documentation for the Member List (MBR_LIST) function click this link: MBR_LIST

Function Description
{{FUNCTION}} ({{FUNCTYPE}}) - {{FUNCDESC}} {{FNCLASS}}
#END List

SQL Tools Pricing and Availability

Available: Now

$695 annual Subscription/SWMA (Software Support/Maintenance Agreement) includes:

Quick Installation*

  1. Download the .ZIP to your PC
  2. Unzip the SQLTOOLS.ZIP file to reveal the SQLTOOLS.SAVF file.
  3. FTP the SQLTOOLS.SAVF to your IBM i server, placing it into QGPL or similar.
  4. On the green screen, run the following installation command:
    • DLTLICPGM 2COZST3
    • RSTLICPGM 2COZST3 DEV(*SAVF) SAVF(QGPL/SQLTOOLS)
  5. Start enjoying SQL Tools!

* Note: If you install the V7R2 version, you need to use file names SQLTOOLS72.ZIP, SQLTOOLS72.SAVF, and QGPL/SQLTOOLS72

Extended Installation Instructions

Vendor Info:
Cozzi Research
www.SQLiQuery.com
Lombard IL 60148
USA