Re: RUNSQL Insert Into IFS file syntax help

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