How can I do so? Thanks a lot

Hi,
what is your database type and version and what is your operating system name and version?
Grofaty

Thank you for your reply.

DB is DB2 version 7
OS is Window XP

create a table with column type blob (eg col1 char(1), col2 blob xxM
create input data file eg test.data with record :
xxx,c:\tmp\filename <<--- the filename of object bmp...
import from test.data of del modified by lobsinfile insert into tablename
this will import the col1 with data and col2 with files

Thank you very much.
Let me try it.

I know this question may sound stupid.
We can save the documents or jpg files as blob . But can we retrieve and see this jpgs through some db client and actually see them as jpgs and not as some encrypted data?

Hi,

May I know whether we can store the BLob(e.g bmp files) data type to DB2 UDB 7.1 (not an Enterprise Edition) without installing any other tools???


Thanks,
cool

Yes.I am also interested in this question.
How to retrieve those jpg files from DB2 to see as normal Jpg files???

Thanks,

yes in V7 this was also available
to view actually these pictures or any other object usually :
- or use a tool that can match a column with a specific program to open this blob : like qmf is doing. whenever this column is clicked, a program will be launched to handle this object.
- there are also extenders in db2 available that handle this in similar way

Thank you very much for your reply.
But I still wonder to know which extenders in DB2 can do so.
Thanks a lot

have a look at this
http://www-1.ibm.com/support/docview...=utf-8&lang=en

It sounds great!!!
But my version is 7, can I still use it?
Thanks.

yes, these extenders existed already before V7

Hi Guy Przytula,

May I know qmf is a tool or command?
Is there any other way to store the bmp/jpg files without using extender or tool???
I mean : is there any command for it???

Thanks,

QMF (query management facility) for windows/mainframe is a software from IBM
it allows users to create/share query-reports-procedures

yes : import can do for insert/update of new/replace files
it can also be done with applications like java : see
http://www-128.ibm.com/developerwork...310bhogal.html