Archives of the TeradataForum

Message Posted: Wed, 14 Dec 2005 @ 19:16:26 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi,

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 ???

Thx, Arun

	<Prev	Next>		<<First	<Prev	Next>	Last>>