Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
How to convert character from Unicode to Binary?

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

New User


Joined: 22 Jan 2008
Posts: 53
Location: china

PostPosted: Tue Apr 22, 2008 9:51 am    Post subject: How to convert character from Unicode to Binary?
Reply with quote

how i can convert unicode to binary? because i have a project needs to do this? any idea?
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Apr 22, 2008 10:45 am    Post subject:
Reply with quote

Hello,

It may help if you post a few examples of what you "have" and what you want as output from the conversion.
Back to top
View user's profile Send private message
Joe_Song
Currently Banned

New User


Joined: 22 Jan 2008
Posts: 53
Location: china

PostPosted: Tue Apr 22, 2008 11:04 am    Post subject:
Reply with quote

In fact the data in dataset is display by hex as below:
2222222222222222222222222222222222222222222222222222222222222
0000000000000000000000000000000000000000000000000000000000000
You can see all show '20'x, but in fact there is some value in it, but i can't see them even use hex. the data is stored in table using ibm-950 code page. when i extract to dataset, it shows all '20'x, i think maybe it is zipcode , but not understand what happened, anyone can tell me?
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Apr 22, 2008 11:19 am    Post subject:
Reply with quote

Hello,

If all of the data currently in the file is x'20', it sounds like the file transfer was made in binary and the content was all ascii spaces.
Back to top
View user's profile Send private message
Joe_Song
Currently Banned

New User


Joined: 22 Jan 2008
Posts: 53
Location: china

PostPosted: Tue Apr 22, 2008 11:35 am    Post subject:
Reply with quote

but where is the real value? because when i select the field in brio, it shows some value beween the spaces, so why i can't see the value in the dataset? just see all the 20?
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 Table(Unicode(Graphic) table) loading... muralikrishnan_new DB2 0 Thu Oct 05, 2017 5:10 pm
No new posts Binary to display characters Roy Ware SYNCSORT 3 Tue Sep 19, 2017 8:46 pm
No new posts Convert rows and column into JSON for... Dinesh Manivannan DB2 2 Sun Sep 03, 2017 6:50 pm
No new posts Extra character appears in file when ... Balu5491 All Other Mainframe Topics 1 Wed Jul 26, 2017 2:39 pm
No new posts Convert CLIST to REXX cvnlynn CLIST & REXX 12 Tue Jun 27, 2017 2:06 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us