Unloading a table with LOB columns
Considerations when unloading LOB columns
Remember the following considerations when unloading LOB columns:
- For UNLOAD with DIRECT YES, if you select LOB columns, either implicitly or explicitly, then you must code SPANNED YES.
- For UNLOAD with DIRECT NO, if you select LOB columns they are trimmed to fit the maximum LRECL allowed. This is the same behavior as the DSNTIAUL sample program. SPANNED YES is not supported with DIRECT NO.
- For UNLD with MODE DIRECT, if you select LOB columns, either implicitly of explicitly, then SPANNED YES is optional. If you do not specify SPANNED YES, then only the column data from the base table is unloaded, but not the data in the LOB AUX table spaces.
- For UNLD with MODE DB2SQL, if you select LOB columns, they are trimmed to fit the maximum LRECL allowed. This is the same behavior as the behavior of the DSNTIAUL sample program. SPANNED YES is not supported with MODE DB2SQL.
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*