Re: RUNSQL Insert Into IFS file syntax help

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