Re: Calling CPYTOIMPF from an RPG program.

On 1/25/2017 4:44 PM, Tom L. Deskevich wrote:

I have a file with one record in it.

If I run this from a command line, it works.

CPYTOIMPF FROMFILE(SELRE25PHD) +
TOSTMF('/IMAGE/SELRE25P.CSV') +
MBROPT(*REPLACE) STMFCODPAG(*PCASCII) +
RCDDLM(*CRLF)

If I call it from an RPG program, it creates the CSV file, but it is empty.
To complicate it more, if I force 4 more records in the file, it writes 3
when I run it from the RPG program.

Does this same RPG program write the records to SELRE25PHD? I'm
thinking that it hasn't written all of the records by the time the
CPYTOIMPF runs. Specifically, that the last of these records is still
in the I/O buffer.

Have you looked at Scott Klement's IFS API service program? You could
write() those records to the IFS directly, without having to go through
a DB2 table and intermediate utility.