Literal Row (IDS)

The syntax for a literal representation of the value of a named or unnamed ROW data type is described in the section Literal Row. The following examples show literal rows as expressions:

INSERT INTO employee VALUES 
   (ROW('103 Baker St', 'San Francisco', 
      'CA', 94500))

UPDATE rectangles
   SET rect = ROW(8, 3, 7, 20)
   WHERE area = 140

EXEC SQL update table(:a_row) 
   set x=0, y=0, length=10, width=20;

SELECT row_col FROM tab_b
   WHERE ROW(17, 'abc') IN (row_col)

For the syntax of expressions that evaluate to field values of a ROW data type, see ROW Constructors.