Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: TutorialThe HCL OneDB™ Guide to SQL: Tutorial shows how to use basic and advanced structured query language (SQL) to access and manipulate the data in your databases. It discusses the data manipulation language (DML) statements as well as triggers and stored procedure language (SPL) routines, which DML statements often use.
Modify data
Update rows
Update row types
Update rows that contain named row types

Update rows that contain named row types

To update a column that is defined on a named ROW type, you must specify all fields of the ROW type. For example, the following statement updates only the street and city fields of the address column in the employee table, but each field of the ROW type must contain a value (NULL values are allowed):

UPDATE employee
  SET address = ROW('103 California St', 
    San Francisco', address.state, address.zip)::address_t
  WHERE name = 'zawinul, joe';

In this example, the values of the state and zip fields are read from and then immediately reinserted into the row. Only the street and city fields of the address column are updated.

When you update the fields of a column that are defined on a named ROW type, you must use a ROW constructor and cast the row value to the appropriate named ROW type.