DEFINE PROCESS command: User Language to DB2

From m204wiki
Revision as of 17:21, 14 April 2017 by ELowell (talk | contribs) (→‎Usage notes)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Summary

Privileges
User 0 or system manager
Function
The DEFINE PROCESS command defines a process that a User Language procedure can reference.

Syntax

DEFINE PROCESS CCADB2 WITH SCOPE=SYSTEM DESTINATION=(pgrpname,symbolicname)

Where:

CCADB2 is a reserved process name.
SCOPE=SYSTEM indicates that the process entity definition is available to all users of the Model 204 system for the entire run.
DESTINATION can be:
pgrpname is the processgroup specified in the DEFINE PROCESSGROUP command.
symbolicname is from one to eight characters in length, and is associated with the corresponding pgrpname. A User Language procedure uses symbolicname to refer to the link. That is:

CONNECT TO symbolicname

Therefore, any changes made to the physical name, or to the processgroup and/or link, do not cause any changes to be made in the procedures.

Example

DEFINE PROCESS CCADB2 WITH - SCOPE=SYSTEM - DESTINATION=(DB2GRP,BOSTON)

Usage notes

For more information about the User Language/DATABASE 2 Interface, see the UL/DB2 topics.