Re: RUNSQL Insert Into IFS file syntax help

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Problem is, you generally can't write directly to IFS files - they are 
not database objects. Since 7.3 there are several IFS-related SQL 
service, but they are for retrieving information ABOUT IFS objects.

There are ways to write to CLOB - character large objects - those are 
still not record-layout tables. There are ways to build XML files 
directly that can be based on database data.

Hope that give you a couple directions to look at. Nothing quite so 
simple, though, as what you'd like to do here!

Vern

On 8/26/2020 9:46 AM, Bob Schwartz 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