Dynamic-SQL Mode

When a row is edited, it can contain some modified values and some values that remain unchanged. For instance, assuming the address of employee Williams is modified, the following example shows the SQL statement that would be generated if dynamic-SQL is enabled:

UPDATE EMP

SET ADDRESS = ‘16, Chocolate Street’

WHERE ID = 7

Here is the SQL statement if dynamic-SQL is disabled:

UPDATE EMP

SET ID = 7,

NAME = ‘Williams’,

ADDRESS = ‘16, Chocolate Street’

WHERE ID = 7

In the latter case, the values for all the columns are sent back to the database each time an update takes place.