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
Loading a Word Document
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 376
- Joined: Sat Jan 07, 2012 12:25 pm
- Location: Piscataway
Loading a Word Document
Jerome
Data Integration Consultant at AWS
Connect With Me On LinkedIn
Life is really simple, but we insist on making it complicated.
Data Integration Consultant at AWS
Connect With Me On LinkedIn
Life is really simple, but we insist on making it complicated.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
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.