Can DataStage process BLOB

Smeitei · Post by **Smeitei** » Tue Jan 23, 2007 4:17 pm

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..

chulett · Post by **chulett** » Tue Jan 23, 2007 4:23 pm

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.

sud · Post by **sud** » Wed Jan 24, 2007 2:14 am

Please read this post. In case you find a better approach please don't forget to post it. :D

chulett · Post by **chulett** » Wed Jan 24, 2007 8:22 am

A search on BLOB returns 47 hits, not counting your post. Suggest you browse through those for inspiration.