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

Praveen_db2 wrote:
> 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

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

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

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

Regards
Praveen

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

In article
<4189570838e021d17df21acdbb08111a@localhost.talkab outdatabases.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

Praveen_db2 wrote:

> 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
--
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
| Gregor Kovac | Gregor.Kovac@mikropis.si |
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| In A World Without Fences Who Needs Gates? |
| Experience Linux. |
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-