DSXchange

Hi,

I have a job that read a sequential file and i set Reject Mode = Output, the records are writing with varBinary datatype in the reject file, when i try to read the data has this format (in the file from UNIX):

0092251001431037000004310370000000111

in the view window:

{0 0 9 2 2 5 1 0 0 1 4 3 1 0 3 7 0 0 0 0 0 4 3 1 0 3 7 0 0 0 0 0 0 0 1 1 1

i want to insert this record in a table directly, but the oracle dont recognize this datatype, so, i try to use DataStage to convert to VarChar, dont work ...

is there any way to make this ????

HOW are you trying to use DataStage to convert it to VarChar, and what would you expect to get from this particular string if you did? (And do you have NLS enabled?)