Skip to Content

+BLANKPAD

Use this parameter to tell BMC AMI Unload to pad VARCHAR columns with blanks instead of low values.


Related topics

BMC-AMI-Unload-parameters-ULDPARMS-DD

BLANKPAD

UNLD-BLANKPAD 

BLANKPAD.png

The BLANKPAD command option overrides this parameter.

Warning

Important

You cannot use this parameter to not pad VARCHAR columns.

Operands

NO

(Default) Pads VARCHAR columns with low values instead of blanks

YES

Pads VARCHAR columns with blanks instead of low values

Information
Example
+BLANKPAD(YES)

BMC AMI Unload pads VARCHAR columns with blanks.

Warning

Important

For the rules that apply to parameter syntax, see Parameter syntax rules.


 

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

BMC AMI Unload for Db2 13.1