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 ????
Working with VarBinary datatype
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 133
- Joined: Wed Mar 05, 2003 4:19 pm
- Location: Lima - Peru. Sudamerica
- Contact:
Working with VarBinary datatype
Saludos,
Miguel Seclén
Lima - Peru
Miguel Seclén
Lima - Peru
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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?)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.