Online Documentation for SQL Manager for DB2

Setting BLOB options


BLOB options

 

In this group of options you can determine whether BLOB fields are not to be extracted, extracted as strings, or extracted into a separate file. If the latter is selected,

 

RadioButton Don't extract BLOB fields

In this case BLOB fields values are not exported; BLOB fields have NULL values in the the INSERT statements of the result script.

 

RadioButton Extract BLOB fields as strings (may corrupt your data)

INSERT statements of the result script contain BLOB fields values as strings.

 

RadioButton Extract BLOB fields into file

BLOB fields values are exported into the *.blo file. You need to specify the File name and the location of the file on your local machine using the Save as... btnSaveAs button. The result script contains SET BLOBFILE '...' operator and INSERT statements with references to the data stored in the *.blo file.

 

CheckBox Compress file

Check this option if you wish to compress the file containing BLOB data.

 

Compression

Define the desired compression level to be applied for the file: None, Fastest, Default, Best.

 

Extract Database - Setting BLOB options

 

 

Click the Next button to proceed to Selecting objects for structure extraction.