in case of the active pictures - a triplet of processes D2000 HI (HIP),
HIS and D2000 Server
Event Executor (SEE).
If process D2000 EventHandler is started with the parameter --batch_mode,
"context" is assigned uniquely to a group of events, which are
opened with the same instance number
(OPENEVENT), not to whole process. The parameter
enables the run of several events on the one EventHandler, and each of them
can use own
In the case of identical instance numbers, the "context" is
mutual shared (is common) and the conditions for implementation of database
operation are therefore the same.
The context represents the group of uniquely named parameters where
every parameter has a value. It is created by first usage of
DB_SET_PROCESS_PARAMS action. It is handled by
The context is terminated after finishing the last process from the
proper group. The contents of context is replicated automatically to all
Before executing any database command, which was initiated within context,
D2000 DbManager, inserts its contents into the table D2000_PROCESS_PARAMS. It
inserts the parameter name into the column
PARAM_NAME and its value into the column PARAM_VALUE.DbManager
creates the table D2000_PROCESS_PARAMS when it is used for the
This action can be used to create the parameterized views
where the parameters come from the table
D2000_PROCESS_PARAMS. The table is set automatically by DbManager
according to the context in which the database example is used.
Database table D2000_PROCESS_PARAMS is Global Temporary Table.
The sessions see only rows that they wrote there. After deleting a session,
the rows, bound to the given session, will be deleted automatically from the
table. For more information, as well as DLL, see the documentation for
Global Temporary Table.
; this example validates the result of DB_SET_PROCESS_PARAMS by the reading of table D2000_PROCESS_PARAMS
; insert/update of parameter that is bound to the process (it updates the table D2000_PROCESS_PARAMS)
RECORD NOALIAS (SD.Params) _params
TEXT _cmd ; SQL select
INT _retCode ; the return value
_params^PARAM_NAME := "NAME"
_params^PARAM_VALUE := "SELF.DBM"
_cmd := "SELECT PARAM_NAME, PARAM_VALUE FROM D2000_PROCESS_PARAMS WHERE PARAM_NAME = 'NAME'"
; it reads the table
SQL_SELECT DBC_TEST_DSN, _retCode, 1000, _cmd BIND _params
IF _retCode = _ERR_NO_ERROR THEN
; the structure _params is filled, it contains one line
; an error