Back to SQL iQuery

SQL Tools for IBM i

Compatible with Version 7 rel 2, 3 and 4

The New Standard in "Every Shop has It"

SQL Tools is a perfect collection of powerful and easy-to-use SQL Functions for #IBMi that can be used with any SQL interface. You can modernize those RPG IV applications so that you have more powerful access to things like APIs and utilities or use them stand-alone in your favorite SQL processor.

SQL Tools replaces thousands of lines of error-prone RPG coding of API calls, providing direct SQL access to many APIs as well as a ton of new functionality, such as date conversions, base64 decoding and more.

As a convention, we've elected to use the LIBRARY, OBJECT, TYPE sequence order for parameters whenever possible. This means that when a SQLTOOLS UDTF requires an object and library, the library name is normally the first parameter, followed by the object name, and if necessary, the object type. This matches the SQL SCHEMA.TABLE sequence so your brain can be "Thinking in SQL Mode" while using SQL Tools. For example:

select * from table( sqlTools.object_list('COZTOOLS','RTV*','*CMD')) ol;
select srctype,text,chgdts,cur_records
from table( sqlTools.rtvmbrd('CODESRC','QRPGLESRC','WRKUDTF')) mbrd;

In rare/specialty cases where the library name is often not used, such as with *PDFMAP or *DEVD objects, the library name parameter follows the object name parameter, or there may be no library name parameter. For example:

select * from table(sqlTools.rtvpdfmap('QPRINTMAP')) pdfmap;
select * from table(sqlTools.rtvdevsts('TAP01')) sts;

Pricing and Availability

Available: June 2, 2021

Price: SQL Tools is offered to IBM i customers as an initial one-time fee with an annual software maintenance and upgrades option. You buy a license to the current version at the time of licensing and keep it forever. If you want to stay current and receive annual updates and fixes, we offer annual software maintenance. And as always, no per-partition charge. Here's the break down:

  1. $695 (OTC) one-time charge.
  2. After first year, annual maintenance is available for just $395/year.

More Information: Customers who have questions, may reach out to Bob Cozzi at this link.

Customers who want to prepare to order, can submit an approval for "SQL Tools 2021" to whomever they need to, for a one-time charge of $695 (USD) to be delivered on or before June 10, 2021. Those orders may be submitted to us beginning June 2, 2021.

Vendor Info:
Cozzi Productions, Inc.
Lombard IL 60148

SQL Tools Function List

Each SQL Tool includes a link to it's documentation. This is an evoling document and is updated frequently. We are using SQL Tools to help produce this "reactive" web page documentation linked below. It currently supports mobile and desktop experiences. Click or tap the SQL Tool name (below) and it's current parameters and docs should appear.

Function Description
#END List