EXECUTE UPDATE

Use the EXECUTE UPDATE command to execute UPDATE, INSERT or DELETE statements.

The update count will be returned in the JSM command message field.

If you want to use a very large SQL statement then you have the option of preparing the statement using the SET PARAMETER(*SQL) command, then using the EXECUTE UPDATE(*SQLPARAMETER) command.

Syntax:

Command	Keyword	Value	Developer notes
EXECUTE	UPDATE	statement	Required. Execute UPDATE, INSERT or DELETE statement.
		*SQLPARAMETER	Execute previously prepared SQL statement using the PARAMETER(*SQL) keyword on the SET command.

 

Example

SET PARAMETER(*SQL) #WRKLST(TXT)

EXECUTE UPDATE(*SQLPARAMETER)

 

EXECUTE UPDATE(UPDATE EMPLOYEE SET AGE=25)

 

EXECUTE UPDATE(DELETE FROM EMPLOYEE WHERE AGE=25)