Hi all,
Am working on a job that extracts data from Sybase tables and loads to Oracle tables.
There is a column in Sybase that has user inputted values which contains some non printable characters. Initially I got the error
No default type conversion from type "raw[max=100]" to type "string[max=100]".
So I read the column as VarBinary and used the RawtoString function to convert it to a VARCHAR to load to Oracle
This loads non printable characters (?,^@,New line) in the oracle tables and thats not consistant with the Sybase data,
Is there a way to remove those characters using any of the NLS settings or by any other means, the business doesnt want the data extratced to a file and have some unix command (tr or sed) run on them
Non Printable characters loaded to Oracle from Sybase
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I think you need to investigate the Sybase data a bit more thoroughly. DataStage can't "invent" data values. For example, are there any newline characters in these raw data? You could check using a Transformer stage.
Incidentally, ^@ is a representation of ASCII NUL, often used as a terminator of a string (for example in C programming), also sometimes represented as 0x00 or \0. In DataStage you can represent it as Char(0).
Incidentally, ^@ is a representation of ASCII NUL, often used as a terminator of a string (for example in C programming), also sometimes represented as 0x00 or \0. In DataStage you can represent it as Char(0).
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: