I need to read field type Raw from oracle database using ODBC stage to do look ups on that field and then load it back to oracle database. When i try to read data is read as varbinary and length of data is twice the length as viewed in database. When i try to load it back it is giving truncation error messages for eg
SQLSTATE=01004, DBMS.CODE=0
[DataStage][SQL Client]Data has been truncated
Data is size of Raw 16 but when i read from datastage ODBC stage it looks like 3032303030303134303030303034363344443033303030323030303030303938.
Whats the right equivalent of raw 16 in datasatge- is varbinary 16 correct
Please let me know whats the right way to handle oracle raw field in datastage.
Thanks in advance
Oracle Raw Field
Moderators: chulett, rschirm, roy