Re: Data not getting written to /tmp

FWiW on v5r3, even without any file named ENVELOPE in *LIBL, the result is shown following the request:

CPYTOIMPF FROMFILE(ENVELOPE) TOSTMF('/tmp/ALEXANDER.xml')
MBROPT(*REPLACE) TOCCSID(437) RCDDLM(*CRLF) DTAFMT(*FIXED)
CPD281B TOCCSID not valid when output file is a stream file.
CPF0001 Error found on CPYTOIMPF command.

That error is because the TOCCSID parameter is for export to a database file. On newer release(s) there is a STMFCCSID parameter to replace the STMFCODPAG parameter.

But the CCSID 37 is /correct/ for USA and Portugal, but that is an EBCDIC CCSID. The CCSID 437 is "USA PC-DATA" ASCII. There are likely better choices for ASCII, but it should be valid for STMFCCSID(437).

FWiW if the /program/ invoking the request is SQLRPG vs RPG, or that program or a prior invokes the SQLCLI, there were issues in the past which require only server-mode SQLCLI to prevent /sequence error/ issues with the export\import use of the SQLCLI.

Regards, Chuck

On 05 Apr 2013 22:24, Gary Kuznitz wrote:

Is the CCSID supposed to be 37 for the USA? Could that be the
problem?

On 5 Apr 2013 at 22:20, Gary Kuznitz wroet:

When I run it in on the test side within the program it runs fine.
The records get coppied.
When I run it on the live side within the program it doesn't copy
the records. When I run it
on the live side from the cmd line it does copy the records.
CPYTOIMPF FROMFILE(ENVELOPE) TOSTMF('/tmp/ALEXANDER.xml')
MBROPT(*REPLACE) TOCCSID(437) RCDDLM(*CRLF) DTAFMT(*FIXED)
I don't see what the difference is between running the cmd inside
the program and from the cmd line with everything else being equal.