DEFINE PROCESSGROUP command: CRAM or IUCV SQL processgroup: Difference between revisions

From m204wiki
Jump to navigation Jump to search
m (Automatically generated page update)
 
 
Line 15: Line 15:
<tr>
<tr>
<th>name</th>
<th>name</th>
<td> is used on DEFINE PROCESS commands to refer to this group of processes. The length of the name must be eight characters or less. ALL is a reserved word and cannot be used.</td>
<td> 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.</td>
</tr>
</tr>
   
   
Line 35: Line 35:
</table>
</table>
===Syntax notes===
===Syntax notes===
REMOTEID is not a valid parameter for a CRAM or IUCV SQL processgroup definition and must not be specified.  
REMOTEID is not a valid parameter for a CRAM or IUCV SQL processgroup definition and must not be specified.
 
==Example==
==Example==
<p class="code">DEFINE PROCESSGROUP SQLUSER WITH  -
<p class="code">DEFINE PROCESSGROUP SQLUSER WITH  -

Latest revision as of 15:15, 17 March 2016

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.