Archives of the TeradataForum
Message Posted: Wed, 04 Sep 2013 @ 22:03:15 GMT
| Subj: || || Re: Converting Byte filed to Hexadecimal |
| From: || || Geoffrey Rommel |
| ||In my plant I am trying to fetch data from DB2 and datatype defined is Bit datatype|| |
How exactly is this being done? Is this DB2 on z/OS or Linux? Are you using Informatica? DataStage? an ODBC connection? Extracting to a
| ||I am facing issue while converting?the byte?datatype to show hexadecimal value.|| |
The attached UDF, rawtohex, may do what you need.
There is no need to say this.
Admin Comment: The attachment can be found on the TeradataForum website: