db2 blob column export to pdf

santosh.veerlapat · #1 (**permalink**) 08-10-11, 02:49

Hi

I am santosh, we have db2 database table which has blob data one of its columns. this table has around 55,000 rows .

what all we need is to extract blob from db2 and create pdf files out of it.
is there any tool provides this functionality.

Initially i though of using java , but later i realized it takes more time.

If anyone has any thoughts please share.

Thanks in advance
Santosh Kumar Veerlapati

przytula_guy · #2 (**permalink**) 08-10-11, 03:00

blob is binary
is the contence of this column a loaded pdf file ?
to export you can use export and modifyers : modified by lobsinfile..
EXPORT

santosh.veerlapat · #3 (**permalink**) 08-10-11, 03:28

yes exactly

the pdf file is stored in db column as blob.

but how i can retrieve all of these rows and save into individual files into pdfs

thanks
santosh kumar veerlapati

przytula_guy · #4 (**permalink**) 08-10-11, 03:48

as indicated before : have a look at export and modifyers
EXPORT
the only restriction is : you can not define the file-extension (pdf) only the name
you will have to rename the files

sathyaram_s · #5 (**permalink**) 08-10-11, 04:00

Code:

export to <export file name> of del  lobs to <lobdir> modified by lobsinsepfiles select  select <pri key columns>,<blobcol> from <tablename>

this will export the pdf files to a path specified as lobdir.
the names as guy says will be <something>.001.lob, <something>.002.lob etc.
the pk to blob mapping can be found in <export file name>, using which you can rename the blob files to pdf

hth

Internet Services

Web Development

Digital Marketing

Consumer Tech