Operate on a row-type column

The row variable stores the fields of the row type. The row variable, however, has no intrinsic connection with a database column. You must use an INSERT or UPDATE statement to explicitly save the contents of the variable into the row type column.

You can use the SELECT, UPDATE, INSERT, and DELETE statements to access a row-type column (named or unnamed), as follows:
  • The SELECT statement fetches all fields or a particular field from a row-type column.
  • The INSERT statement inserts a new row into a row-type column.
  • The UPDATE statement updates the entire row in a row-type column with new values.

    Use an UPDATE statement on a table or view name and specify the row name in the values clause.

  • The DELETE statement deletes from a table a row that contains a row-type column, thus deleting all field values from the row-type column.

For more information about how to use these statements with row-type columns, see the HCL OneDB™ Guide to SQL: Tutorial.