+PAD tells BMC AMI Load, when you specify FORMAT(UNLOAD), whether the VARCHAR input values are padded.
ErrorWarning
Ensure that the +PAD option correctly corresponds to the input data. Otherwise, BMC AMI Load loads bad data and Db2 might abend.
| (default) YES tells BMC AMI Load that the VARCHAR input values are fully padded. WarningImportant The length that precedes the data in the VARCHAR field does not include the padding characters. |
|---|
| NO tells BMC AMI Load that the VARCHAR input values are not padded. |
|---|
InformationExample
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:
