*adddata* |
Specifies a name for the column that is to store the sequence numbers generated by the sequence generator.
Specifies the identifier of the sequence generator from which sequence numbers are to be acquired.
If the authorization identifier is omitted, the user executing pdload (authorization identifier specified in the -u option or the PDUSER environment variable) is assumed.
The add data statement cannot be specified on the first line of the column structure information file to load only the sequence numbers generated by the sequence generator. To store only the sequence numbers in the table, you must prepare the required rows of data and then perform data loading with replace specified in the sequence operand. The example below stores only the sequence numbers in the table.
create table TABLE_C (
col01 integer
);
col01,sequence=(USER01.SEQ_C01),replace=force
If you use pdparaload or if you load data in units of RDAREAs, do not specify this operand for partitioning key columns. If you do specify this operand in such a case, a sequence number obtained from the sequence generator will be used as the partitioning key value. As a result, data might not be stored because the corresponding partitioning key value will no longer be subject to storage in the specified RDAREA.