DSXchange

Hi,

I just got this unusual requirement from our client to upload a Microsoft Word file into a DB2 Database as an object using DataStage. I'm not sure where to start. I'm not even sure if I should be accepting a requirement such as this. What should be the datatype of the DB2 column storing this object? what source should I use? Kindly help

I'd start by asking the client what the data type of the target column should be.

They will probably go with BLOB.

Then you respond with the DataStage error message "unsupported data type" and advise them to use some other mechanism.

DB2 has BLOB-loading capabilities from external files.