INTO TABLE clauses allow you to extract multiple logical records from a single input record and recognize different record formats in the same file.
For delimited data, proper use of the
POSITION parameter is essential for achieving the expected results.
POSITION parameter is not used, multiple
INTO TABLE clauses process different parts of the same (delimited data) input record, allowing multiple tables to be loaded from one record. When the
POSITION parameter is used, multiple
INTO TABLE clauses can process the same record in different ways, allowing multiple formats to be recognized in one input file.