Re: CPYTOIMPF and accented characters

[Mohammad Tanveer <surgum@xxxxxxxxx>]

Thanks A LOT! It worked.  I followed your instructions step by step.
Specially changed JOB CCSID to 37.

On Wed, Nov 2, 2016 at 10:42 AM, Buck Calabro <kc2hiz@xxxxxxxxx> wrote:

> On 11/2/2016 11:38 AM, Mohammad Tanveer wrote:
> > IBM I version 5770SS1 V7R2M0
> >
> > tried multiple combinations
> > CCSID of the DB2 Column (tried with 37, 278, 1143)
> > CCSID of the IFS File (278, 1251, 1143)
> > CCSID of the job is 65535
>
> I suspect that the job CCSID is the issue.  65535 means 'do not
> translate'.  I see the A-ring in the ultimate text file when I have the
> following:
>
>
> ACS SQL script tool, user profile CCSID(37):
>
> create table danish
>   (char_column char(30) ccsid 278);
>
> insert into danish
>   values('KÆRBØLVEJ 52');
> insert into danish
>   values('MÅGEVEJ 44');
>
> select *
> from danish;
>
> KÆRBØLVEJ 52
> MÅGEVEJ 44
>
>
> TN5250 job CCSID(37)
> CPYTOIMPF FROMFILE(DANISH) TOSTMF(danish.txt) STMFCCSID(*PCASCII)
> RCDDLM(*CRLF)
>
> dbu danish
>
> Char_column
> KÆRBØLVEJ 52
> MÅGEVEJ 44
>
>
> dsppfm danish
>
> KÆRBØLVEJ 52
> M$GEVEJ 44
>
> ***NOTE***
> DSPPFM apparently uses a different translation scheme!
> ***NOTE***
>
>
> On PC, run CMD.EXE, US English
>
> C:\buck>ftp 10.1.0.4
> Connected to 10.1.0.4.
> 220-QTCP at 10.1.0.4.
> 220 Connection will close if idle more than 5 minutes.
> User (10.1.0.4:(none)): buck
> 331 Enter password.
> Password:
> 230 BUCK logged on.
> ftp> cd /home/buck
> 250-NAMEFMT set to 1.
> 250 "/home/buck" is current directory.
> ftp> get danish.txt
> 200 PORT subcommand request successful.
> 150 Retrieving file /home/buck/danish.txt
> 226 File transfer completed successfully.
> ftp: 68 bytes received in 0.00Seconds 68000.00Kbytes/sec.
> ftp> quit
> 221 QUIT subcommand received.
>
> C:\buck>notepad danish.txt
>
> "KÆRBØLVEJ 52                  "
> "MÅGEVEJ 44                    "
>
> --
>   --buck
>
> Visit wiki.midrange.com and register for an account. Edit a page that
> helps you, and because it's public, you'll help someone else, too!
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.