Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

PB 10.2.1 -- DB2 MVS EBCDIC mapping

Status
Not open for further replies.

mmicheo

Programmer
Apr 5, 2006
4
US
We are migrating to PB 10.2.1 from PB 6.5. We use DB2 for our data. One of our windows is presented to the users where they enter clinical information from members and then we save this info into a column defined as VARCHAR in DB2. Before saving, we formated the text so next time when they open the "note", the text is formated and it has ~r and ~n to look good on the screen. I noticed that this is not happening in PB 10.2.1, I thought that PB 10 does not recognize ~r~n and I went to the mainframe and look at how db2 was storing the field and I discover that in a note created in PB 6.5 the HEX text on the field contains "25" for the ~n and in for a note created in PB 10 it displays "15". What this is doing to me is that when we retrieve the data to show to the user it is not showing with the right format. Does anyone know why is this happening?

Thank you.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top