In a multiple table load, you specify multiple
TABLE clauses. When you specify
POSITION(*) for the first column of the first table, the position is calculated relative to the beginning of the logical record. When you specify
POSITION(*) for the first column of subsequent tables, the position is calculated relative to the last column of the last table loaded.
Thus, when a subsequent
TABLE clause begins, the position is not set to the beginning of the logical record automatically. This allows multiple
TABLE clauses to process different parts of the same physical record. For an example, see "Extracting Multiple Logical Records".
A logical record might contain data for one of two tables, but not both. In this case, you would reset
POSITION. Instead of omitting the position specification or using
) for the first field in the
INTO TABLE clause, use