The following figure shows an example of acquiring information such as the import dates and times as well as the update information in chronological order.

Figure 4-14 Example of acquiring information such as the import dates and times as well as the update information in chronological order

Explanation

• Acquiring table data in chronological order
  To acquire data in chronological order, specify timestamp before the table name in the to clause of the import table definition. To acquire information other than update information, you must create in advance columns for receiving the information in the target table.
  
• Information other than update information
  To acquire information other than update information, such as the import dates, times, and types, you must select and specify field names in name clauses in the update information field definition. Following each field name, specify const and the literal indicating the information that is to be acquired.
  You must specify the names of all fields to be subject to acquisition in the load statement of the import table definition.