Re: RUNSQL Insert Into IFS file syntax help -- 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.

Actually you CAN do what you are asking for with this Open source gist:

https://gist.github.com/NielsLiisberg/0d83cb5e76f3b6d455c7258d733fda64

Simply use “cat youFile.csv” when you look at the example

tor. 27. aug. 2020 kl. 19.08 skrev Bob Schwartz <rschwartz@xxxxxxxxxxxxxxx>:

I forgot about this one, I appreciate everyone's feedback. All very
helpful.

... a little bit limited:

qsh cmd('db2 ''select * from myFile'' > myPath/myFile.txt')

D*B

This is a short term project, may not need to do this again, or very
often.

I'll just use the iACS SQL tools and grab what I need from the PF's .

Thank you,

Bob

--

This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx

To subscribe, unsubscribe, or change list options,

visit: https://lists.midrange.com/mailman/listinfo/midrange-l

or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx

Before posting, please take a moment to review the archives

at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

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

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.