Connect-Star to Model 204 connection - Revision history

Ekern at 17:49, 27 March 2024

2024-03-27T17:49:05Z

← Older revision		Revision as of 17:49, 27 March 2024
Line 1:		Line 1:
	{{DISPLAYTITLE: Connect~~<span class="superstar">★</span>~~ to Model 204 connection}}		{{DISPLAYTITLE: Connect-Star to Model 204 connection}}
	==Overview==		==Overview==
	<p>		<p>
	Before you can use one or more of the Connect~~<span class="superstar">★</span>~~ Suite communications interfaces (ODBC, JDBC, and/or .NET Framework), you must verify your connection to the Model 204 data and the ability to access the data in a query. The general steps are as follows:</p>		Before you can use one or more of the Connect-Star Suite communications interfaces (ODBC, JDBC, and/or .NET Framework), you must verify your connection to the Model 204 data and the ability to access the data in a query. The general steps are as follows:</p>

	<ol>		<ol>
	<li>Confirm the mainframe connection with the <var>ping</var> command.</li>		<li>Confirm the mainframe connection with the <var>ping</var> command.</li>
	<li>Use the Connect~~<span class="superstar">★</span>~~ Visual Interface (CVI) to confirm the connection to your Model 204 Online. </li>		<li>Use the Connect-Star Visual Interface (CVI) to confirm the connection to your Model 204 Online. </li>
	</ol>		</ol>

