Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Dropping all Apostrophe's

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
sivasaras

New User


Joined: 29 Sep 2007
Posts: 90
Location: chenna/i-

PostPosted: Fri Nov 22, 2013 7:30 pm    Post subject: Dropping all Apostrophe's
Reply with quote

Hi,

My program is having both jave and maninfame.

in front end they are entering the valuse with apostrophe’s like

hai thé à test spécial

while storing it is showing as with ? marks in the screen, it is dropping all apostrophe's like below in the fron end java screen

hai th? a? test sp?cial

i am using a stored procedure.

plz guide me how to insert the same value in the db2 and display in the acreen correctly.
Back to top
View user's profile Send private message

GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Fri Nov 22, 2013 7:54 pm    Post subject:
Reply with quote

Talk to an experienced developer/system engineer at your site.
Multiple codepages/unicode-ebcdic-ascii is a bit much to explain to someone who has programs in "jave and maninfame" (sic)
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10256
Location: italy

PostPosted: Fri Nov 22, 2013 7:57 pm    Post subject: Reply to: Dropping all Apostrophe's
Reply with quote

in IT using the proper terminology is essential for good communication

Quote:
in front end they are entering the valuse with apostrophe’s like

hai thé à test spécial


those are not apostrophes they are accented vowels ,

most probably You have problems with the translate and codepages used
both in Your 3270 and DB2 environments

the best place to ask for help/work with is certainly Your support.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8057
Location: East Dubuque, Illinois, USA

PostPosted: Fri Nov 22, 2013 8:01 pm    Post subject:
Reply with quote

This is a code page issue -- the mainframe is storing the data using a code page that does not support the special characters being used in the front end. You need to identify which code page the front end uses, and ensure that DB2 stores your data using that code page.

Also, terminology is critial in IT where similar terms may mean very different things. The data does not have apostrophes (which are separate characters), the characters have diacritic marks; depending upon the language there are several different diacritic marks (tilde, circumflex, acute, grave for example) but they are not considered separate from the character.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts How to delimit data with '|' which ha... gch77 DFSORT/ICETOOL 5 Wed Aug 13, 2014 9:16 am
No new posts Dropping records based on zero sum - ... gcicchet JCL & VSAM 4 Wed Mar 14, 2012 9:43 am
No new posts Dropping Records by Date jr3011 DFSORT/ICETOOL 3 Mon Feb 27, 2012 8:18 pm
No new posts Apostrophe in EZT kiranbhargava18 CA Products 5 Tue Dec 15, 2009 9:33 am
No new posts Inserting an Apostrophe in DB2 table sgiri DB2 3 Thu Jun 04, 2009 4:43 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us