Import PDF into DB2 BLOB column

balasach82 · #1 (**permalink**) 05-15-11, 11:55

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

n_i · #2 (**permalink**) 05-15-11, 14:41

Quote:

Originally Posted by balasach82

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.

Marcus_A · #3 (**permalink**) 05-15-11, 16:43

Quote:

Originally Posted by n_i

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).

Internet Services

Web Development

Digital Marketing

Consumer Tech