iQuery

www.cozTools.com

www.MidrangeNews.com

Contact Us

Follow us on Twitter @SQLiQuery
SQL
            iQuery Logo

SQL iQuery™ for IBM i

The latest on the Covid-19 cases in the U.S.A.Latest Covid-19 Stats


SQL iQuery allows you to create and run modern database queries using SQL and direct the output to popular formats without changing your query code!

The Latest Awesome New Features

  • iQuery Prompter - Runtime Windowed Prompts for your end-user queries.
  • Output Google Charts - Graphical Representation of your data on the Web.
  • iQuery Script - A powerful RPG-like interpreted language to give your queries power.
  • Rapid Query Development - How much time do you really want to spend writing reports, Excel output, PDFs or routing stuff to the web?
  • Huge selection of pre-written macros that allow you to leverage IBM's SQL Services without writing a line of code.

One of the biggest requests we had from our customers was to provide a better way to prompt end-users when a query is run. The current 1980s-style Query/400 runtime-prompt was never a good choice for end-user prompts. To solve this program, we created iQuery Prompts. An easy to use set of SQL iQuery Script statements that generate a lovely prompt window, with input validation. Read more about iQuery Prompting in the SQL iQuery Prompter Manual. Prompting is available now in iQuery v5r8 and later.

SQL iQuery free trial information on our downloads page.

Request a Trial, Update, or Purchase SQL iQuery
10527  Users are being more productive because they use SQL iQuery.
Over 643  trial licenses are in service.
Company (required)
Your name (required)
email (will be sent download instructions)
Please send me:


I am not a ROBOT. Answer this: 9 + 8 =

SQL iQuery is now available with simplified per-System pricing.

Note that on Jan 1, 2021 prices may increase by approximately 20%

Pricing Partitions Active CPU Processors
$3995 Unlimited Up to 4 active cores
$6995 Unlimited Up to 16 active cores
$9995 Unlimited Unlimited active cores

If you have a question or want to make a purchase,

Thinking in SQL™

With SQL iQuery you can run ad hoc SQL statements (including SELECT) from Command Entry, CL or the Web and generate output that includes, print, display, PDF, Excel XML, JSON, CSV, HTML, etc. In addition SQL iQuery includes a powerful scripting language so you can write SQL "programs" to handle tasks that would normally require hundreds or even thousands of lines of RPG IV code.

SQL iQuery Script allows RPG developers to create simple or complex SQL routines and run those routines just like you'd run a traditional Query/400 object--but better because your developers can actually modify the query code using SEU, RDi or any other editor. 

The latest release of SQL iQuery outputs your SQL results to the display, print, Excel, JSON, CSV, XML, HTML, PDF, Google Charts and more! Just change the OUTPUT parameter:

RUNiQRY SQL('Select cstnbr,cstname,sales,ordnbr,tax from orders') OUTPUT(*JSON)

To view the latest updates included in this release visit our Change Log.

Cool SQL iQuery Features:

  • iQuery Prompter
  • Externally Described SQL
  • Selection of Macros to simplify running IBM i Services and more
  • Growing list of SQL iQuery SQL UDF functions.
  • Advanced SQL Scripting Language built-in
  • Integrated Prompt Support to give end-users easy-to-user prompts for their queries
  • Improved Web Support including File Uploads!
  • Page and Level-break style controls when data changes.
  • #PAGEBREAK command to control when to skip to a new page in your printed output or to start a new WorkSheet in Excel output.
  • OUTPUT(*EXCEL) Now supports multiple WorkSheet "tabs"
  • Column Totals in Excel are now replicated within each new Worksheet.
  • More formatting capabilities in Excel Columns.
  • #PRTSPACING command controls the number of lines to space between printed lines.
  • Excel output now supports *MAC or *PC or *WINDOWS options for Target Platform designation.
  • print after command allows non-SQL resultSet data to be added to the output of Excel or printed content.
  • New #TITLES and #COLHDR commands can be used to suppress the title and/or column headings.
  • New Job Attributes View, iQuery.JOB_ATTR that is built over our JOB_ATTR() UDTF.

Helpful Articles/PDFs and Extras

The latest version of iQuery focuses on the web. Specifically we are the only solution that allows you to move SQL results directly to JSON files on the IFS or directly to the Web browser for processing by standard web tools, such as JQuery, DataTables, W3Schools, and many others. We can do this because our SQL iQuery product can write the results of your SQL SELECT statements directly to the web browser as JSON content.

Our customers have build entire websites using just SQL iQuery v4 along with HTML and thier favorite JavaScript because iQuery can produce JSON.

When you need something that you can start using immediately, SQL iQuery v4 is your best choice.

But we didn't stop there. SQL iQuery now supports native .XLS Excel output directly allowing customers to transform their native SQL SELECT statement results to EXCEL. You can even email the results directly to your end-users--it's all built-in.

This is the best version we've ever released; it is time to start taking advantage of the great features found in SQL iQuery

SQL iQuery is a modern SQL tool that allows you to immediately view your SQL SELECT statement results on the web, the green screen, PDF, Excel, JSON, XML, CSV and others.

Modernize Your Queries using SQL iQuery

SQL iQuery allows you to use standard SQL to build reports, PDFs, Excel files, database outfiles, and web content. You can also replace most legacy Query/400 scripts with iQuery and get the job done faster. In addition, using one or two SQL statements can often help you avoid writing hundreds or even thousands of lines of RPG code--and SQL iQuery gives you the flexibility to modify those statements externally or at runtime.

Our RUNiQRY (Run SQL using iQuery) command is going to be your RPG Developer's new best friend!

The iQuery SQL Scripting tool provides the most powerful SQL Scripting system on the platform.

Data Conversion

What good is a tool if every time you need an alternate output format, you have to buy an add-on, install a new feature, or go looking for yet another tool? With SQL iQuery, you simply specify the output format you want and the existing industry standard SQL statement is used to produce the data in that format; nothing's easier. Here's a list of output formats supported by SQL iQuery's Write One and Done interface:

With SQL iQuery, it does not matter what the end-format is going to be. You can prototype the SELECT statement until you get it the way you want it, then decide what the output format will be. Use our interactive viewer to view your results, customize and refine the statement, tweak the titles and then save it to a source file member. When you're ready to run that statement, you decide what output format you need. Need a PDF today but that one special user wants in it Excel? No worries, just run it and set the OUTPUT parameter to *EXCEL and it just works. You're the hero!

Contact Us...

Product Information

  • Name: SQL iQuery
  • Install Library: IQUERY
  • Product ID: 2COZ-IQ5
  • Built for IBM i: v7.3 and later
  • SQL iQuery CL Commands: RUNIQRY and RUNIQRYF

Check out SQL iQuery for yourself. Download our free trial today.

Copyright © 2014 Cozzi Productions, Inc. All Rights Reserved.

SQL iQuery and the iQuery Logo are trademarks of Cozzi Productions, Inc.

"Thinking in SQL" ™ in a trademark for Cozzi Productions, Inc.