Insert binary data into Teradata?
Posted: Mon Feb 02, 2009 1:38 am
Hi,
I have a column in teradata table defined as byte(2).
How can I insert Hex data (say for ex: 'D0C6') into this table in Datastage.
Do i have to use a Modify stage and if so, what is the conversion function needed to convert data into byte format.
P.S.: from command line this is how i insert data into teradata column
insert into <table_name> values ('D0C6'XB);
XB lets me insert byte data!!
I have a column in teradata table defined as byte(2).
How can I insert Hex data (say for ex: 'D0C6') into this table in Datastage.
Do i have to use a Modify stage and if so, what is the conversion function needed to convert data into byte format.
P.S.: from command line this is how i insert data into teradata column
insert into <table_name> values ('D0C6'XB);
XB lets me insert byte data!!