Line 24:		Line 24:
	Check the message displayed. If your command reached the TCP/IP address and was returned, you have a communication line to the mainframe. However, this does not mean that you have connected to the Model 204 Online.</li>		Check the message displayed. If your command reached the TCP/IP address and was returned, you have a communication line to the mainframe. However, this does not mean that you have connected to the Model 204 Online.</li>
	<li>		<li>
	Use the CVI to confirm a connection to the Online. See [[#install CVI\|Installing the Connect~~<span class="superstar">★</span>~~ Visual Interface (CVI)]] and [[#Defining the demonstration database to CCACAT\|Defining the demonstration database to CCACAT]].</li>		Use the CVI to confirm a connection to the Online. See [[#install CVI\|Installing the Connect-Star Visual Interface (CVI)]] and [[#Defining the demonstration database to CCACAT\|Defining the demonstration database to CCACAT]].</li>
	</ol>		</ol>

Line 35:		Line 35:
	When an SQL connection is established to the Model 204 database, the SQL statements are translated by Model 204 at the host, and the results are passed back to the client.		When an SQL connection is established to the Model 204 database, the SQL statements are translated by Model 204 at the host, and the results are passed back to the client.

	Before executing an SQL statement, check with your Connect~~<span class="superstar">★</span>~~ administrator to make sure that either the demonstration database is installed and has been defined to the SQL catalog file, CCACAT, or you have other available tables defined in CCACAT. (See [[#SQL catalog population\|SQL catalog population]].)		Before executing an SQL statement, check with your Connect-Star administrator to make sure that either the demonstration database is installed and has been defined to the SQL catalog file, CCACAT, or you have other available tables defined in CCACAT. (See [[#SQL catalog population\|SQL catalog population]].)

	===RCL===		===RCL===
Line 49:		Line 49:
	You must define a process, process groups and links in Model 204.		You must define a process, process groups and links in Model 204.

	==<b id="install CVI"></b>Installing the Connect~~<span class="superstar">★</span>~~ Visual Interface (CVI)==		==<b id="install CVI"></b>Installing the Connect-Star Visual Interface (CVI)==
	Model 204 provides you with demonstration databases and the CVI, so you can run queries to verify your Model 204 SQL installation.		Model 204 provides you with demonstration databases and the CVI, so you can run queries to verify your Model 204 SQL installation.
	<p>The CVI should be installed before installing any of your Model 204 Connect~~<span class="superstar">★</span>~~ drivers.</p>		<p>The CVI should be installed before installing any of your Model 204 Connect-Star drivers.</p>

	===Prerequisite===		===Prerequisite===
Line 59:		Line 59:

	===To install the CVI===		===To install the CVI===
	The CVI is included with the Connect~~<span class="superstar">★</span>~~ driver download files.		The CVI is included with the Connect-Star driver download files.
	<ol>		<ol>
	<li>With your [[Rocket M204 user ID]] and password handy, navigate to the [https://model204.rocketsoftware.com Rocket M204 Customer Care page].</li>		<li>With your [[Rocket M204 user ID]] and password handy, navigate to the [https://model204.rocketsoftware.com Rocket M204 Customer Care page].</li>
	<li>Click the <b>Download client (workstation) files</b> link to go to the [https://m204.rocketsoftware.com/maint/cllist Client files for Rocket Software page]. </li>		<li>Click the <b>Download client (workstation) files</b> link to go to the [https://m204.rocketsoftware.com/maint/cllist Client files for Rocket Software page]. </li>
	<li>		<li>
	The Connect~~<span class="superstar">★</span>~~ drivers and CVI are available in zip format. Click the <b>Download ZIP file</b> link for the Connect~~<span class="superstar">★</span>~~ drivers (and CVI).</li>		The Connect-Star drivers and CVI are available in zip format. Click the <b>Download ZIP file</b> link for the Connect-Star drivers (and CVI).</li>
	<li>		<li>
	Click <b>Save as</b> to save the cstar.zip file in your preferred directory. (You will later be prompted for the directory where you want to actually install the CVI.)		Click <b>Save as</b> to save the cstar.zip file in your preferred directory. (You will later be prompted for the directory where you want to actually install the CVI.)
Line 90:		Line 90:

	<ol>		<ol>
	<li>Open the Connect Star Visual Interface software. To do this, access your programs from the Windows Start menu, open the Connect Star Visual Interface, and click the Connect Star Visual Interface icon. The Connect~~<span class="superstar">★</span>~~ Visual Interface dialog box opens.		<li>Open the Connect Star Visual Interface software. To do this, access your programs from the Windows Start menu, open the Connect Star Visual Interface, and click the Connect Star Visual Interface icon. The Connect-Star Visual Interface dialog box opens.

	<p class="figure">[[File:CStar_2-1_CVIopen.jpg]] </p>		<p class="figure">[[File:CStar_2-1_CVIopen.jpg]] </p>
	</li>		</li>

	<li>In the Connect~~<span class="superstar">★</span>~~ Visual Interface dialog box, select the Data Sources > New option. The Data Source dialog box opens.		<li>In the Connect-Star Visual Interface dialog box, select the Data Sources > New option. The Data Source dialog box opens.

	<p class="figure">[[File:CStar_2-2_CVIds.jpg]] </p>		<p class="figure">[[File:CStar_2-2_CVIds.jpg]] </p>

Ekern: Ekern moved page Connect* to Model 204 connection to Connect-Star to Model 204 connection

2024-03-27T17:46:27Z

Ekern moved page Connect* to Model 204 connection to Connect-Star to Model 204 connection

← Older revision	Revision as of 17:46, 27 March 2024
(No difference)

JAL: restore ★

2017-08-11T18:34:22Z

restore <span class="superstar">★</span>

← Older revision		Revision as of 18:34, 11 August 2017
Line 49:		Line 49:
	You must define a process, process groups and links in Model 204.		You must define a process, process groups and links in Model 204.

	<~~div~~ id="install CVI"></~~div~~>		==<b id="install CVI"></b>Installing the Connect<span class="superstar">★</span> Visual Interface (CVI)==

	==Installing the Connect<~~sup~~>★</~~sup~~> Visual Interface (CVI)==
	~~<!--Note <div> above-->~~

	Model 204 provides you with demonstration databases and the CVI, so you can run queries to verify your Model 204 SQL installation.		Model 204 provides you with demonstration databases and the CVI, so you can run queries to verify your Model 204 SQL installation.
	<p>The CVI should be installed before installing any of your Model 204 Connect<span class="superstar">★</span> drivers.</p>		<p>The CVI should be installed before installing any of your Model 204 Connect<span class="superstar">★</span> drivers.</p>

ELowell: Undo revision 95417 by ELowell (talk)

2017-01-31T00:21:35Z

Undo revision 95417 by ELowell (talk)

← Older revision		Revision as of 00:21, 31 January 2017
Line 47:		Line 47:
	With Freeway/204 you have access to two SQL and two RCL connections for free. This will require IODEVs 19 and 49 to support SQL and RCL connections. See [[Defining the user environment (CCAIN)]] for a discussion of IODEVs and how to set them up.		With Freeway/204 you have access to two SQL and two RCL connections for free. This will require IODEVs 19 and 49 to support SQL and RCL connections. See [[Defining the user environment (CCAIN)]] for a discussion of IODEVs and how to set them up.

	You must ~~[[DEFINE command\|~~define]] a process, process groups, and links in Model 204.		You must define a process, process groups and links in Model 204.

	<div id="install CVI"></div>		<div id="install CVI"></div>

ELowell: /* To install the CVI */

2017-01-30T23:52:21Z

To install the CVI

← Older revision		Revision as of 23:52, 30 January 2017
Line 65:		Line 65:
	The CVI is included with the Connect<span class="superstar">★</span> driver download files.		The CVI is included with the Connect<span class="superstar">★</span> driver download files.
	<ol>		<ol>
	<li>~~Using~~ your [[Rocket M204 user ID]] and password, ~~log in~~ to the [https://model204.rocketsoftware.com Rocket M204 Customer Care page].</li>		<li>With your [[Rocket M204 user ID]] and password handy, navigate to the [https://model204.rocketsoftware.com Rocket M204 Customer Care page].</li>
	<li>Click the <b>Download client (workstation) files</b> link to go to the [https://m204.rocketsoftware.com/maint/cllist Client files for Rocket Software page]. </li>		<li>Click the <b>Download client (workstation) files</b> link to go to the [https://m204.rocketsoftware.com/maint/cllist Client files for Rocket Software page]. </li>
	<li>		<li>

ELowell: /* Freeway/204 */

2017-01-30T23:46:17Z

Freeway/204

← Older revision		Revision as of 23:46, 30 January 2017
Line 47:		Line 47:
	With Freeway/204 you have access to two SQL and two RCL connections for free. This will require IODEVs 19 and 49 to support SQL and RCL connections. See [[Defining the user environment (CCAIN)]] for a discussion of IODEVs and how to set them up.		With Freeway/204 you have access to two SQL and two RCL connections for free. This will require IODEVs 19 and 49 to support SQL and RCL connections. See [[Defining the user environment (CCAIN)]] for a discussion of IODEVs and how to set them up.

	You must define a process, process groups and links in Model 204.		You must [[DEFINE command\|define]] a process, process groups, and links in Model 204.

	<div id="install CVI"></div>		<div id="install CVI"></div>

ELowell: /* Defining the demonstration database to CCACAT */

2017-01-30T22:41:08Z

Defining the demonstration database to CCACAT

← Older revision		Revision as of 22:41, 30 January 2017
Line 94:		Line 94:

	<ol>		<ol>
	<li>Open the Connect Star Visual Interface software. To do this, ~~go to~~ the Start ~~> Programs~~ menu, open the Connect Star Visual Interface, and click the Connect Star Visual Interface icon. The Connect<span class="superstar">★</span> Visual Interface dialog box opens.		<li>Open the Connect Star Visual Interface software. To do this, access your programs from the Windows Start menu, open the Connect Star Visual Interface, and click the Connect Star Visual Interface icon. The Connect<span class="superstar">★</span> Visual Interface dialog box opens.

	<p class="figure">[[File:CStar_2-1_CVIopen.jpg]] </p>		<p class="figure">[[File:CStar_2-1_CVIopen.jpg]] </p>

ELowell: /* Defining the demonstration database to CCACAT */

2017-01-19T21:12:30Z

Defining the demonstration database to CCACAT

← Older revision		Revision as of 21:12, 19 January 2017
Line 94:		Line 94:

	<ol>		<ol>
	<li>Open the Connect Star Visual Interface software. To do this, go to the Start > Programs menu, open the Connect Star ~~For Model 204 folder~~, and ~~double-~~click the Connect Star Visual Interface. The ~~following~~ Connect<span class="superstar">★</span> Visual Interface dialog box opens.		<li>Open the Connect Star Visual Interface software. To do this, go to the Start > Programs menu, open the Connect Star Visual Interface, and click the Connect Star Visual Interface icon. The Connect<span class="superstar">★</span> Visual Interface dialog box opens.

	<p class="figure">[[File:CStar_2-1_CVIopen.jpg]] </p>		<p class="figure">[[File:CStar_2-1_CVIopen.jpg]] </p>

ELowell: /* To install the CVI */

2017-01-19T21:04:20Z

To install the CVI

← Older revision		Revision as of 21:04, 19 January 2017
Line 81:		Line 81:
	By installing the CVI you can enable a connection to a data source on Model 204.		By installing the CVI you can enable a connection to a data source on Model 204.

	Next you will use the CVI to define a data source~~. Then you can use the CVI~~ to check whether you have successfully connected to Model 204 ~~by entering a query~~.		Next you will use the CVI to define a data source and then enter a query to check whether you have successfully connected to Model 204. See the following sections for details.

	==SQL catalog population==		==SQL catalog population==

ELowell at 20:48, 19 January 2017

2017-01-19T20:48:19Z

← Older revision		Revision as of 20:48, 19 January 2017
Line 55:		Line 55:

	Model 204 provides you with demonstration databases and the CVI, so you can run queries to verify your Model 204 SQL installation.		Model 204 provides you with demonstration databases and the CVI, so you can run queries to verify your Model 204 SQL installation.
	<p>The CVI should be installed before installing any of your Model 204 Connect* drivers.</p>		<p>The CVI should be installed before installing any of your Model 204 Connect<span class="superstar">★</span> drivers.</p>

	===Prerequisite===		===Prerequisite===