View previous topic :: View next topic
|
Author |
Message |
Sandeep D. Patil
New User
Joined: 29 Jun 2008 Posts: 23 Location: mumbai
|
|
|
|
Some of the special characters are changing their values randomly every time they are updated or inserted in table(DB2)
Values are as specified below:-
[ ] ! | ^
Can anyone help us to solve above issue? |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
Random is not a word that I would apply.
I would check out your code table values. You are inputing code table 1, and then writing to db2 tables with code table <>1. |
|
Back to top |
|
|
Sandeep D. Patil
New User
Joined: 29 Jun 2008 Posts: 23 Location: mumbai
|
|
|
|
I am using working storatge variable to insert value into Table.
Eg.
I/P = ] ! | ^
When I insert this value in table it changes to | ] ! ¢
What might be the reason for this and how could I solve? |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Suggest you look at the values in the program in hex before the insert and then look at the inserted values (from the table) in hex.
As DBZ mentioned, this is not random.
You may have a code page inconsistency or you may have a difference in your mainframe and pc/3270-emulator character set. For example, your example includes a cent-sign (¢). That character is not on my keyboard so to include it here, i used copy/paste. If my memory has engaged this morning, the cent-sign was a Shift-6 on other keyboards, but on this one Shift-6 is the ^. |
|
Back to top |
|
|
|