Use and Updating of Currency by DML Verbs

Navigational DML Programming Techniques › Run Unit Currencies › Use and Updating of Currency by DML Verbs

Use and Updating of Currency by DML Verbs

The table below outlines the currency required to execute each DML verb and the changes to currency following the successful execution of that verb. The bullet symbol (&bul.) indicates currency used in command execution.

Note: BIND and READY do not use or update currency, but both verbs must be issued before any database access is attempted.

DML verb	Run unit	Record	Set	Area	Currency updated by successful execution
ACCEPT*	&bul.	&bul.	&bul.	&bul.	None
IF*	&bul.		&bul.		None
FIND/OBTAIN DB-KEY					All
FIND/OBTAIN CURRENT*	&bul.	&bul.	&bul.	&bul.	All
FIND/OBTAIN WITHIN SET1			&bul.		All
FIND/OBTAIN WITHIN AREA				**	All
FIND/OBTAIN OWNER			&bul.		All
FIND/OBTAIN CALC					All
FIND/OBTAIN DUPLICATE		&bul.			All
FIND/OBTAIN USING SORT KEY2			&bul.		All
GET	&bul.				None
RETURN3			&bul.		Set
STORE			***		All
MODIFY	&bul.				None4
ERASE	&bul.				Nullifies currencies of all record types and sets involved
CONNECT		&bul.	&bul.		Run unit, set
DISCONNECT		&bul.			Nullifies currency of object set; updates current of run unit and area
KEEP*	&bul.	&bul.	&bul.	&bul.	None
COMMIT					None
COMMIT ALL					Nullifies all currencies
ROLLBACK					Nullifies all currencies
ROLLBACK CONTINUE					Nullifies all currencies
FINISH					Nullifies all currencies

*   Uses only one currency as determined by command format.
**  Required for NEXT and PRIOR formats only.
*** All in which record type participates as an automatic member.
1 Currency is not required if the statement specifies FIRST, LAST
     or sequence-number for a system-owned indexed set.
2 Currency is not required for a system-owned indexed set.
3 Currency is not required if the statement specifies FIRST, LAST,
     or USING index-key.
4 Except in the case of a sorted set.