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
 
Need an info to store Hexadecimal value in DB2.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
SENTHIL MURUGAAN
Warnings : 1

New User


Joined: 12 Jan 2013
Posts: 31
Location: India

PostPosted: Wed Jun 13, 2018 12:18 pm    Post subject: Need an info to store Hexadecimal value in DB2.
Reply with quote

Is it possible to store Hexadecimal value in DB2?. If yes, then please share the procedure.

Advance thanks
Senthil
Back to top
View user's profile Send private message

expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8725
Location: Welsh Wales

PostPosted: Wed Jun 13, 2018 12:46 pm    Post subject:
Reply with quote

What research have YOU done to try to find an answer for yourself as this seems to be a fairly basic question.
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 2100
Location: UK

PostPosted: Wed Jun 13, 2018 3:53 pm    Post subject: Reply to: Need an info to store Hexadecimal value in DB2.
Reply with quote

Everything is stored as as 1 and 0 bits. How that is interpreted is up to you. Hex is just a short-hand way of interpreting those bits.
Back to top
View user's profile Send private message
jerryte

Active User


Joined: 29 Oct 2010
Posts: 194
Location: Toronto, ON, Canada

PostPosted: Fri Jun 29, 2018 10:22 pm    Post subject:
Reply with quote

If the column is defined as CHAR then you can store any bytes of data. You can use the HEX() function to convert from bytes into a hexadecimal string.
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 2033
Location: NY,USA

PostPosted: Sat Jun 30, 2018 4:50 am    Post subject:
Reply with quote

This is a beginners forum question
Perhaps why don’t you tell us the need to store it in hex?
Back to top
View user's profile Send private message
Auryn

New User


Joined: 11 Jan 2006
Posts: 60
Location: Lower Saxony (DE)

PostPosted: Thu Aug 16, 2018 12:49 pm    Post subject:
Reply with quote

... And if you'd like to insert or update, you can use x'F0F1F2'...
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 change the logon screen info o... sakthikumarT TSO/ISPF 5 Fri Dec 29, 2017 6:44 pm
No new posts Need info on EIBCPOSN value in IBM FA... subratarec CICS 11 Wed Jul 12, 2017 3:45 pm
No new posts Need info with DBRC recovery ashek15 IMS DB/DC 0 Mon Jan 23, 2017 6:43 am
No new posts IMS Database backup info ashek15 IMS DB/DC 14 Wed Nov 16, 2016 5:29 am
No new posts Convert Decimal to hexadecimal Steve Ironmonger DFSORT/ICETOOL 5 Fri May 27, 2016 4:19 pm

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