Syntax
<acc_column_spec> ::= <
key_column_spec> | <simple_column_spec>Use
Use this syntax rule in a
DATAUPDATE command to define whether the qualification columns are key columns or non-key columns of the target table.If you use key columns as qualification columns (
key_column_spec), each data record in the data stream updates that line in the target table that matches the specified key.DATAUPDATE TABLE customer
KEY cno 01-04
SET city 05-16
INFILE 'customer.data' FORMATTED
If you use non-key columns as qualification columns (
simple_column_spec), each data record in the source file updates each line in the target table that is identified with the value(s) of the qualification column(s).DATAUPDATE TABLE customer
city 1
SET zip 2
INFILE 'customer.data'