Archives of the TeradataForum
Message Posted: Wed, 14 Dec 2005 @ 19:16:26 GMT
has anyone converted a hex value into a varbyte ?
We are trying to load data into a column which is defined as varbyte(64000).
The following works:
insert into table1 /*** table1 contains 1 column define as varbyte(64000) ***/ select 'abc'XBV;
However if I have the value 'abc' stored in a character column, I haven't found a way to insert this value into a varbyte column using an insert/select.
Also, we would like to convert a character column into an hex value and then to varbyte like:
select char2hexint('test'); /** we would like to insert the result into a varbyte column **/
The result from char2hexint('test') is '0074006500730074'
We are able to say:
insert into table1 select '0074006500730074'XBV;
However, we would like to do:
insert into table1 select char2hexint('test'); /** with some sort of conversion ***/
Any idea ???
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|