The figure below shows data loading to a table for which indexes are defined.
Figure 5-7 Loading data to a table with indexes defined
The following explains the options specified with pdload:
For the omitted options, the system assumes the following values:
The source statement specifies the input data file named /usr/inputfile.
The index statement specifies the index information file named /usr/idxfile.
This example specifies the input data file in the DAT format.
If the order of columns does not match between the input data file and the table, you can specify a column structure information file to define the correspondence of columns between input data and table.
A column structure information file can be used if the input data file is in DAT format, fixed-size data format, or pdrorg-output binary format (applicable only to non-FIX tables).
The following shows an example: