Storing documents in db2

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Praveen_db2 - 05 Jul 2006 18:54 GMT

Hi all
db2 8.1.3 Windows.
I need to store some documents in db2 without using datalinks
manager.These can be MS word or PDF dcouments.Any suggestions how to
tackle this?

Regards
Praveen

Reply to this Message

Serge Rielau - 05 Jul 2006 19:02 GMT

> Hi all
> db2 8.1.3 Windows.
> I need to store some documents in db2 without using datalinks
> manager.These can be MS word or PDF dcouments.Any suggestions how to
> tackle this?

Use a BLOB.

Cheers
Serge

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ondemandbusiness/conf2006/

Reply to this Message

Praveen_db2 - 05 Jul 2006 19:37 GMT

Thanks Serge
After creating table with a BLOB field how shall I use the INSERT
statement for inserting the document.

Regards
Praveen

Reply to this Message

Gregor Kovač - 06 Jul 2006 06:56 GMT

> Thanks Serge
> After creating table with a BLOB field how shall I use the INSERT
> statement for inserting the document.
>
> Regards
> Praveen

You should use PreparedStatements (as they are called in Java).

Best regards,
Kovi

Signature

-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-

| Gregor Kovac | Gregor.Kovac@mikropis.si |

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

| In A World Without Fences Who Needs Gates? |
| Experience Linux. |

-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-

Reply to this Message

Praveen_db2 - 05 Jul 2006 20:42 GMT

After a lot of googling I am still not able to find a way for INSERTing the
BLOB values using SQL.DO I need to make procedures/udf's in external
languages like 'C'.In my application .NET is used as front end.Can these
BLOB manipulation activities be done using .NET also??

Praveen

Reply to this Message

Gert van der Kooij - 05 Jul 2006 21:07 GMT

In article
<4189570838e021d17df21acdbb08111a@localhost.talkaboutdatabases.com>,
pandey.praveen@gmail.com says...

> After a lot of googling I am still not able to find a way for INSERTing the
> BLOB values using SQL.DO I need to make procedures/udf's in external
> languages like 'C'.In my application .NET is used as front end.Can these
> BLOB manipulation activities be done using .NET also??
>
> Praveen

Check the samples supplied with DB2. I found some in
C:\Program Files\IBM\SQLLIB\samples\.NET\vb\DtLob.vb and
C:\Program Files\IBM\SQLLIB\samples\.NET\cs\DtLob.cs

Reply to this Message