END_OF_LINE: Is not supported if IFS_WRITE_BINARY is used.REPLACE An existing file is replaced, deleted and a new one created.NONE If the file already exists nothing happens.APPEND If the file in the path name exists add to the end of the file.
If IFS_WRITE_UTF8 is used the CCSID will default to 1208, for the others it will be the partition's default If I am writing to an existing file this is ignored. Having played with this this is so much easier using these new SQL procedures.Īs with the IFS read table function there are three different SQL procedures to write to an IFS file: Prior to these TRs I had used C APIs embedded in a RPG program.
This was added in the latest round of Technology Refreshes, IBM i 7.4 TR3 and 7.4 TR3. Then it was how to read an IFS file, today will be the opposite writing to an IFS file.
This post continues yesterday's theme of doing things to files in the IFS with SQL.
