IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

How to convert character from Unicode to Binary?


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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

Moderator Emeritus


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

PostPosted: Tue Apr 22, 2008 10:45 am
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
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

Moderator Emeritus


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

PostPosted: Tue Apr 22, 2008 11:19 am
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Need to convert date format DFSORT/ICETOOL 20
No new posts Keep leading zero(s) after convert fl... SYNCSORT 7
No new posts Convert single row multi cols to sing... DFSORT/ICETOOL 6
No new posts convert file from VB to FB and use tr... DFSORT/ICETOOL 8
No new posts Convert HEX to Numeric DB2 3
Search our Forums:

Back to Top