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

How to fetch a value from table using Binary value


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
MFUSER1

New User


Joined: 14 Sep 2006
Posts: 1

PostPosted: Thu Sep 14, 2006 10:00 am
Reply with quote

Hi,

Is there any function that converts binary value to actual value?

Thanks,
Venkat.
Back to top
View user's profile Send private message
vijayakumar.yellala

New User


Joined: 19 Apr 2006
Posts: 63
Location: Chennai

PostPosted: Thu Sep 14, 2006 10:26 am
Reply with quote

Hello,

U can move birany field to display field...., then you can use that field in the query na...

Am I right?

Vijay
Back to top
View user's profile Send private message
kgumraj

Active User


Joined: 01 May 2006
Posts: 151
Location: Hyderabad

PostPosted: Thu Sep 14, 2006 8:29 pm
Reply with quote

As of my knowlege, there is no inbuilt function that can convert Binary to dispaly fromat.

FYI: It is better to move the binary to a dispalyable format variable
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 Load new table with Old unload - DB2 DB2 6
No new posts Pulling a fixed number of records fro... DB2 2
No new posts Multiple table unload using INZUTILB DB2 2
No new posts Check data with Exception Table DB2 0
No new posts Dynamically pass table name to a sele... DB2 2
Search our Forums:

Back to Top