Benefits of Using Multiple INTO TABLE Clauses

Multiple INTO TABLE clauses enable you to:

  • Load data into different tables

  • Extract multiple logical records from a single input record

  • Distinguish different input record formats

  • Distinguish different input row object subtypes

In the first case, it is common for the INTO TABLE clauses to refer to the same table. This section illustrates the different ways to use multiple INTO TABLE clauses and shows you how to use the POSITION parameter.

Note:

A key point when using multiple INTO TABLE clauses is that field scanning continues from where it left off when a new INTO TABLE clause is processed. The remainder of this section details important ways to make use of that behavior. It also describes alternative ways of using fixed field locations or the POSITION parameter.