Midrange News for the IBM i Community


Posted by: Bob Cozzi
Rogue Programmer
Cozzi Productions, Inc.
Chicagoland
SQL Output Options
has no ratings.
Published: 02 Jun 2014
Revised: 16 Dec 2015 - 973 days ago
Last viewed on: 15 Aug 2018 (3129 views) 

Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.

SQL Output Options Published by: Bob Cozzi on 02 Jun 2014 view comments(7)

The standard IBM i SQL can output to *DISPLAY, *PRINTER, and *OUTFILE.

Our new SQL Query File tool can output to these as well as *PDF and *TEXT files.

I'm wondering what other output features would be helpful to end-user shops?

Currently we have the following output formats in plan:

  • OUTPUT(*CSV) - Write the result set to the IFS as a CSV file.
  • OUTPUT(*TEXT) - Writh the result set to the IFS as plain ASCII text file.
  • OUTPUT(*XML) - Write the result set to the IFS as Standard XML.
  • OUTPUT(*JSON) - Write the result set to the IFS as a text file with JSON content.
  • OUTPUT(*HMTL) - Write the result set to the IFS as an HTML text file.
  • OUTPUT(*EXCEL) - Write the result set to the IFS as an Excel-compatible "Symbolic Link" (SLK) file.

These are just in our plans now, in order of importance to us. Are there other formats that are as important as these? Are these important?

 

Return to midrangenews.com home page.
Sort Ascend | Descend

COMMENTS