Skip to Content

Default language.

Information
Limited support BMC 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.

WHEN and WHERE

Specify either WHEN or WHERE to tell BMC AMI Load when to accept an input record for processing.

WHEN.png

To specify a standard WHEN clause, use the following field selection options:

NGT_Load_field_selection.png

Alternatively, you can specify the general purpose WHERE clause instead of the standard WHEN clause. The WHERE clause references fields by name only and can use arithmetic or character expressions on named fields. 

You can perform arithmetic directly on named fields in the input record if the input is in UNLOAD format. If the input is in other formats, you need the S370 function to convert the data to useable numeric form.

Warning

Important

If you are using an existing LOADPLUS job, ensure that your WHEN clause meets BMC AMI Load criteria for a WHEN clause. If it does not meet these criteria, your job step terminates.

Related topics

INTO-TABLE-options

BMC-AMI-Utilities-SQL-language

 

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

BMC AMI Load for Db2 12.1