


LONG columns can be specified in a DATAUPDATE statement like any other column. For the input file, the same conventions apply that are valid for DATALOAD.
Example:
DATAUPDATE TABLE hotel
KEY hno 1
SET info 2
INFILE * COMPRESS
/ *
10;"'congress.lng'"
30;"'regency.lng'"
60;"'airport.lng'"
90;"'sunshine.lng'"
In this example, the option COMPRESS is used. This option has the effect that the values are separated from each other by a semicolon and character strings are enclosed in quotation marks. The double quotation marks enclosing the filename can be omitted.


