Storing a word document in a blob.

A DB2 question! I don't think I've seen one of those on here before.

I've got the books on the laptop here, gimme a few and I'll have a look. I haven't had the pleasure of dealing with blobs that much.
 
Well as usual the DB2 books are vague on the subject however dealing with blob data is a bit different to normal SQL. Normally you'd use JDBC or stored procedures to handle the inserts and selects and it looks very much like you have to retrieve the whole blob rather than being able to search within it.

There's a decent article with examples here
 
Cheers mate.

My main problem is searching the blob- it'll be a word document stored in it (with formatting, hence a CLOB can't be used :(). Loads of examples to do it with Oracle but not with DB2 (which all our apps use :/).

Still, could allow me to prove my worth as a Java programmer :)
 
You must log in or register to reply here.
Back
Top Bottom