When you issue an UPDATE command on a LONG column, you have the
following options:
Change the stored data as well as the output device name and/or options.
Change the stored data only.
Change the output device name and/or options only.
Specify a LONG column I/O string (discussed earlier in this chapter)
following the SET clause, for each LONG column to be updated.
You must specify either the input device, the output device, or both.
Complete syntax with examples is found in the .
In the following example, the LONG column I/O string is contained
in host variable PartPictureIO.
UPDATE PartsTable
SET PartPicture = :PartPictureIO
WHERE PartName = 'saw'
|