Load is a fairly simple utility to manage, right? I suppose it is if your input data is correct and you don’t allow discards, then it either works or fails. But what if you don’t have control of the input data and you must deal with the occasional discarded record, then there might be a few things to be concerned about.
- Did any records get discarded?
- Did more records get discarded than my limit?
- Did my upstream processing provide no records to load?
All these conditions provide a warning (RC=4) or an error (RC=8). But what if you want your own standard for return codes to alert you to these conditions using numbers other than 4 and 8.
Load return code control using installation parameters or keywords
BMC AMI Utilities have parameters called +parms. These are configured to set default values and they can be overridden in individual utility jobs. For many Load +parms there is an equivalent Load statement keyword that will override the +parm, whether that +parm is set by the system configuration or specified in the job.
This table shows the +parm related to the bullet points above, the keyword override for each, the default value, and its purpose.
Return code to warn you that a discard occurred. Specify a value between 0 and 7.
Return code to let you know the error was due to exceeding the allowable discards specified with the DISCARDS keyword. Specify a value between 8 and 15.
Return code to warn you that there were no rows to load. Specify a value between 0 and 7.
Load will always finish with the greatest return code encountered. Having discards is a warning, unless you set a limit, any error can override the return code to a greater value.
Develop shop standards for these return codes and set them in the utility configuration. Then individual utility jobs will follow these standards without having to specify anything. However, the keywords and +parms are there if the need arises to deviate from the standards.
Please refer to the Load manual for restrictions and incompatibilities.
Note: These parameters and keywords were added with PTF BQU1353 in July 2018.