How can I upload a BLOB/CLOB into a DB2 UDB Column?

[okonita]

Hi all,
I have a table define as: col1 int
col2 BLOB
col3 TIMESTAMP
I have several JPEG,GIF, etc photos that I want loaded into this table. I am searching for a shareware tool or sample code that I can use to load the BLOB data. Can anyone recommend a tool or share a free and straight forward SQL code that can do binary large object load.

Iam working with UDB 8.2 fixpak 14 and soon to go UDBv9.5.

Any assistance in this problem will be highly appreciated.

Thanks

[sakumar9]

You can refer to these samples:
SQLLIB/samples/c/dtlob.sqc
SQLLIB/samples/cli/dtlob.c
SQLLIB/samples/java/jdbc/dtlob.java

depending on the language that you are using. These samples demonstrates how we can upload BLOB/CLOB into any Db2 column.

Please let me know if the sample was useful to you or you need some more information.

Thanks and Regards
----Sanjay

[okonita]

You can refer to these samples:
SQLLIB/samples/c/dtlob.sqc
SQLLIB/samples/cli/dtlob.c
SQLLIB/samples/java/jdbc/dtlob.java

depending on the language that you are using. These samples demonstrates how we can upload BLOB/CLOB into any Db2 column.

Please let me know if the sample was useful to you or you need some more information.

Thanks and Regards
----Sanjay

Hello Sanjay,
Thanks for pointing out the sample files. I need further assistance. What do I need to be able to used the sample for my purpose. I have a DB2 UDBv8.2 and v9.1 on both Linux and Windows. I am more comfortable using windows and the Control Center or the Command line interface (CLI). So, what the steps that I need to take to (a) prepare the sample programs (b) prepare the JPEGS and other .GIF files that I want to upload and (c) what are the execution command to make this all work? As much detail as you can will be very much appreciated.

Thanks

[sakumar9]

Hi Okonita,

Actually these samples can be executed on command line. (both windows and linux).

This sample first SELECT the blob(images) from sample database and then inserts these image files as blob into the database.

I would suggest you to try out these samples (whichever language you are comfortable with).,
All you need is a c compiler, and sample database (use "db2sampl" command to create the sample database. Let me know if you have any issues in executing the samples.

I would suggest you to refer to the README that is present in the same directory. This README has clear instructions for executing the samples.


Gud Luck....

Regards
--- Sanjay

[okonita]

Hi Okonita,

Actually these samples can be executed on command line. (both windows and linux).

This sample first SELECT the blob(images) from sample database and then inserts these image files as blob into the database.

I would suggest you to try out these samples (whichever language you are comfortable with).,
All you need is a c compiler, and sample database (use "db2sampl" command to create the sample database. Let me know if you have any issues in executing the samples.

I would suggest you to refer to the README that is present in the same directory. This README has clear instructions for executing the samples.


Gud Luck....

Regards
--- Sanjay

Okay, Sanjay, thanks again and I will try my hand at it as soon as I finish an installation...

[okonita]

Okay, Sanjay, thanks again and I will try my hand at it as soon as I finish an installation...

I forgot to ask one thing: Where can I get a C compiler? And is it self-explanatory to use quickly or do I have to invest a lot of time to learn how to use it?


Thanks

[sakumar9]

Hi,

You can download any C compiler (search in google). You can also use microsoft C++ compiler. Once you install the compiler, you simply need to know what is the comnpiler command. For example: for microsoft compiler, the command is "cl". This is the only command that we will use.

Using compiler is very simple. Once you get the compliler installed, I'll tell you how you can use "bldapp" utility to compile all of your programs with a single command.

Regards
-- Sanjay