It is known that an XML reader can be used to process XML but ....
Can DataStage Process Blob file to get information from the blob and put it into a table ....
Explanation of the requirement..
I have Table A, where in one of the column XML is stored as BLOB.. I have to retrieve this XML from the BlOB and get all the information present there and put into a Fact Table..
Can DataStage process BLOB
Moderators: chulett, rschirm, roy
Can DataStage process BLOB
Last edited by Smeitei on Tue Jan 23, 2007 10:41 pm, edited 1 time in total.
What kind of 'processing' did you have in mind? Not sure how much information you can get from a BLOB* but you could probably load it like any other LOB. DataStage really isn't the tool for that, however.
* Other than what planet it came from, of course, and why it was here.
* Other than what planet it came from, of course, and why it was here.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Please read this post. In case you find a better approach please don't forget to post it. :D
It took me fifteen years to discover I had no talent for ETL, but I couldn't give it up because by that time I was too famous.