Archives of the TeradataForum
Message Posted: Tue, 27 Nov 2012 @ 12:25:06 GMT
We are receiving a 16-byte hexadecimal Global Unique Identifier (GUID), represented as a 32-character string (in an ASCII load file) from our SAP system.
In other words, the incoming string looks something like this:
We would like to load this value to a Byte(16) column using Multiload, but need to find a way to do the conversion to Byte(16) on-the- fly.
With a literal string, this is easily achieved as follows:
sel '4F0696EEB99C00BEE10080000AB6D16E'xb ; Result: 4F-06-96-EE-B9-9C-00-BE-E1-00-80-00-0A-B6-D1-6E sel type('4F0696EEB99C00BEE10080000AB6D16E'xb) ; Result: BYTE(16)
However, how does one do this conversion when you are referring to a column instead of a literal string?
In other words, is there an equivalent to the "xb" used on literals, which can be used with column or variable names?
Or perhaps any other technique (besides writing a UDF) that can be used.
Any advice or solution would be much appreciated.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|