Re: IFS to Database file.

IIRC with CRTPF QTEMP/INPUT RCDLEN(220) you cannot set a CCSID on the CRTPF
command, so it is 65535. If you created a DDS based (or DDL based) PF with
one field, length 220, you have to use CPYFRMIMPF. (I thought you couldn't
use CPYFRMIMPF one flat data files, either, but I can be wrong)

Also change the CCSID of the IFS file to 850 and then specify the value
*PCASCII on the appropriate paramenter (do not know which at the moment).

And perhaps change the system value for CCSID to 37 before you do this (if
possible).

With regards,
Carel Teijgeler

*********** REPLY SEPARATOR ***********

On 15-10-2008 at 9:19 Wintermute, Sharon wrote:

I am trying to convert a flat file from the IFS into a database file so I

can import it into other databases.

===> CPYFRMIMPF FROMSTMF(input.txt) TOFILE(QTEMP/INPUT) MBROPT(*REPLACE)

RCDDLM(*ALL) STRDLM(*NONE) RMVBLANK(*NONE)

Where QTEMP/INPUT was simply CRTPF QTEMP/INPUT RCDLEN(220)

Now this works fine on 3 out of 4 systems. One is V5R2, V5R3, V5R4. The

one it won't work on is V5R3.

I checked the CCSID system value, they are all set to 65535.

The translation from ascii to ebcdic does not occur on the one box. Why?