Midrange News for the IBM i Community


Posted by: Bob Cozzi
Rogue Programmer
Cozzi Productions, Inc.
Chicagoland
Anyone Using SQL CLI for iseries IBM i
has no ratings.
Published: 12 Mar 2014
Revised: 13 Mar 2014 - 1197 days ago
Last viewed on: 22 Jun 2017 (2900 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.

Anyone Using SQL CLI for iseries IBM i Published by: Bob Cozzi on 12 Mar 2014 view comments(3)

I'm wondering if anyone is using CLI (SQL Call-level Interface aka "ODBC") natively on IBM i?

I've built a wrapper that allows me to effectively displace embedded SQL when necessary. Aside from a few benefits, there is really no significant advantage to CLI over embedded SQL, but I needed to be able to manipulate the resulting datasets for a report writer, so i wrote a wrapper that mimics the openSQL, fetchSQL, CloseSQL functions of embedded SQL.

This SQLLIB service progam also returns the data in any of (currently) three formats:

  1. Native format (packed, char, zone, etc.)
  2. Text format (all data converted to plain text)
  3. HTML format (all data converted to plain text and wrapped in HTML

Eventually I'm going to add CSV, JSON and XML to the resulting formats. But I'm still working on the kinks, while using extensively in a new Report Writer I built just for fun.

So, do you see any use for something like this, or should I put it in the vault of cool stuff I keep to myself?

 

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

COMMENTS