Searched UPDATE:
>>-UPDATE--+-table-name-+--+--------------------+---------------> '-view-name--' '-correlation-clause-' >--+-------------------------+--SET--assignment-clause----------> +-OVERRIDING SYSTEM VALUE-+ '-OVERRIDING USER VALUE---' >--+-------------------------+--+------------------+----------->< '-WHERE--search-condition-' '-isolation-clause-'
Positioned UPDATE:
>>-UPDATE--+-table-name-+--+--------------------+---------------> '-view-name--' '-correlation-clause-' >--+-------------------------+--SET--assignment-clause----------> +-OVERRIDING SYSTEM VALUE-+ '-OVERRIDING USER VALUE---' >--WHERE CURRENT OF--cursor-name-------------------------------><
assignment-clause:: .-,------------------------------------------------------------. V | |--+---+-+-column-name-------+-- = --+-expression-+---------------+-+-+--| | | '-(--column-name--)-' +-NULL-------+ | | | | '-DEFAULT----' | | | | .-,-----------. .-,--------------. | | | | V | V | | | | '-(----column-name-+--)-- = --(--+---+-expression-+-+-+--)-' | | | +-NULL-------+ | | | | '-DEFAULT----' | | | '-row-fullselect-----' | | .-,--------------. | | V | | '-ROW-- = --(--+---+-expression-+-+-+--)---------------------------' | +-NULL-------+ | | '-DEFAULT----' | '-row-fullselect-----'
isolation-clause: |--WITH--+-NC-+-------------------------------------------------| +-UR-+ +-CS-+ +-RS-+ '-RR-'
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.