Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

Subj:   Varbyte Conversion
From:   Arun.Ballari


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>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020