Changes data in a row made current by a read cursor command, either by adding data or by modifying existing data.
update [[database.]owner.]{table_name | view_name} set column_name1 = @p1][, column_name2 = @p2]...
Any valid object in the catalog can be substituted for table_name or view_name.
specifies the column name and assigns the new value. The value passes as a cursor parameter.
update authors set au_lname = @p1
The row made current by the cursor authors_cursor is modified, and the column au_lname is set to the value of the parameter @p1.
The cursor can be reused multiple times before it is deallocated.
You can include a from clause in the update statement, but because DB2 does not support it, the DB2 access service ignores it.
Copyright © 2005. Sybase Inc. All rights reserved. |