Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see UNLOAD PLUS for DB2 13.1.

FILL

The FILL option tells UNLOAD PLUS whether to fill numeric external fields with zeros when converting numeric columns to their external representations.

FILL.png

This capability supports applications such as COBOL that require leading zeros to edit and check unloaded data properly. You can use this global option or the FILL option on your field specification to override the FILL installation option default. For more information, see the individual data type.

Restriction

This option does not apply to conversions that involve the DECFLOAT data type.

Specifying the default

You can specify the default for the FILL command option in your installation options module by using the FILL installation option. UNLOAD PLUS was shipped with a default value of NO for this option. The command option overrides the default that is in the installation options module.

NO

Specify NO if you want to remove all leading zeros when converting numeric data types to their external representations.

YES

When you specify FILL YES, UNLOAD PLUS externalizes all leading zeros when converting numeric data types to their external representations. The first character in the external representation of the number is either a minus sign (–) or a plus sign (+).

Related topic

Basic-processing-options

 

 

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*