Filter
Top Products
[Figure: Example of updating data using a cursor (column to be updated is not in the curso
r table)]
Data can also be updated using an UPDATE statement without using a cursor. For more information on this method,
see 3.2 "Updating Data in a Data Base".
Example 2:
In this example, the cursor in Figure: Example of using a FETCH statement to position a cursor is
moved again. Then ITMNO is updated to the value in the host variable ITMNO, PRODUCT is updated
to "CD PLAYER", STOCKQTY is updated to twice its original value, and WHCODE is updated to a null
value. Specify "340" in the host variable ITMNO.
54