View previous topic :: View next topic
|
Author |
Message |
santhoshm
New User
Joined: 13 Jun 2007 Posts: 32 Location: chennai
|
|
|
|
Hi,
I have a field 'PREF_NAME' in a table defined CHAR(40). The table has data for 'PREF_NAME' and it has some junk characters also.
QMF Result:
Select PREF_NAME from TAB1 resulted below value:
Blaze Vran~ois
COBOL Result: the same query results when extracted into a file it has the below value:
Blaze Vran ois
Can someone explain what is causing the issue here. Even the values which we saw after HEX ON in file(COBOL) & QMF are different.
Thanks |
|
Back to top |
|
|
Akatsukami
Global Moderator
Joined: 03 Oct 2009 Posts: 1788 Location: Bloomington, IL
|
|
|
|
And what are, in fact, the values that you are getting, and the value actually in the table? |
|
Back to top |
|
|
santhoshm
New User
Joined: 13 Jun 2007 Posts: 32 Location: chennai
|
|
|
|
Hi attached has the details. First column has the data from table and the 2nd column has the data extracted from the file(generated in COBOL) |
|
Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8696 Location: Dubuque, Iowa, USA
|
|
|
|
Quote: |
it has some junk characters also. |
This is a wrong statement -- there is no such thing as "junk characters". There may be characters you don't recognize, and there may be characters you don't want to see, but they are still part of the collating sequence and hence are real characters, not "junk".
COBOL defaults to using code page 1140 -- what code page does your QMF default to? |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
You have "accented" characters, and neither codepage that you are using is able to display them as accented charactes.
For instance, they should both appear as "François", with a cedilla under the "c". You need a codepage which has all the characters you need for your accent/diacritic usage. |
|
Back to top |
|
|
santhoshm
New User
Joined: 13 Jun 2007 Posts: 32 Location: chennai
|
|
|
|
I saw in compiler listing related to CODE PAGE.
00007C 0474 DC X'0474' UNSIGNED BINARY CODE PAGE CCSID VALUE
I am not able to figure out what is there for QMF. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Suggest you ask the people who install / support QMF on your system. . . |
|
Back to top |
|
|
|