Updating a table row

Update a table row on the database server by using Query By Example.

Note: Only rows with unique identifiers can be updated by using Query By Example in the HCL OpenAdmin Tool (OAT) for Informix®. Unique identifiers include primary key, unique constraint, unique index, and rowid if the table is not fragmented.

To update a table row on the database server:

  1. Perform a query by using Query By Example. See Performing a query.
  2. If necessary, use the arrow buttons to scroll to the row.
  3. Enter the changes for the row in the fields.
  4. Click Update Row.

    The row is updated on the database server.


Copyright© 2018 HCL Technologies Limited