← Back to SQL iQuery
SQL Tools is a huge selection of SQL functions that improve RPG programmer productivity by eliminiating the complexity that using APIs requires. All IBM i SQL, RPG and CL interfaces support #SQLTools.
Update Log | Docs | Pricing | IBM i V7R3/R4 Trial ⤓ | IBM i v7r2 Trial ⤓ | |
Build: Mon 16 May 2022 - 12:04 PM | Build: Mon 16 May 2022 - 11:57 AM | ||||
Compatible with IBM i Version 7 Rel 2, 3 and 4
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 for calls to IBM i API.
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.
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: SQL Tools is offered to IBM i customers for a small annual software fee. You license the current version ("SQL Tools 2021" as of this writing) and receive all updates/fixes to that version. Each year you have the option to pay your SWMA for SQL Tools. Customers who want to stay current and receive updates, fixes, and enhancements, simply pay the recurring SWMA fee when billed. If you elect to opt-out of SWMA the then current version of the software shall continue to function on whatever system it is installed but updates, support and system serial number transfers shall require payment of any missed SWMA fees. Here's how it breaks down:
More Information: Customers who have questions, may reach out to Bob Cozzi at this link.
Note that if you install the V7R2 version, you need to use file names SQLTOOLS72.ZIP and SQLTOOLS72.SAVF
Extended Installation Instructions
Vendor Info: