(Contents)(Previous)(Next)

Updating LONG Columns with DATAUPDATE

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.


(Contents)(Previous)(Next)