Insert binary data into Teradata?

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Aparna_A
Participant
Posts: 21
Joined: Wed Nov 09, 2005 11:16 pm

Insert binary data into Teradata?

Post by Aparna_A »

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!!
Aparna
Post Reply