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

Related topics

INTO-TABLE-options

BMC-AMI-Utilities-SQL-language

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.

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.

 

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