Re: CPYTOIMPF and accented characters -- MIDRANGE-L

It looks like when I entered the data as per your example it took it as
ASCII character code that is why it appeared correctly.

I copied the data from my database which stored the data as Danish
character set then translation is not happening correctly.. looks like my
problem still exists

You can see Record#1 was copied using the values from Danish CCSID 278 and
#2 was entered manually using the SQL

STRSQL(US 037 Mode)
RRN ( A ) CHAR_COLUMN
1 M$GEVEJ 44 (entered using den/swe character set)
2 MÅGEVEJ 44 (ASCII input)
3 KÆRBØLVEJ 52

STRSQL (SWE 1143 Mode)
RRN ( A ) CHAR_COLUMN
1 MÅGEVEJ 44
2 M$GEVEJ 44
3 KÆRBØLVEJ 52

On Wed, Nov 2, 2016 at 11:19 AM, Mohammad Tanveer <surgum@xxxxxxxxx> wrote:

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.