Results 1 to 3 of 3
  1. #1
    Join Date
    May 2011
    Posts
    1

    Unanswered: Import PDF into DB2 BLOB column

    All,

    Is there any way to load an PDF file into an DB2 table with BLOB column? We tried with SQL 2000/2005 (DTS,SSIS), but when we could not extract the exact pdf from DB2 (maybe due to ASCII to EBCDIC conversion while loading from sql to db2). Any help is welcome.

    Thanks

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by balasach82 View Post
    maybe due to ASCII to EBCDIC conversion while loading from sql to db2
    There won't be any conversion if it's a BLOB column; something must be wrong with your loading process.

  3. #3
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by n_i View Post
    There won't be any conversion if it's a BLOB column; something must be wrong with your loading process.
    I think you mean "there shouldn't be any conversion." That is because if the file was transfered from a PC to the database server (I assume z/OS or iSeries, since those are EBCDIC) then the file should have been transfered as a binary file (if it was transfered correctly).
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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