DB2 Extract BLOB Data

by

Posted on by

To extract BLOB data from DB2, first, you need download and install DB2LobEditor.

Run DB2LobEditor.

After click ‘Tools->Export LOB’, LOB export form is displayed, you can extract LOB data from a table:

Extract BLOB data from DB2 - Extract lob from table

or a query:

Extract BLOB data from DB2 - Extract lob from query

DB2LobEditor is a database tool that helps DBA and Database Programmer edit DB2 LOB (BLOB, CLOB) data directly.