DEFINE PROCESSGROUP command: CRAM or IUCV SQL processgroup: Difference between revisions
Jump to navigation
Jump to search
m (Automatically generated page update) |
(→Syntax) |
||
| 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 | <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.