https://m204wiki.rocketsoftware.com/index.php?title=DEFINE_PROCESS_command:_SQL&feed=atom&action=historyDEFINE PROCESS command: SQL - Revision history2024-03-29T14:42:21ZRevision history for this page on the wikiMediaWiki 1.40.1https://m204wiki.rocketsoftware.com/index.php?title=DEFINE_PROCESS_command:_SQL&diff=117286&oldid=prevDCameron: /* Syntax */2019-02-12T16:14:47Z<p><span dir="auto"><span class="autocomment">Syntax</span></span></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 16:14, 12 February 2019</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l34">Line 34:</td>
<td colspan="2" class="diff-lineno">Line 34:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><tr></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><tr></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><th><var>DATALEN</var></th></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><th><var>DATALEN</var></th></div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><td> specifies the size of the Horizon conversation buffer that is used to receive data from, and to return data to, the client SQL application. The DATALEN maximum is 32763. </div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><td> specifies the size of the <ins style="font-weight: bold; text-decoration: none;">[[Model_204_intersystem_processing#</ins>Horizon<ins style="font-weight: bold; text-decoration: none;">|Horizon]] </ins>conversation buffer that is used to receive data from, and to return data to, the client SQL application. The DATALEN maximum is 32763. </div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><p>DATALEN applies to Horizon only. It is ignored by CRAM and IUCV&nbsp;SQL.</p></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><p>DATALEN applies to Horizon only. It is ignored by CRAM and IUCV&nbsp;SQL.</p></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><p>To avoid truncation of client data received, DATALEN must be greater than or equal to the Datalen value in the Connect:Gateway Server configuration or the Data Buffer Length value in the configuration of the Connect:Workstation with direct connection. </p></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><p>To avoid truncation of client data received, DATALEN must be greater than or equal to the Datalen value in the Connect:Gateway Server configuration or the Data Buffer Length value in the configuration of the Connect:Workstation with direct connection. </p></div></td></tr>
<tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l43">Line 43:</td>
<td colspan="2" class="diff-lineno">Line 43:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div> </div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div></table></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div></table></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==Syntax==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==Syntax==</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><p>A process is a Horizon conversation program. It is associated with the FROM parameter with a set of processgroups. The processgroups associate the process with one or more links.</p></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><p>A process is a Horizon conversation program. It is associated with the FROM parameter with a set of processgroups. The processgroups associate the process with one or more links.</p></div></td></tr>
</table>DCameronhttps://m204wiki.rocketsoftware.com/index.php?title=DEFINE_PROCESS_command:_SQL&diff=78880&oldid=prevELowell: /* Usage */2015-08-07T21:09:28Z<p><span dir="auto"><span class="autocomment">Usage</span></span></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 21:09, 7 August 2015</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l58">Line 58:</td>
<td colspan="2" class="diff-lineno">Line 58:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==Usage==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==Usage==</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><p>In <var class="product">Model&nbsp;204</var> SQL connections, CCARSQL is always the server process in the conversation. CCARSQL always receives (never initiates) the SQL client's request for a conversation.</p></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><p>In <var class="product">Model&nbsp;204</var> SQL connections, CCARSQL is always the server process in the conversation. CCARSQL always receives (never initiates) the SQL client's request for a conversation.</p></div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><p>For more information about SQL entities, see <del style="font-weight: bold; text-decoration: none;">the <var>Model&nbsp;204 SQL Server User's Guide</var></del>. <del style="font-weight: bold; text-decoration: none;"> </del></p></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><p>For more information about SQL entities, see <ins style="font-weight: bold; text-decoration: none;">[[Networking concepts and terminology]]</ins>.</p></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[Category: System manager commands]]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[Category: System manager commands]]</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[Category:Commands]]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[Category:Commands]]</div></td></tr>
</table>ELowellhttps://m204wiki.rocketsoftware.com/index.php?title=DEFINE_PROCESS_command:_SQL&diff=78879&oldid=prevELowell: /* Syntax */2015-08-07T21:06:54Z<p><span dir="auto"><span class="autocomment">Syntax</span></span></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 21:06, 7 August 2015</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l49">Line 49:</td>
<td colspan="2" class="diff-lineno">Line 49:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><p>The CCARSQL process is the only process used in <var class="product">Model&nbsp;204</var> SQL connections.</p></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><p>The CCARSQL process is the only process used in <var class="product">Model&nbsp;204</var> SQL connections.</p></div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><p>If you require both a mainframe and a Connect<del style="font-weight: bold; text-decoration: none;">:</del>workstation SQL connection, you need to define CCARSQL only once (that is, with your CRAM or IUCV SQL definitions or with your Horizon definitions). On that CCARSQL definition you must list as values of the FROM parameter the names of all the processgroups defined for CRAM or IUCV SQL and for Horizon.</p></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><p>If you require both a mainframe and a Connect<ins style="font-weight: bold; text-decoration: none;"><span class="superstar">&#9733;</span> </ins>workstation SQL connection, you need to define CCARSQL only once (that is, with your CRAM or IUCV SQL definitions or with your Horizon definitions). On that CCARSQL definition you must list as values of the FROM parameter the names of all the processgroups defined for CRAM or IUCV SQL and for Horizon.</p></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><p>If you have already defined CCARSQL as part of the Horizon definitions, do not include a DEFINE PROCESS command as part of your CRAM or IUCV SQL definitions. But make sure that the CCARSQL definition includes the name of your CRAM or IUCV SQL processgroups. </p></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><p>If you have already defined CCARSQL as part of the Horizon definitions, do not include a DEFINE PROCESS command as part of your CRAM or IUCV SQL definitions. But make sure that the CCARSQL definition includes the name of your CRAM or IUCV SQL processgroups. </p></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><p class="note"><b>Note:</b> </div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><p class="note"><b>Note:</b> </div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br/>Horizon DEFINE PROCESS parameters other than SCOPE and FROM are ignored by CRAM and IUCV SQL. </div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br/>Horizon DEFINE PROCESS parameters other than SCOPE and FROM are ignored by CRAM and IUCV SQL. </div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><br/>If you include a CCARSQL process definition with both your mainframe and Connect<del style="font-weight: bold; text-decoration: none;">: </del>workstation DEFINE commands, make sure that it is the same in both places and names all <var class="product">Model&nbsp;204</var> SQL processgroups.</p></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><br/>If you include a CCARSQL process definition with both your mainframe and Connect<ins style="font-weight: bold; text-decoration: none;"><span class="superstar">&#9733;</span> </ins>workstation DEFINE commands, make sure that it is the same in both places and names all <var class="product">Model&nbsp;204</var> SQL processgroups.</p></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==Usage==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==Usage==</div></td></tr>
</table>ELowellhttps://m204wiki.rocketsoftware.com/index.php?title=DEFINE_PROCESS_command:_SQL&diff=78878&oldid=prevELowell: /* Syntax */2015-08-07T21:05:27Z<p><span dir="auto"><span class="autocomment">Syntax</span></span></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 21:05, 7 August 2015</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l46">Line 46:</td>
<td colspan="2" class="diff-lineno">Line 46:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><p>A process is a Horizon conversation program. It is associated with the FROM parameter with a set of processgroups. The processgroups associate the process with one or more links.</p></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><p>A process is a Horizon conversation program. It is associated with the FROM parameter with a set of processgroups. The processgroups associate the process with one or more links.</p></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><p>In <var class="product">Model&nbsp;204</var> SQL connections, the <var class="product">Model&nbsp;204</var> SQL process, named CCARSQL, is used for all connections to the <var class="product">Model&nbsp;204</var> SQL Server. Whereas link and processgroup <del style="font-weight: bold; text-decoration: none;">definition </del>usually vary with the type of connection, one definition of CCARSQL must apply to all SQL connections. For example, if you have Connect<span class="superstar">&#9733;</span> connections to the same copy of <var class="product">Model&nbsp;204</var>, you should specify only one CCARSQL definition. which must service all the connections.</p></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><p>In <var class="product">Model&nbsp;204</var> SQL connections, the <var class="product">Model&nbsp;204</var> SQL process, named CCARSQL, is used for all connections to the <var class="product">Model&nbsp;204</var> SQL Server. Whereas link and processgroup <ins style="font-weight: bold; text-decoration: none;">definitions </ins>usually vary with the type of connection, one definition of CCARSQL must apply to all SQL connections. For example, if you have Connect<span class="superstar">&#9733;</span> connections to the same copy of <var class="product">Model&nbsp;204</var>, you should specify only one CCARSQL definition. which must service all the connections.</p></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><p>The CCARSQL process is the only process used in <var class="product">Model&nbsp;204</var> SQL connections.</p></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><p>The CCARSQL process is the only process used in <var class="product">Model&nbsp;204</var> SQL connections.</p></div></td></tr>
</table>ELowellhttps://m204wiki.rocketsoftware.com/index.php?title=DEFINE_PROCESS_command:_SQL&diff=78877&oldid=prevELowell: /* Syntax */2015-08-07T21:03:44Z<p><span dir="auto"><span class="autocomment">Syntax</span></span></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 21:03, 7 August 2015</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l46">Line 46:</td>
<td colspan="2" class="diff-lineno">Line 46:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><p>A process is a Horizon conversation program. It is associated with the FROM parameter with a set of processgroups. The processgroups associate the process with one or more links.</p></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><p>A process is a Horizon conversation program. It is associated with the FROM parameter with a set of processgroups. The processgroups associate the process with one or more links.</p></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><p>In <var class="product">Model&nbsp;204</var> SQL connections, the <var class="product">Model&nbsp;204</var> SQL process, named CCARSQL, is used for all connections to the <var class="product">Model&nbsp;204</var> SQL Server. Whereas link and processgroup definition usually vary with the type of connection, <del style="font-weight: bold; text-decoration: none;">on </del>definition of CCARSQL must apply to all SQL connections. For example, if you have Connect<del style="font-weight: bold; text-decoration: none;">:</del>connections to the same copy of <var class="product">Model&nbsp;204</var>, you should specify only one CCARSQL definition. which must service all the connections.</p></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><p>In <var class="product">Model&nbsp;204</var> SQL connections, the <var class="product">Model&nbsp;204</var> SQL process, named CCARSQL, is used for all connections to the <var class="product">Model&nbsp;204</var> SQL Server. Whereas link and processgroup definition usually vary with the type of connection, <ins style="font-weight: bold; text-decoration: none;">one </ins>definition of CCARSQL must apply to all SQL connections. For example, if you have Connect<ins style="font-weight: bold; text-decoration: none;"><span class="superstar">&#9733;</span> </ins>connections to the same copy of <var class="product">Model&nbsp;204</var>, you should specify only one CCARSQL definition. which must service all the connections.</p></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><p>The CCARSQL process is the only process used in <var class="product">Model&nbsp;204</var> SQL connections.</p></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><p>The CCARSQL process is the only process used in <var class="product">Model&nbsp;204</var> SQL connections.</p></div></td></tr>
</table>ELowellhttps://m204wiki.rocketsoftware.com/index.php?title=DEFINE_PROCESS_command:_SQL&diff=78876&oldid=prevELowell: /* Usage */2015-08-07T20:59:43Z<p><span dir="auto"><span class="autocomment">Usage</span></span></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 20:59, 7 August 2015</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l57">Line 57:</td>
<td colspan="2" class="diff-lineno">Line 57:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==Usage==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==Usage==</div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><p>In <var class="product">Model&nbsp;204</var> SQL connections, <del style="font-weight: bold; text-decoration: none;">the <var class="product">Model&nbsp;204</var> SQL process (named </del>CCARSQL<del style="font-weight: bold; text-decoration: none;">) </del>is always the server process in the conversation. CCARSQL always receives (never initiates) the SQL client's request for a conversation.</p></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><p>In <var class="product">Model&nbsp;204</var> SQL connections, CCARSQL is always the server process in the conversation. CCARSQL always receives (never initiates) the SQL client's request for a conversation.</p></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><p>For more information about SQL entities, see the <var>Model&nbsp;204 SQL Server User's Guide</var>. </p></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><p>For more information about SQL entities, see the <var>Model&nbsp;204 SQL Server User's Guide</var>. </p></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[Category: System manager commands]]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[Category: System manager commands]]</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[Category:Commands]]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[Category:Commands]]</div></td></tr>
</table>ELowellhttps://m204wiki.rocketsoftware.com/index.php?title=DEFINE_PROCESS_command:_SQL&diff=78875&oldid=prevELowell: /* Syntax */2015-08-07T20:58:44Z<p><span dir="auto"><span class="autocomment">Syntax</span></span></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 20:58, 7 August 2015</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l44">Line 44:</td>
<td colspan="2" class="diff-lineno">Line 44:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div></table></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div></table></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==Syntax==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==Syntax==</div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><p>A process is a Horizon conversation program. It is associated with the FROM parameter with a set of processgroups. The processgroups associate the process with one or more links. In <var class="product">Model&nbsp;204</var> SQL connections, the <var class="product">Model&nbsp;204</var> SQL process, named CCARSQL, <del style="font-weight: bold; text-decoration: none;">is always the server process in the conversation. CCARSQL always receives, never initiates, the SQL client's request for a conversation.</p></del></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><p>A process is a Horizon conversation program. It is associated with the FROM parameter with a set of processgroups. The processgroups associate the process with one or more links.<ins style="font-weight: bold; text-decoration: none;"></p></ins></div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;"><p>This same CCARSQL process </del>is used for all connections to the <var class="product">Model&nbsp;204</var> SQL Server. Whereas link and processgroup definition usually vary with the type of connection, on definition of CCARSQL must apply to all SQL connections. For example, if you have Connect:connections to the same copy of <var class="product">Model&nbsp;204</var>, you should specify only one CCARSQL definition. which must service all the connections.</p></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"><p></ins>In <var class="product">Model&nbsp;204</var> SQL connections, the <var class="product">Model&nbsp;204</var> SQL process, named CCARSQL, is used for all connections to the <var class="product">Model&nbsp;204</var> SQL Server. Whereas link and processgroup definition usually vary with the type of connection, on definition of CCARSQL must apply to all SQL connections. For example, if you have Connect:connections to the same copy of <var class="product">Model&nbsp;204</var>, you should specify only one CCARSQL definition. which must service all the connections.</p></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><p>The CCARSQL process is the only process used in <var class="product">Model&nbsp;204</var> SQL connections.</p></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><p>The CCARSQL process is the only process used in <var class="product">Model&nbsp;204</var> SQL connections.</p></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><p>If you require both a mainframe and a Connect:workstation SQL connection, you need to define CCARSQL only once (that is, with your CRAM or IUCV SQL definitions or with your Horizon definitions). On that CCARSQL definition you must list as values of the FROM parameter the names of all the processgroups defined for CRAM or IUCV SQL and for Horizon.</p></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><p>If you require both a mainframe and a Connect:workstation SQL connection, you need to define CCARSQL only once (that is, with your CRAM or IUCV SQL definitions or with your Horizon definitions). On that CCARSQL definition you must list as values of the FROM parameter the names of all the processgroups defined for CRAM or IUCV SQL and for Horizon.</p></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><p>If you have already defined CCARSQL as part of the Horizon definitions, do not include a DEFINE PROCESS command as part of your CRAM or IUCV SQL definitions. But make sure that the CCARSQL definition includes the name of your CRAM or IUCV SQL processgroups. </p></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><p>If you have already defined CCARSQL as part of the Horizon definitions, do not include a DEFINE PROCESS command as part of your CRAM or IUCV SQL definitions. But make sure that the CCARSQL definition includes the name of your CRAM or IUCV SQL processgroups. </p></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><p class="note"><b>Note:</b> </div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><p class="note"><b>Note:</b> </div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br/>Horizon DEFINE PROCESS parameters other than SCOPE and FROM are ignored by CRAM and IUCV SQL. </div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br/>Horizon DEFINE PROCESS parameters other than SCOPE and FROM are ignored by CRAM and IUCV SQL. </div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br/>If you include a CCARSQL process definition with both your mainframe and Connect: workstation DEFINE commands, make sure that it is the same in both places and names all <var class="product">Model&nbsp;204</var> SQL processgroups.</p></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><br/>If you include a CCARSQL process definition with both your mainframe and Connect: workstation DEFINE commands, make sure that it is the same in both places and names all <var class="product">Model&nbsp;204</var> SQL processgroups.</p></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==Usage==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==Usage==</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><p>In <var class="product">Model&nbsp;204</var> SQL connections, the <var class="product">Model&nbsp;204</var> SQL process (named CCARSQL) is always the server process in the conversation. CCARSQL always receives (never initiates) the SQL client's request for a conversation.</p></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><p>In <var class="product">Model&nbsp;204</var> SQL connections, the <var class="product">Model&nbsp;204</var> SQL process (named CCARSQL) is always the server process in the conversation. CCARSQL always receives (never initiates) the SQL client's request for a conversation.</p></div></td></tr>
</table>ELowellhttps://m204wiki.rocketsoftware.com/index.php?title=DEFINE_PROCESS_command:_SQL&diff=53005&oldid=prevAlex: Automatically generated page update2013-02-28T01:04:47Z<p>Automatically generated page update</p>
<p><b>New page</b></p><div>==Summary==<br />
<dl><br />
<dt>Privileges<br />
<dd>User 0 or system manager<br />
<dt>Function<br />
<dd>Defines the SQL process<br />
</dl><br />
==Syntax==<br />
<p class="syntax">DEFINE PROCESS CCARSQL WITH SCOPE=SYSTEM <br />
FROM=(pg1,pg2,...) [DATALEN=nnnnn] [TIMEOUT=nnnnn]<br />
</p><br />
<br />
<b>Where:</b><br />
<table> <br />
<tr><br />
<th><var>SCOPE=SYSTEM</var></th><br />
<td> indicates that the definition is available to all users of the <var class="product">Model&nbsp;204</var> system for the entire run.</td><br />
</tr><br />
<br />
<tr><br />
<th><var>FROM</var></th><br />
<td> associates CCARSQL with one or more processgroups. The values of pg1, pg2, and so on must include the names of all the processgroups serviced by CCARSQL. <br />
<p>Because all <var class="product">Model&nbsp;204</var> SQL processing uses CCARSQL, the FROM parameter processgroup list must include the names of all Connect: processgroups defined for your copy of <var class="product">Model&nbsp;204</var>. </p><br />
</td><br />
</tr><br />
<br />
<tr><br />
<th><var>TIMEOUT</var></th><br />
<td> specifies the time in seconds that the CCARSQL process waits for a network transmission to arrive from its partner. If the TIMEOUT limit is exceeded, the conversation ends abnormally and the session is unbound.<br />
<p>TIMEOUT applies to IUCV SQL only. It is ignored by CRAM&nbsp;SQL. </p><br />
</td><br />
</tr><br />
<br />
<tr><br />
<th><var>DATALEN</var></th><br />
<td> specifies the size of the Horizon conversation buffer that is used to receive data from, and to return data to, the client SQL application. The DATALEN maximum is 32763. <br />
<p>DATALEN applies to Horizon only. It is ignored by CRAM and IUCV&nbsp;SQL.</p><br />
<p>To avoid truncation of client data received, DATALEN must be greater than or equal to the Datalen value in the Connect:Gateway Server configuration or the Data Buffer Length value in the configuration of the Connect:Workstation with direct connection. </p><br />
<p>To optimize performance when returning data to the client, you can adjust DATALEN using the <var class="product">Model&nbsp;204</var> since-last statistic SQLO.</p><br />
<p>For more information about setting DATALEN, see the <var>Model&nbsp;204 SQL Server User's Guide.</var> </p><br />
</td><br />
</tr><br />
<br />
</table><br />
==Syntax==<br />
<p>A process is a Horizon conversation program. It is associated with the FROM parameter with a set of processgroups. The processgroups associate the process with one or more links. In <var class="product">Model&nbsp;204</var> SQL connections, the <var class="product">Model&nbsp;204</var> SQL process, named CCARSQL, is always the server process in the conversation. CCARSQL always receives, never initiates, the SQL client's request for a conversation.</p><br />
<p>This same CCARSQL process is used for all connections to the <var class="product">Model&nbsp;204</var> SQL Server. Whereas link and processgroup definition usually vary with the type of connection, on definition of CCARSQL must apply to all SQL connections. For example, if you have Connect:connections to the same copy of <var class="product">Model&nbsp;204</var>, you should specify only one CCARSQL definition. which must service all the connections.</p><br />
<p>The CCARSQL process is the only process used in <var class="product">Model&nbsp;204</var> SQL connections.</p><br />
<p>If you require both a mainframe and a Connect:workstation SQL connection, you need to define CCARSQL only once (that is, with your CRAM or IUCV SQL definitions or with your Horizon definitions). On that CCARSQL definition you must list as values of the FROM parameter the names of all the processgroups defined for CRAM or IUCV SQL and for Horizon.</p><br />
<p>If you have already defined CCARSQL as part of the Horizon definitions, do not include a DEFINE PROCESS command as part of your CRAM or IUCV SQL definitions. But make sure that the CCARSQL definition includes the name of your CRAM or IUCV SQL processgroups. </p><br />
<p class="note"><b>Note:</b> <br />
<br/>Horizon DEFINE PROCESS parameters other than SCOPE and FROM are ignored by CRAM and IUCV SQL. <br />
<br/>If you include a CCARSQL process definition with both your mainframe and Connect: workstation DEFINE commands, make sure that it is the same in both places and names all <var class="product">Model&nbsp;204</var> SQL processgroups.</p><br />
==Usage==<br />
<p>In <var class="product">Model&nbsp;204</var> SQL connections, the <var class="product">Model&nbsp;204</var> SQL process (named CCARSQL) is always the server process in the conversation. CCARSQL always receives (never initiates) the SQL client's request for a conversation.</p><br />
<p>For more information about SQL entities, see the <var>Model&nbsp;204 SQL Server User's Guide</var>. </p><br />
[[Category: System manager commands]]<br />
[[Category:Commands]]</div>Alex