× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Buck,

Thanks for your help/Guidance! Finally I was able to make it work with
combination of CCSID at job and file level.

DEN/SWE Data was saved in CCSID --> 37 in SL600O file.. after doing
following steps I made it work.. I will try more to see if I can make it
simpler...after following these steps data looks good in notepad..

CHGJOB CCSID(37)
CRTPF FILE(QTEMP/SL600OB) RCDLEN(500)
CPYTOIMPF FROMFILE(SWEDTA/SL600O) +
TOFILE(QTEMP/SL600OB) MBROPT(*REPLACE) +
TOCCSID(278) STRDLM(*NONE) /* 4770 */
CPYTOSTMF +
FROMMBR('QSYS.LIB/QTEMP.LIB/SL600OB.FILE/SL+
600OB.MBR') TOSTMF('SWE/SL600O.CSV') +
STMFOPT(*REPLACE) STMFCODPAG(*PCASCII)


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

When I run CPYTOIMPF on DANISH File I see following in text file ..

"MÅGEVEJ 44 "
"M$GEVEJ 44 "

On Wed, Nov 2, 2016 at 3:37 PM, Mohammad Tanveer <surgum@xxxxxxxxx> wrote:

ok here it is... my data is in a table with fields defined with CCSID 37

My JOB CCSID = 37

This is my test table: DANISH2 CCSID 278

Data Field Buffer Buffer Field Column

Field Type Length Length Position Usage Heading

CHAR_00001 CHAR 30 30 1 Both
CHAR_COLUMN
Alternative name . . . . . . . . . . . . :

CHAR_COLUMN

Allows the null value

Coded Character Set Identifier . . . . . : 278



Inserted one record hard coded value:
insert into danish2 values('MÅGEVEJ 44')

CHAR_COLUMN HEX ( CHAR_COLUMN )

MÅGEVEJ 44 D45BC7C5E5C5D140F4F4404040404
0404040404040404040404040404040

When I copy this DANISH2 file to IFS using the CPYTOIMPF all looks good

... Problem starts when... I copy data from following a file.. into
DANISH2.. This file sl600o has data in CCSID(37) format.
insert into Danish2
SELECT substr(add1,1,30) FROM sl600o WHERE
add1 like '%M$G%E%44%'


Now when I look at my DANISH table I have two records both are showing
different HEX.

CHAR_COLUMN HEX ( CHAR_COLUMN )

MÅGEVEJ 44 D45BC7C5E5C5D140F4F4404040404
0404040404040404040404040404040
M$GEVEJ 44 D467C7C5E5C5D140F4F4404040404
0404040404040404040404040404040

If I switch my job CCSID to 1134 and check DANISH2 table I see following..
CHAR_COLUMN HEX ( CHAR_COLUMN )

M$GEVEJ 44 D45BC7C5E5C5D140F4F4404040404
0404040404040404040404040404040
MÅGEVEJ 44 D467C7C5E5C5D140F4F4404040404
0404040404040404040404040404040



On Wed, Nov 2, 2016 at 1:09 PM, Buck Calabro <kc2hiz@xxxxxxxxx> wrote:

On 11/2/2016 3:19 PM, Mohammad Tanveer wrote:
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

Stored how?
DSPFFD and tell us what the CCSID of the column is.

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

Entered how?
By a TN5250 job last year with a CCSID of 65535?
By DBU just now with a job CCSID of 65535?
By DBU just now with a job CCSID of 278? 37?

I'm trying to understand the situation you face there, but I don't have
enough information yet to re-create the problem here. I gave an example
of your data and your CCSIDs and it works, so either your people are
doing something different or there's a PTF you need that I have. I'm on
TR4 (WRKPTFGRP, SF99717).

For one more added data point, here is DSPPFM DANISH

KÆRBØLVEJ 52
D9DC8DECD4FF444444444444444444
2E9203551052000000000000000000

M$GEVEJ 44
D5CCECD4FF44444444444444444444
4B7555104400000000000000000000


Here is DBU DANISH

KÆRBØLVEJ 52
D9DC8DECD4FF444444444444444444
2E9203551052000000000000000000
MÅGEVEJ 44
D6CCECD4FF44444444444444444444
477555104400000000000000000000


Here is SELECT HEX(CHAR_COLUMN) FROM DANISH

D29ED9C280D3E5C5D140F5F2404040404040404040404040404040404040
D45BC7C5E5C5D140F4F44040404040404040404040404040404040404040

All on a green screen with job CCSID(37). What does your system show?

One more thing. CCSID 278 has assigned 'A-ring' to x'5B'
ftp://ftp.software.ibm.com/software/globalization/gcoc/attac
hments/CP00278.pdf
So DSPPFM is correct to show me x'5B' as the raw data.

I found that PDF from here:
https://www-01.ibm.com/software/globalization/cp/cp_cpgid.html


--
--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.





As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.