Maybe you can find useful : https://github.com/vinay20045/json-to-csv


Massimo Fantin


-----Messaggio originale-----
Da: OpenSource <opensource-bounces@xxxxxxxxxxxxxxxxxx> Per conto di Bryan Dietz
Inviato: venerdì 8 marzo 2019 17:48
A: IBMi Open Source Roundtable <opensource@xxxxxxxxxxxxxxxxxx>
Oggetto: [IBMiOSS] new db2util rpm

I noticed a new RPM out there :

db2util

looking at the help and trying out looks like it will be very useful.

I think it could use a column name option for CSV and SPACE formats.

Like the ability to use parms.


Bryan


db2util [options] <sql statement>
Options:
-o <fmt> Output format. Value values for fmt:
json:
[{"name"}:{"value"},{"name"}:{"value"},...]
csv: "value","value",...
space: "value" "value" ...
-p <parm> Input parameter(s) (max 32)
-h This help text
-v Show version number and quit

Examples:
db2util "select * from QIWS.QCUSTCDT where LSTNAM='Jones' or LSTNAM='Vine'"
db2util -p Jones -p Vine -o json "select * from QIWS.QCUSTCDT where LSTNAM=? or LSTNAM=?"
db2util -p Jones -p Vine -o space "select * from QIWS.QCUSTCDT where LSTNAM=? or LSTNAM=?"
--
This is the IBMi Open Source Roundtable (OpenSource) mailing list To post a message email: OpenSource@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/opensource
or email: OpenSource-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at https://archive.midrange.com/opensource.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.