RE: Calling SQL from QSH was: CPYTOSTMF -- MIDRANGE-L

× 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.

QSH CMD('db2 "select cola, colb, colc from mytable where condition =

true" > /tmp/myfile.txt')

With the above, IFS file /tmp/myfile.txt will contain your output.

Try
it ... you might enjoy! :)

Interesting post Dennis - this is the first time I've seen a reference
to calling SQL from QSH. Are there any restrictions in calling SQL this
way? Are there any other references?

Just the usual restrictions that you'd have from, say, a STRSQL session.
For example, no cursors, no variable names and the like. It gets
interesting when you need to imbed apostrophes and/or quotes, but all this
is surmountable.

I *believe* this is documented in the QSH manual. If not, a search for UDDB
DB2 should produce nice fruit.

Now to find a use for it!

Ah, yes! There's the rub! :) Hint: your statement might look something
like this:

QSH CMD('db2 "select cola || ',' || colb || ',' || colc from mytable" >
/tmp/mycsv.csv

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
Patience - a minor form of despair disguised as a virtue.
-- Ambrose Bierce

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.