Image file to BLOB field in Oracle
Moderators: chulett, rschirm, roy
Image file to BLOB field in Oracle
Do anyone know that whether datastage can transfer Image from file to BLOB field in oracle?? Urgent Help Need!! SOS
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The answer is "not directly". DataStage is an ETL tool; what kind of transformation would you expect to perform on an image file or a BLOB?
Those who have had this requirement have tended to perform some kind of hex encoding, so that DataStage is able to move only printable characters. You may, even so, try to handle too long a text string using this method.
Etiquette Note
We don't do "urgent" or "ASAP" here. This is an all-volunteer site; folks post as and when they can. If you want urgent answers sign up with your support provider for premium service; you will thereby learn the true cost of urgent. More experienced posters than you get punished for "urgent" requests by being ignored for a period - at least by me.
Those who have had this requirement have tended to perform some kind of hex encoding, so that DataStage is able to move only printable characters. You may, even so, try to handle too long a text string using this method.
Etiquette Note
We don't do "urgent" or "ASAP" here. This is an all-volunteer site; folks post as and when they can. If you want urgent answers sign up with your support provider for premium service; you will thereby learn the true cost of urgent. More experienced posters than you get punished for "urgent" requests by being ignored for a period - at least by me.
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.
Actually not transform.. i just need to move the image in the file to oracle using datastage is there anywhere to do that?ray.wurlod wrote:The answer is "not directly". DataStage is an ETL tool; what kind of transformation would you expect to perform on an image file or a BLOB?
Those who have had this requirement have tended to perfo ...
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: