You can add columns to extracted data and specify an initial value for each such column. When the extraction-system and import-system tables do not have the same number of columns, you can use this feature to add initial values to the extraction data for the columns that exist only in the target table (on the target system).

To add a column to extracted data, use the following SQL statement provided by HiRDB:

• Selection expression in the SELECT statement

Use the xtrep command to specify the name of the column name specification file that contains the SELECT statement that specifies the selection expression. The following is an example:

Example

Add the following column to the ORDER table on the source system and import it into the ORDER2 table on the target system. Figure 3-7 shows an example of adding a column.

• Order date (initial value: '960715')
  

  Figure 3-7 Adding a column (initial value)