Default language.

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 BMC AMI Load for Db2 13.1.

+PAD

+PAD tells 

BMC AMI Load

, when you specify FORMAT(UNLOAD), whether the VARCHAR input values are padded, it only applied to FORMAT UNLOAD.

NGT_Load_PAD.png

Important

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

Warning

Ensure that the +PAD option correctly corresponds to the input data. Otherwise, BMC AMI Load loads bad data and Db2 might abend.

YES

(default) YES tells BMC AMI Load that the VARCHAR input values are fully padded.

Important

The length that precedes the data in the VARCHAR field does not include the padding characters.

NO

NO tells BMC AMI Load that the VARCHAR input values are not padded.

Example

If the loading of a column IDNUM is defined as VARCHAR(6), the parameter +PAD(YES) forces BMC AMI Load to load the IDNUM column with trailing blanks, as in the following example. (In this example, each ^ signifies a blank space.)

IDNUM
-----
ABC139
EK78^^
R29^^^

The parameter +PAD(NO) loads the IDNUM column without trailing blanks, as in the following example:

IDNUM
-----
ABC139
EK78
R29

Related topic

BMC-AMI-Load-parameters-LODPARMS-DD

 

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