iQuery

www.cozTools.com

Contact Us

Follow us on Twitter @SQLiQuery
SQL iQuery Logo

Thinking in SQL™

SQL iQuery, SQL Tools, or COZTOOLS'86 for IBM i

At Cozzi Productions, we been providing the solutions for #IBMi since 1984 when we introduced our first software product (4 years before they called it "AS/400"). Today, our SQL iQuery product, a follow-on to our popular "SQL Lite" product from the mid-1990s has been creating CSV, PDF, and EXCEL from pure SQL on #IBMi since we rewrote it from the ground up in 2016. The web version of iQuery, iQuery for Web™ has been running our IBM i-hosted websites ever since.

Our hugely popular SQL Tools is a collection of SQL Functions or "services" as some call them that allows you to use regular SQL syntax in RPG, ACS, or SQL iQuery to retrieve information that normally requires extensive use of IBM i APIs calls and data structures, CL commands or MI instructions. With SQL Tools you easily get access to system information, database info, Systems Admin needs, and more!

Limited Time Offer
Our 2 powerful SQL products are now FREE*.
Today through August 31, 2022 SQL iQuery and SQL Tools are waiving their initial up-front license fee. That's right, if you order and pay for SWMA for either product on or before the end of August, you receive a credit for the full purchase price, less the SWMA.

* Free means you pay no software license fee, only the annual SWMA is due.

PUB400.com Now Includes iQuery and SQLTools

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.


SQL iQuery
Powerful SQL processor to run SQL statements using a green screen CL command (RUNiQRY), the web (iQuery for Web) and within RPG IV via our provided calls to iQuery APIs. Output the results of the SQL SELECT statement to JSON, XLS, CSV, XML, PDF, TEXT, etc. and automatically email it to your customers or employees.
SQL Tools
Powerful SQL functions and stored procedures that you can use from any SQL interface, including RPG IV with embedded SQL, IBM ACS, SQL iQuery and even CL via RUNSQLSTM or RUNSQL. If you need something that makes access to API results easier, SQL Tools is the perfect solution. SQL Tools provides access to dozens of existing IBM i APIs via easy-to-use SQL functions. Learn more about SQL Tools...

Today, with a growing number of #IBMi retirement events, our SQL Tools product provides a complete set of interfaces that allow experienced and novice developers to access IBM i information from within their RPG IV or SQL applications. Whether it is for Systems Admin and generalized use purposes in RPG IV, SQL Tools makes developers more productive.

Whether they're a 30-year Senior Software Developer, or a newbie who enjoys "code cloning" development, #SQLTools provides a consistent interface that is both familiar and portable. #SQLTools provides a consistent interface across #IBMi release levels. Whether you have some partitions running v7r2 or you've upgraded to v7r4, #SQLTools provides identical results (where available) across all supported #IBMi release levels.

We've seen our major competitor's software that's costing you 10 to 15 times more up front and annually; and we were not impressed. Using System/38-era techniques to run SQL in CL, Command Entry and elswhere, really? For a small fraction of their annual SWMA fees, you can have a full license to SQL iQuery and #SQLTools and everybody is going to be so much happier! Sure they won't be able to buy that new yatch this year, but I'm sure they'll be fine, and think of the money you'll save!

#SQLTools is our newest product. It is a stand-alone product that complements SQL iQuery, but can also be used with any other SQL interface on #IBMi, such as STRSQL, RUNSQL, IBM ACS RUN SQL SCRIPTS, embedded in RPG IV and even that high-priced System/38-era package you may own. Imagine using RPG IV and being able to create a *USRSPC, generate a list of source members, retrieve an object's description, or even check if an object exists, using a simple SQL statement. That's what SQL Tools provides to your organization.

Pricing and Availability

Use this table to purchase a support option, or to download one of our awesome products.

Product Annual SWMA Up-front Cost Supported IBM i Release Levels Download Installation Info
SQL Tools 2021 Included in SWMA V7R2, V7R3, V7R4+ Install info
SQL iQuery v7 V7R2, V7R3, V7R4+
COZTOOLS '86 OSE No-Charge
Flex License*
V7R2, V7R3, V7R4+ Install info

If you've already purchased SWMA and need help, or if you need assistence with a purchase:

Cozzi Productions Flex License

Flex Licensing

A new no-charge software license from Cozzi Productions, Inc.

Under the terms of our Flex License program, customers may download and install our licensed software onto their IBM Power computer server running #IBMi (IBM operating system "i"). A 60-day license grace period to use the software is granted upon installation. This allows customers to evaluate the software before a final decision to setup SWMA payments. Once SWMA fees are received by Cozzi Productions, Inc, a permantent License Key shall be issued. This key never expires and may be used for the then current version of our software unless otherwise noted. If no SWMA fee is received by the end of the designated grace period, the software may no longer be used and may stop operating on your computer server. Once SWMA is established, future yearly SWMA fees will be billed automatically providing the customer with future updates and fixes.

NOTE: Our COZTOOLS'86 software is no-charge so no SWMA or license fee is charged for using it and no license key is required.

SQL Tools 2021 is our latest product. It picks up where the standard set of SQL Services leaves off, providing dozens of new SQL Functions and Procedures to make you do your job faster than ever before! Visit the SQL Tools online Docs page to read more about each available SQL Tools function. Then visit the Buy Now page and get started!

SQL iQuery is our most popular #IBMi software ever. If you tried to run the SQL SELECT statement from Command Entry and view the results, you found that the IBM RUNSQL and RUNSQLSTM commands just don't stand up. There are myriad techniques to move results into files using all kinds of nonsense. I read those techinques in articles all the time. But with SQL iQuery you can simply run the SELECT and any other SQL statement from command entry, CL, or where ever. Just type in something like: runiQry 'select * from qiws.qcustcdt' <enter> and get the results right there on the screen. Or using the OUTPUT parameter, redirect the output to a number of formats including: EXCEL, PDF, TXT, CSV, JSON, XML and more. The powerful SQL iQuery Script language is nearly an interpretive RPG-free language that your programmers can start using immediately.

COZTOOLS '86 is probably already on your system. It has been mimicked by myriad 3rd party software houses and indepents for decades. First introduced as Q38 Programmer Utilities back in 1986, this package has been kept up to date for decades. It was rebranded RPGTOOLS for a while and has been known as "Cozzi Tools" for the last two decades. Now, Cozzi Tools'86 (pronounced "cozy") is a no-charge product, with source code included! Visit the Cozzi Tools page for more info.

  • Copyright © 2014 Cozzi Productions, Inc. All Rights Reserved.
  • SQL iQuery and the iQuery Logo are trademarks of Cozzi Productions, Inc.
  • "Thinking in SQL" is a trademark for Cozzi Productions, Inc.