I am trying to
CPYTOIMPF FROMFILE(QTEMP/SQLTEMP3) TOSTMF(&PATH) +
MBROPT(*ADD) STMFCODPAG(*PCASCII) +
This is successful IF the CCSID = 37, but fails if the CCSID is 65535.
Shown below are some files I have been playing with. (fails defined as garbage when opened in MS Excel).
File Library Type Coded
File Set Id
QADSPFFD QTEMP P 37
RJSQMQRY QTEMP P 37
SQLTEMP2 QTEMP P 37
SQLTEMP3 QTEMP P 37
SQLTEMP4 QTEMP P 65535
WORKHEADER QTEMP P 37
WORK1WFLDS QTEMP P 37
WORK2WFLDS QTEMP P 65535
X QTEMP P 37
CRTPF rcdlen(3000) will NOT allow CCSID set to 37, it only allows *job.
Even if I force
CRTPF FILE(QTEMP/X) RCDLEN(3000)
The CCSID is STILL 65535, which will fail when using CPYTOIMPF.
1) How can I create a file that will be successful with CPYTOIMPF?
2) How can I force a file to be created with CCSID 65535
This outbound email has been scanned for all viruses by the MessageLabs Skyscan service.
For more information please visit http://www.symanteccloud.com
As an Amazon Associate we earn from qualifying purchases.