SQL Tools is the professional SQL Extension pack for IBM i. It seemlessly integrates with your existing in-house applications, RPG IV, IBM SQL, and modern 3rd-party applications. These functions provide accessibilty to IBM i system APIs, your database files, and a host of functions, such as loan amortizations, GUID/UUID, hash, base64, and more. These highly efficient and optimized interfaces are provided using easy-to-use SQL Functions and Procedures, so they are available via any interface that supports SQL. Including but not limited to RPG IV, CL (via RUNSQLSTM), IBM ACS RUN SQL Scripts, Cozzi SQL iQuery, Visual Studio Code and more.
SQL Tools V2R3M1 for IBM i v7.2 an later is now available. Download a trial copy for free using the link below. When you decide to keep SQL Tools, just email us and we'll process your order.
In addition to downloading and using our products on your system, you can now try out SQL iQuery and/or SQL Tools on a real IBM i V7R5 Power10 server at zero cost to you.
Visit our partner site: PUB400 and set up a free account and start using IBM i V7R5 5250 or ACS in minutes. Then simply enter "GO IQUERY" or use ACS to run any of the SQL Tools through its SQL interface. It is really that easy, and completely free.
To begin using SQL iQuery in your PUB400 5250 session, just enter the RUNiQRY command from command entry. SQL Tools can be utilized from within any SQL interface (RPG, iQuery, STRSQL, ACS, etc.) by simply qualifying them to the SQLTOOLS schema. It really is that easy! Thanks to PUB400.com for providing such a great resource and experience to the IBM i community.
Click the links in the table below to: license SQL Tools, read the change-log or documentation, get our pricing, or Download the latest build. (A trial license is auto-installed if you are a new customer.)
| Download Links | |||||
|---|---|---|---|---|---|
| Change Log | Docs | Install | Pricing | IBM i V7R3, R4, R5 ⤓ | IBM i v7r2⤓ |
| Build: Wed 06 Dec 2023 - 02:44 PM | Build: Wed 06 Dec 2023 - 02:33 PM | ||||
To initiate your purchase, send us an email with your IBM i Version and System Serial Number (QSRLNBR) by clicking here ⇛
SQL Tools is the perfect collection of powerful and easy-to-use SQL Functions that replaces the need to setup and call IBM i APIs to get information into your programs. Use them in RPG IV apps or in your favorite SQL interface, such as ACS RUNSQL SCRIPTS, STRSQL, SQL iQuery, and now Visual Studio CODE and dBeaver. One call to an SQL Tools function can avoid coding hundreds of error-prone lines needed to call IBM i APIs.
Each SQL Tool 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}} |
| #END List | |
Available: Now
Price: $995 (OTC)
To request an invoice for SQL Tools for your IBM i Serial Number(s), reach out to Bob Cozzi at this link.
* 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: