Re: RUNSQL Insert Into IFS file syntax help

[Charles Wilt <charles.wilt@xxxxxxxxx>]

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