When you use Update on the Rows Menu to create update characteristics for a DataWindow,  you can also specify whether you want PowerBuilder to generate:

A WHERE clause containing key values, key values and modified columns, or key values and all updateable columns

An UPDATE statement or a DELETE and INSERT statement when a key field is modified.

TIP:   The syntax you select can effect runtime performance.

To specify the SQL syntax:

1. Select Update from the Rows menu.  The Update Characteristics window displays.
2. Specify the columns you want to update.
3. Select an option in the Where Clause for Update/Delete box; the default is Key Columns. This options controls the columns that will be included in the WHERE clause of the UPDATE or DELETE statement PowerBuilder generates when you update the database with changes in the DataWindow.

This Option	Generates a WHERE clause with
Key Columns	All key columns
Key and Updateable Columns	All key and updateable columns
Key and Modified Columns	All key and modified columns

4. Select an option in the Key Modification box to specify the SQL you want PowerBuilder to generate when a key value is updated.  The options are :

INSERT and DELETE

UPDATE (default)

5. Click the OK button.  PowerBuilder saves your selections and closes the Update Characteristics window.