SQL Tools for IBM i

The New Standard in "Every IBM i Shop has It"

SQL Tools is the perfect collection of powerful and easy-to-use SQL Functions for your #IBMi shop. They can be used with any SQL interface. Use them in your RPG IV applications so you have access to things previously only available through APIs and CL commands. Also use them stand-alone in your favorite SQL processor.

Compatible with IBM i Version 7 Rel 2, 3 and 4

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.

• SQL Embedded in RPG IV users can simply insert these functions into new or existing EXEC SQL statements.
• SQL iQuery users can use them in SQL statements run via RUNiQRY or embedded in SQL iQuery Scripts.
• RUNSQL and RUNSQLSTM users can use them just like any other SQL function.
• IBM ACS RUNSQL SCRIPTS users can use SQL Tools to extend and enhance access to their IBM i server's data.
• HelpSystem SEQUEL SQL Data Access

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 at an initial one-time fee. If you want to stay current and receive annual updates and fixes, we offer annual software maintenance. And as always: no per-partition charge, 2-serial number license. Here's the break down:

1. $695 (OTC) one-time charge, includes:
• Updates and fixes for one year.
• Technical Support and usage questions for 90 days.
• Up to 2 IBM i Serial numbers licenses.
• Unlimited Users/Unlimited Partitions on the same phsyical IBM i system.
2. After first year, annual maintenance is available (SWMA) for just $395/year. It includes:
• Updates to latest release and fixes.
• Serial number transfers requires (e.g., system upgrades or replacements).
• Technical Support and usage questions.

Order online

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

Vendor Info:
Cozzi Productions, Inc.
www.SQLiQuery.com
Lombard IL 60148
USA

SQL Tools Documentation Index

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 these "reactive " web pages linked below. It currently supports mobile and desktop experiences. Click or tap the SQL Tool name (below) and it's current parameters and documentation will appear.

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