|
I don't know of any way to `INSERT INTO` a IFS stream file...
There's a couple of ways to redirect the output of a `SELECT` into a stream
file
- oldschool, q-shell db2 command,
qsh cmd('db2 \"select * from lib.table\" > /home/myuser/myifsfile.txt')
- newschool (I think), ACS Run SQL scripts running on the i itself.
Need to find a link for the second option.
Charles
On Wed, Aug 26, 2020 at 8:46 AM Bob Schwartz <rschwartz@xxxxxxxxxxxxxxx>
wrote:
Looking for some help on the proper syntax for SQL Insert Into statement.
Trying to write a CLP to extract some audit journal entries and then copy
them out to the IFS for analysis.
I have the RUNSQL statement below, the slashes "/" in the IFS file path
are giving me a problem.
I'm trying to avoid creating a PF and then running CPYTOIMPF. Thanks for
your help.
RUNSQL SQL('INSERT INTO /home/gcaudit/A0825ZC.csv SELECT ZCTSTP,
ZCJOB, ZCUSER, ZCNBR, ZCPGM, ZCPGMLIB, ZCUSPF, ZCSYNM,
ZCRADR, ZCONAM, ZCOLIB, ZCOTYP, ZCACTP, ZCODTA, ZCPNM
FROM GCAUDIT.A0825ZC') NAMING(*SQL)
Token / was not valid. Valid tokens: <IDENTIFIER>.
RUNSQLSTM or RUNSQL command failed.
Thank you,
Bob Schwartz
Director of Technology Services
Glynn County Schools
1313 Egmont St.
Brunswick, GA 31520
--
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
As an Amazon Associate we earn from qualifying purchases.
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.