|
It looks like CPYTOIMPF in V6R1 is now treating the parms
exactly as documentedâthe FROMCCSID in the below CPYTOIMPF
defaults to *FILE and the temporary flat file RSPQSPRCCV is
65535. So according to the help <ed: for FROMCCSID parameter>
below, CPYTOIMPF will not convert the flat file data.
*FILE
The data is converted from the from-file field CCSID.
If the CCSID of the from-file field is 65535, the field
is not converted and it is treated as binary data.
Unless the FromCCSID = 37 or the FromFile is
a database file (could use gmiddsc dds(#5000) to create
the file with one field).
I'm really surprised that this issue did not come up before.
I remember this issue back in the V5R3 to V5R4 upgrades.
CPYTOIMPF FROMFILE(QTEMP/RSPQSPRCCV) fromccsid(*FILE --> 37) TOSTMF('home\RSPData\srocdran.csv') MBROPT(*REPLACE)
STMFCODPAG(*PCASCII) RCDDLM(*CRLF) DTAFMT(*FIXED)
STRDLM(*NONE)
The issue I am having is that the data within certain fields is not converting properly (below RCODE and RDESCR fields). Changing
CCSID(37) fixed it. The problem is we have nearly 500 programs
where we need to change CCSID to 37, which is tough task, I am
trying to find if there is any easy solution (perhaps any PTF???)
rather than going through all 500 programs and changing them to
37.
RABCID|RCODE|RDESCR|RDD| T|Ã|ÃÃÃÃ@ÃÃÃ`ÃÃÃÃ|57| T|Ã|ÃÃÃÃ@ÃÃÃ`ÃÃÃÃ|57|
RCODE is defined as 1 CHAR and RDESCR is defined as 30 CHAR.
CRPence wrote:
AFaIK the job CCSID is used by the CPYTOIMPF only for
treating the literals on the command, not for [overriding]
the columns\fields of the database file. Thus the problem is presumably with how the file was created. That is, I expect that the noted "temporary file" was created as a program-described file [e.g. CRTPF RCDLEN(specified) or BLDFILE], which has no support for a CCSID of its [effectively]
one column\field. Remove the temporary file from processing, or use a temporary file which has its text field(s) assigned with a CCSID which properly describes the data.
<<SNIP>>
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.