RE: help with CCSID - how to ensure a file can be successfully sent to root directory using CPYTOIMPF

Chuck - if I run the following, it DOES assign a CCSID. But you are stating this cannot be???



CRTPF FILE(QTEMP/X) RCDLEN(111)
File X created in library QTEMP.
Member X added to file X in QTEMP.

3/29/12 Display File Description
DSPFD Command Input
File . . . . . . . . . . . . . . . . . . . : FILE X
Library . . . . . . . . . . . . . . . . . : *LIBL
Coded character set identifier . . . . . . : CCSID 37





" Also as the OP already responded, a database /flat file/ [aka a
program described database file] can not be assigned a CCSID because the
flat file is inherently undescribed... just rows\records of binary data
of the fixed record length."

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of CRPence
Sent: Wednesday, March 28, 2012 6:57 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: help with CCSID - how to ensure a file can be successfully sent to root directory using CPYTOIMPF

On 28-Mar-2012 15:16 , DeLong, Eric wrote:

I would also mention that changing that system value seems to be
safe for most systems, especially those here in the US, where CCSID
00037 is most common.

Setting the value in a User Profile limits the scope, and allows
customization according to the environment\language specific to the user.

For this specific case, you might just try this before your
CPYTOIMPF command...

CHGPF FILE(QTEMP/SQLTEMP3) CCSID(037)

The CHGPF is best avoided to change the CCSID of a database physical
file, except for source files, and only when the text data in all of the
source members is known to be in the newly specified CCSID; i.e. just
tagged incorrectly presently. The original design intent of the CHGPF
CCSID(specified) is to assign a CCSID from when before CCSID support
existed, and thus has [potentially undesirable] consequences beyond just
changing the CCSID of the column(s); i.e. all /text/ CCSIDs for the file
are set to the specified value even if they are already correct, and for
which LABEL and COMMENT would have to be re-applied to recover. AFaIK
the support is not modified to be in any way /smart/ about avoiding that
effect.

Also as the OP already responded, a database /flat file/ [aka a
program described database file] can not be assigned a CCSID because the
flat file is inherently undescribed... just rows\records of binary data
of the fixed record length.

Regards, Chuck