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:
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?