The following figure shows an example of sorting a source table's columns at the source, and then extracting and importing them.

Figure 4-3 Example of sorting columns at the source, and then extracting and importing them

Explanation

• Sorting columns at the source
  To sort columns at the source, you use the extraction statement to specify the source table's column names in the order they are to appear (the re-sorted order).
  

The following figure shows an example of sorting a source table's columns at the target, and then importing them.

Figure 4-4 Example of sorting columns at the target, and then importing them

Explanation

• Sorting columns at the target
  To sort columns at the target, first use name clauses in the update information field definition to define the field names of the update information, and then use the load statement in the import table definition to specify these fields in the order they are to appear (the re-sorted order).
  

The following figure shows an example of selecting some of the source table's columns at the source, and then extracting and importing them.

Figure 4-5 Example of selecting some of the columns at the source, and then extracting and importing them

Explanation

• Selecting columns at the source
  To select some of the columns at the source and extract them, specify in the extraction statement the columns that are to be extracted.
  

The following figure shows an example of selecting some of the source table's columns at the target, and then importing them.

Figure 4-6 Example of selecting some of the columns at the target, and then importing them

Explanation

• Selecting columns at the target
  To select some of the columns at the target and import them, first use name clauses in the update information field definition to define the field names of the update information, and then use the load statement in the import table definition to specify only those fields that are to be imported.
  

The following figure shows an example of adding fixed-value columns to a source table at the target, and then importing them.

Figure 4-7 Example of adding fixed-value columns at the target, and then importing them

Explanation

• Field names of update information when adding a fixed-value column
  To add a fixed-value column, select a field name and specify it in the update information field definition. Following the specified field name, specify const and the fixed value that is to be set in the field. You must also specify this user-defined field name in the load statement in the import table definition.