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.

IFZEROROWS


The IFZEROROWS option allows you to specify a user-defined return code that the BMC AMI Load product uses. The product uses the code upon successful completion of the load job when it does not load any rows.

NGT_Load_IFZEROROWS.png

You can specify any integer from 0 through 7.

BMC AMI Load always ends with the highest return code assigned during the load job. For information, see Job-completion-and-return-codes

Restrictions

This option is not compatible with DSNUTILB syntax. If DSNUTILB processes this option, an error might occur. 

Specifying the default

You can specify the default for the IFZEROROWS command option in your installation options module by using the +ZEROROWRC installation option. BMC AMI Load was shipped with a default value of 0 for this option. The command option overrides the default that is in the installation options module.

This keyword also overrides the +ZEROROWRC parameter specified in the LODPARMS DD.

 

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