*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