Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2011
    Posts
    3

    Unanswered: db2 blob column export to pdf

    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

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    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
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Aug 2011
    Posts
    3
    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

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    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
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  5. #5
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    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
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •