HP 3000 Manuals

ALLBASE/SQL COBOL Application Programming Guide

Changing a LONG Column with an UPDATE [WHERE CURRENT] Command 

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 ALLBASE/SQL Reference Manual .

In the following example, the LONG column I/O string is contained in host
variable PartPictureIO.

     UPDATE PartsTable
        SET PartPicture = :PartPictureIO
      WHERE PartName = 'saw'

MPE/iX 5.0 Documentation