3.9.5 Batch Control Source Column

Mandatory.

Specify from 1 to 4 columns in this table (i.e. the table definition currently selected) that are to be accumulated into the "batch control table" identified by the 3.9.1 Batch Control Table Name.

At least one pair of columns (source and target) is required.

Rules

• All columns nominated must be defined in this table.

• All columns must be numeric.

Warnings

• The checking (and testing) of accumulated column precision is a user responsibility and is not performed by LANSA.

Tips & Techniques

• Note that while LANSA will check that all columns nominated exist in their respective tables, and are numeric, it will not check the sizes. Thus it is possible to accumulate a column with 4 decimal positions into a column with no decimal positions. All decimal precision would be lost and the accumulation would probably be meaningless. Likewise a column with 15 significant digits could be accumulated into a column with 1 significant digit. Again the accumulation would almost certainly be meaningless.

Also See

3.9.6 Batch Control Target Column