DEFINE PROCESSGROUP command: CRAM or IUCV SQL processgroup

From m204wiki
Revision as of 15:15, 17 March 2016 by ELowell (talk | contribs) (→‎Syntax)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Summary

Privileges
User 0 or system manager
Function
Connects the CCARSQL process to a specific CRAM or IUCV SQL link

Syntax

DEFINE PROCESSGROUP name [LIKE previousname] WITH SCOPE=SYSTEM LINK=linkname

Where:

name is used on DEFINE PROCESS commands to refer to this group of processes. The length of the name must be eight characters or fewer. ALL is a reserved word and cannot be used.
LIKE is an optional time-saving parameter. If you are defining a new processgroup and have already defined a processgroup with the exact attributes you want, you can define the same attributes without repeating them by using LIKE. If you use LIKE, you must also specify WITH SCOPE=SYSTEM.
SCOPE=SYSTEM indicates that the definition is available to all users of the Model 204 system for the entire run.
LINK is used to associate the processgroup with a particular link. The link name must be the same as the link name specified on the CRAM or IUCV SQL DEFINE LINK command.

Syntax notes

REMOTEID is not a valid parameter for a CRAM or IUCV SQL processgroup definition and must not be specified.

Example

DEFINE PROCESSGROUP SQLUSER WITH - SCOPE=SYSTEM LINK=CRAMSTAR

Usage notes

For more information about CRAM or IUCV SQL entities, see the Model 204 SQL Server User's Guide.