×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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
midrange.com
