SET_ACTION procedure - Set and register module action name

The SET_ACTION procedure is used to set and register module action name.

Syntax

Read syntax diagramSkip visual syntax diagramDBMS_APPLICATION_INFO.SET_ACTION(action_name )

Procedure parameters

action_name

An expression that specifies the name of the current action. The value returned has a data type of VARCHAR(32672).

Note: The action_name should be set to the name of the current transaction or logical unit of work executing within the module.

Authorization

EXECUTE privilege on the DBMS_APPLICATION_INFO module.

Example

The following example shows a procedure call to set the action name of the current module:

db2 " CALL DBMS_APPLICATION_INFO.SET_ACTION('<action name>')"