Hi All,
I have table having column with Hex values. How can I convert those Hex values to plain text using DataStage job? Which stage can help me in achieving the same?
Thanks,
Sanygup
How to convert columns of table having Hex values to text
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
I remember i have converted text to hex using basic trasformer stage,so there must be some conversion function to convert Hex to text.
This may help you.
Code: Select all
OCONV(to_tsfm_hex.ntfEventpayload,"MX0C")
Thanks
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Hello,
I would like to give little background of my actual problem.
I have table which is having blob datatype column having values from rich text editor having basic word pad type formatted text.
I have to migrate this data to another database for some requirement using datatstage 8.5. I have used longvarbinary datatype of datastage odbc connector for the blob column of that table. When I check the value I found out that there are actually hexa.
I would to translate that hexa values into plain text so that I cannot report the information.
I would like to give little background of my actual problem.
I have table which is having blob datatype column having values from rich text editor having basic word pad type formatted text.
I have to migrate this data to another database for some requirement using datatstage 8.5. I have used longvarbinary datatype of datastage odbc connector for the blob column of that table. When I check the value I found out that there are actually hexa.
I would to translate that hexa values into plain text so that I cannot report the information.
Aspirant
That tells me that the values are stored in binary form and that your hexadecimal isn't the data contents but a representation thereof. This means that your text values don't need to be converted - but you need to get them out of the binary field and into a text field. I believe that there is a "RawToString()" function in PX, but I haven't used it.sanygup wrote:..I have used longvarbinary datatype of datastage odbc connector for the blob column of that table. When I check the value I found out that there are actually hexa...