×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
I am trying to
CPYTOIMPF FROMFILE(QTEMP/SQLTEMP3) TOSTMF(&PATH) +
MBROPT(*ADD) STMFCODPAG(*PCASCII) +
RCDDLM(*CRLF)
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
Of Character
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
CHGJOB CCSID(37)
Then
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
Thanks!!
______________________________________________________________________
This outbound email has been scanned for all viruses by the MessageLabs Skyscan service.
For more information please visit
http://www.symanteccloud.com
______________________________________________________________________
midrange.com
