3.9.3 Batch Control Key Column

Mandatory.

The columns or values that should be used to form the key that will be used to access the appropriate record in the table named as the "batch control table" identified by the 3.9.1 Batch Control Table Name.

If column names are used, then they must be defined in this table (i.e. the table definition that is currently selected and not the table named as the "batch control" table).

Key values are checked for type and length compatibility. The entire key list supplied is checked for compatibility with the actual key(s) of the "batch control table". The key list specified can be a full or partial key to the table.

Rules

Allowable values are:

• A column that is defined in the current table definition. You must not use a virtual column.

• An alphanumeric literal (in quotes) such as 'NSW', 'BALMAIN'

• A numeric literal such as 1, 14.23, -1.141217.

• A system variable name such as *BLANKS, *ZERO, *DATE or any other system variable defined at your installation.

Warnings

• A warning is issued if a partial key list is specified. The use of a partial key in this particular situation would be rare. If a warning message is issued carefully check and reconsider exactly what batch control logic has just been defined.

Tips & Techniques

• If you need to use a virtual column in the key, then code the batch control update logic into a trigger. Use of virtual columns may lead to unpredictable and/or unexpected results.

Also See

3.9.1 Batch Control Table Name