By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,341 Members | 1,396 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,341 IT Pros & Developers. It's quick & easy.

DB2 Connect Character Conversion Issue

P: n/a
I am using DB2 Connect on HP-UX 11i to read data from an AS400 using
SQL. DB2 Connect is converting a vertical bar (¶) character to this:
™. Please see the example below. I have tried changing the user ID's
CCSID to 037 and this did not correct the problem. Any suggestions
would be greatly apprecated. Thanks.

Data as it appears on the 400:

150 KENNEDY DRIVE¶

Data when queried through DB2 Connect:

150 KENNEDY DRIVE™

One application developer offered this theory:
"That would be an erroneous translation. The vertical bar character
is a 7-bit ASCII character, code 124. It should not be translated
into a 16-bit character. It looks like there is an error in the
EDCIDIC to ASCII translation."

However, I am not sure how to stop DB2 Connect from converting this
incorrectly.
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Something must be wrong:

| is indeed ASCII x'7C'
The character you are showing is a ¶ (broken bar) which is X'A6' in
ASCII and X'00A6' in UTF-16
Perhaps you can do a select hex(column) from table ?
Scott wrote:
I am using DB2 Connect on HP-UX 11i to read data from an AS400 using
SQL. DB2 Connect is converting a vertical bar (¶) character to this:
™. Please see the example below. I have tried changing the user ID's
CCSID to 037 and this did not correct the problem. Any suggestions
would be greatly apprecated. Thanks.

Data as it appears on the 400:

150 KENNEDY DRIVE¶

Data when queried through DB2 Connect:

150 KENNEDY DRIVE™

One application developer offered this theory:
"That would be an erroneous translation. The vertical bar character
is a 7-bit ASCII character, code 124. It should not be translated
into a 16-bit character. It looks like there is an error in the
EDCIDIC to ASCII translation."

However, I am not sure how to stop DB2 Connect from converting this
incorrectly.


--
Anton Versteeg
IBM Certified DB2 Specialist
IBM Netherlands
Nov 12 '05 #2

P: n/a
Anton Versteeg wrote:
Something must be wrong:

| is indeed ASCII x'7C'
The character you are showing is a ¶ (broken bar) which is X'A6' in
ASCII and X'00A6' in UTF-16
Perhaps you can do a select hex(column) from table ?

Scott wrote:
I am using DB2 Connect on HP-UX 11i to read data from an AS400 using
SQL. DB2 Connect is converting a vertical bar (¶) character to this:
™. Please see the example below. I have tried changing the user ID's
CCSID to 037 and this did not correct the problem. Any suggestions
would be greatly apprecated. Thanks.

Data as it appears on the 400:

150 KENNEDY DRIVE¶

Data when queried through DB2 Connect:

150 KENNEDY DRIVE™

One application developer offered this theory:
"That would be an erroneous translation. The vertical bar character
is a 7-bit ASCII character, code 124. It should not be translated
into a 16-bit character. It looks like there is an error in the
EDCIDIC to ASCII translation."

However, I am not sure how to stop DB2 Connect from converting this
incorrectly.


If you submit a problem report, you could use the ddcstrc utility to get
a DRDA trace. This shows the datastream exchanged between DB2 Connect
and the AS/400. See Problem Determination in the DB2 Connect User's
Guide here (sorry for long URL):
http://www.ibm.com/cgi-bin/db2www/da...7c0frm3toc.htm

--
Karl Hanson
Nov 12 '05 #3

P: n/a
Anton is correct. There are two similiar characters in CCSID 37. One is
Vertical Bar x4F and the other one is Broken Veritical Bar x6A in CCSID 37.
The character you are using is x6A in CCSID 37. This character is not
defined in HP environment. In order to save the letter we mapped the broken
vertical bar to character '™' on HP.

Sherman

"Anton Versteeg" <an************@nnll.iibbmm.com> wrote in message
news:40**************@nnll.iibbmm.com...
Something must be wrong:

| is indeed ASCII x'7C'
The character you are showing is a ¶ (broken bar) which is X'A6' in
ASCII and X'00A6' in UTF-16
Perhaps you can do a select hex(column) from table ?
Scott wrote:
I am using DB2 Connect on HP-UX 11i to read data from an AS400 using
SQL. DB2 Connect is converting a vertical bar (¶) character to this:
™. Please see the example below. I have tried changing the user ID's
CCSID to 037 and this did not correct the problem. Any suggestions
would be greatly apprecated. Thanks.

Data as it appears on the 400:

150 KENNEDY DRIVE¶

Data when queried through DB2 Connect:

150 KENNEDY DRIVE™

One application developer offered this theory:
"That would be an erroneous translation. The vertical bar character
is a 7-bit ASCII character, code 124. It should not be translated
into a 16-bit character. It looks like there is an error in the
EDCIDIC to ASCII translation."

However, I am not sure how to stop DB2 Connect from converting this
incorrectly.


--
Anton Versteeg
IBM Certified DB2 Specialist
IBM Netherlands

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.