SQL Tools is a huge selection of SQL functions that work across all IBM i releases starting with V7R2 and going threw V7R5. Unlike many IBM Services these functions return the same information across all releases except for one or two rare situations. They improve RPG programmer productivity by eliminiating the complexity that using APIs requires. All IBM i SQL, RPG, CL and ACS interfaces support SQL Tools and this includes are own SQL iQuery.
SQL Tools has a 70-day grace period when installed. There is no fee required to use it during this grace period. When you decide to keep SQL Tools forever, you can place an online order and we will send you a permanent license key that never expires.
Starting today, 12 July 2022 you can now try out both SQL iQuery and SQLTools for free on a real IBM i V7R5 system.
The good folks over at PUB400 have been given a site-license to both SQL iQuery and SQLTools. All PUB400 users can start using both products immediately. If you are not already a member/user of PUB400.com it is an IBM i V7R5 system "in the cloud" that you can use for free. Visit the PUB400 website to sign up for free today.
To begin using iQuery in your PUB400 5250 session, just enter the RUNiQRY command from command entry. SQLTools functions and Views can be utilized from within any SQL interface (RPG, iQuery, STRSQL and ACS) 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 | |||||
|---|---|---|---|---|---|
| Changes Log | Docs | Pricing | IBM i V7R3, R4, R5 ⤓ | IBM i v7r2⤓ | |
| Build: Mon 28 Nov 2022 - 11:17 AM | Build: Mon 28 Nov 2022 - 11:06 AM | ||||
If you prefer to initiate your purchase via email, click 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 | |
#IBMi V7R2 Users take note: Installing #SQLTOOLS gives you the advantage of having many SQL Services on your V7R2 installation with capabilities formerly available only with IBM Services running on #IBMi V7R3 and later.
Available: Now
Price:
More Information: Customers who have questions, may 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: