Re: CPYTOIMPF and accented characters

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.