×
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.
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 mailing list archive is Copyright 1997-2024 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.
midrange.com
