SQL Server overview - Revision history

JAL at 21:20, 13 July 2017

2017-07-13T21:20:16Z

← Older revision		Revision as of 21:20, 13 July 2017
Line 162:		Line 162:
	<tr>		<tr>
	<td nowrap>Connect<span class="superstar">★</span> <br>Visual Interface</td>		<td nowrap>Connect<span class="superstar">★</span> <br>Visual Interface</td>
	<td>Submits SQL DDL streams to the SQL catalog and populates the catalog with your valid DDL definitions.The Connect<span class="superstar">★</span> Visual Interface is a component of the Connect Star Suite for Model 204 and is available only on a PC workstation.		<td>Submits SQL DDL streams to the SQL catalog and populates the catalog with your valid DDL definitions. The Connect<span class="superstar">★</span> Visual Interface is a component of the Connect Star Suite for Model 204 and is available only on a PC workstation.
	<p class="note"><b>Note:</b> Each DDL statement submitted to the CVI must terminate with a semicolon (<tt>;</tt>). </p></td>		<p class="note"><b>Note:</b> Each DDL statement submitted to the CVI must terminate with a semicolon (<tt>;</tt>). </p></td>
	</tr>		</tr>
Line 203:		Line 203:

	[[Category: Model 204 SQL processing]]		[[Category: Model 204 SQL processing]]
			[[Category: RKTools]]

JAL: /* SQL Server supporting tools */add pointer to RKTools main menu

2017-06-23T00:25:40Z

SQL Server supporting tools: add pointer to RKTools main menu

← Older revision		Revision as of 00:25, 23 June 2017
Line 147:		Line 147:
	<td>Provides an interactive, menu-driven facility for mapping existing Model 204 files to SQL tables and columns. The TSF generates a stream of DDL statements you can edit, transmit to a workstation, and submit to the Connect<span class="superstar">★</span> Visual Interface.		<td>Provides an interactive, menu-driven facility for mapping existing Model 204 files to SQL tables and columns. The TSF generates a stream of DDL statements you can edit, transmit to a workstation, and submit to the Connect<span class="superstar">★</span> Visual Interface.
	<p>		<p>
	The TSF is available on the mainframe and accessed from the Model 204 command line, and as of [[RKTools]] version 7.7, it is accessible by web browser from the [[RKWeb]] interface. RKWeb uses [[Janus Web Legacy Support]] to serve facsimiles of the TSF TN3270 screens. </p></td>		The TSF is available on the mainframe and accessed from the Model 204 command line, and as of [[RKTools]] version 7.7, it is accessible by the [[RKTools#mainmenu\|RKTools main menu]] and by web browser from the [[RKWeb]] interface. RKWeb uses [[Janus Web Legacy Support]] to serve facsimiles of the TSF TN3270 screens. </p></td>
	</tr>		</tr>

	<tr>		<tr>
	<td>Catalog Reporting facility <br>(CCACATREPT)</td>		<td>Catalog Reporting facility <br>(CCACATREPT)</td>
	<td>Provides a menu-driven facility for generating DDL from and reports of the SQL catalog contents. With the CCACATREPT, you can review your SQL object definitions, names, and privileges or use DDL it generates to repopulate the SQL catalog. Like the TSF, CCACATREPT is accessed from the Model 204 command line or by web browser from the RKTools RKWeb interface. </td>		<td>Provides a menu-driven facility for generating DDL from and reports of the SQL catalog contents. With the CCACATREPT, you can review your SQL object definitions, names, and privileges or use DDL it generates to repopulate the SQL catalog.
			<p>
			Like the TSF, CCACATREPT is accessed from the Model 204 command line, from the RKTools main menu, or by web browser from the RKTools RKWeb interface. </p></td>
	</tr>		</tr>
	</table>		</table>
Line 160:		Line 162:
	<tr>		<tr>
	<td nowrap>Connect<span class="superstar">★</span> <br>Visual Interface</td>		<td nowrap>Connect<span class="superstar">★</span> <br>Visual Interface</td>
	<td>Submits SQL DDL streams to the SQL catalog and populates the catalog with your valid DDL definitions.The Connect<span class="superstar">★</span> Visual Interface is a component of the Connect Star Suite for Model 204 and is available only on a PC workstation.		<td>Submits SQL DDL streams to the SQL catalog and populates the catalog with your valid DDL definitions.The Connect<span class="superstar">★</span> Visual Interface is a component of the Connect Star Suite for Model 204 and is available only on a PC workstation.
	<p class="note"><b>Note:</b> Each DDL statement submitted to the CVI must terminate with a semicolon (<tt>;</tt>). </p></td>		<p class="note"><b>Note:</b> Each DDL statement submitted to the CVI must terminate with a semicolon (<tt>;</tt>). </p></td>
	</tr>		</tr>

JAL: mention RKWeb

2017-06-16T22:06:17Z

mention RKWeb

← Older revision		Revision as of 22:06, 16 June 2017
Line 141:		Line 141:

	===SQL Server supporting tools===		===SQL Server supporting tools===
	The following Model 204 tools support SQL Server processing:		The following Model 204 tools support SQL Server processing:
	<table>		<table>
	<tr>		<tr>
	<td>Table Specification facility (TSF)</td>		<td nowrap>Table Specification facility <br>(TSF)</td>
	<td>Provides an interactive, menu-driven facility for mapping existing Model 204 files to SQL tables and columns. The TSF generates a stream of DDL statements you can edit, transmit to a workstation and submit to the Connect<span class="superstar">★</span> Visual Interface. The TSF is available on the mainframe ~~only~~.</td>		<td>Provides an interactive, menu-driven facility for mapping existing Model 204 files to SQL tables and columns. The TSF generates a stream of DDL statements you can edit, transmit to a workstation, and submit to the Connect<span class="superstar">★</span> Visual Interface.
			<p>
			The TSF is available on the mainframe and accessed from the Model 204 command line, and as of [[RKTools]] version 7.7, it is accessible by web browser from the [[RKWeb]] interface. RKWeb uses [[Janus Web Legacy Support]] to serve facsimiles of the TSF TN3270 screens. </p></td>
	</tr>		</tr>

	<tr>		<tr>
	<td>Catalog Reporting facility (CCACATREPT)</td>		<td>Catalog Reporting facility <br>(CCACATREPT)</td>
	<td>Provides a menu-driven facility for generating DDL from and reports of the SQL catalog contents. With the CCACATREPT, you can review your SQL object definitions, names, and privileges or use DDL it generates to repopulate the SQL catalog. CCACATREPT is ~~available on~~ the ~~mainframe only~~.</td>		<td>Provides a menu-driven facility for generating DDL from and reports of the SQL catalog contents. With the CCACATREPT, you can review your SQL object definitions, names, and privileges or use DDL it generates to repopulate the SQL catalog. Like the TSF, CCACATREPT is accessed from the Model 204 command line or by web browser from the RKTools RKWeb interface. </td>
	</tr>		</tr>
	</table>		</table>
	<p>The following PC tool supports SQL server processing.</p>		<p>
			The following PC tool supports SQL server processing.</p>
	<table>		<table>
	<tr>		<tr>
	<td>Connect<span class="superstar">★</span> Visual Interface</td>		<td nowrap>Connect<span class="superstar">★</span> <br>Visual Interface</td>
	<td>Submits SQL DDL streams to the SQL catalog and populates the catalog with your valid DDL definitions.The Connect<span class="superstar">★</span> Visual Interface is a component of the Connect Star Suite for Model 204 and is available only on a PC workstation. <BR>		<td>Submits SQL DDL streams to the SQL catalog and populates the catalog with your valid DDL definitions.The Connect<span class="superstar">★</span> Visual Interface is a component of the Connect Star Suite for Model 204 and is available only on a PC workstation.
	<b>Note:</b> Each DDL statement submitted to the CVI must terminate with a semicolon (;).</td>		<p class="note"><b>Note:</b> Each DDL statement submitted to the CVI must terminate with a semicolon (<tt>;</tt>). </p></td>
	</tr>		</tr>
	</table>		</table>

ELowell: /* SQL processing relies on SQL security */

2016-09-13T19:56:55Z

SQL processing relies on SQL security

← Older revision		Revision as of 19:56, 13 September 2016
Line 90:		Line 90:

	===SQL processing relies on SQL security===		===SQL processing relies on SQL security===
	To access the Model 204 SQL Server, SQL processing clients must pass Model 204 login security and any external security software that is in effect. Two of the Model 204 SQL supporting utilities, [[SQL DDL from the Table Specification Facility\|CCATSF]] and CCACATREPT, are protected by Model 204 Application Subsystem security.		To access the Model 204 SQL Server, SQL processing clients must pass Model 204 login security and any external security software that is in effect. Two of the Model 204 SQL supporting utilities, [[SQL DDL from the Table Specification Facility\|CCATSF]] and [[SQL catalog reporting and querying\|CCACATREPT]], are protected by Model 204 Application Subsystem security.
	<p>		<p>
	Model 204 field and record security are not represented and not enforced through the Model 204 SQL Server interface. </p>		Model 204 field and record security are not represented and not enforced through the Model 204 SQL Server interface. </p>

ELowell: /* SQL processing relies on SQL security */

2016-09-13T19:50:24Z

SQL processing relies on SQL security

← Older revision		Revision as of 19:50, 13 September 2016
Line 90:		Line 90:

	===SQL processing relies on SQL security===		===SQL processing relies on SQL security===
	To access the Model 204 SQL Server, SQL processing clients must pass Model 204 login security and any external security software that is in effect. Two of the Model 204 SQL supporting utilities, CCATSF and CCACATREPT, are protected by Model 204 Application Subsystem security.		To access the Model 204 SQL Server, SQL processing clients must pass Model 204 login security and any external security software that is in effect. Two of the Model 204 SQL supporting utilities, [[SQL DDL from the Table Specification Facility\|CCATSF]] and CCACATREPT, are protected by Model 204 Application Subsystem security.
	<p>		<p>
	Model 204 field and record security are not represented and not enforced through the Model 204 SQL Server interface. </p>		Model 204 field and record security are not represented and not enforced through the Model 204 SQL Server interface. </p>

ELowell: /* ANSI SQL 1989 and 1992 */

2016-02-04T21:23:43Z

ANSI SQL 1989 and 1992

← Older revision		Revision as of 21:23, 4 February 2016
Line 168:		Line 168:

	====ANSI SQL 1989 and 1992====		====ANSI SQL 1989 and 1992====
	Model 204 SQL provides all clients ANSI SQL 1989 support and some ANSI SQL 1992 support for SQL DDL and DML. Unless otherwise specified, references in this ~~guide~~ to standard SQL are to the ANSI SQL 1989 and standards.		Model 204 SQL provides all clients ANSI SQL 1989 support and some ANSI SQL 1992 support for SQL DDL and DML. Unless otherwise specified, references in this topic to standard SQL are to the ANSI SQL 1989 and standards.
	<p>		<p>
	SQL Server DDL and DML support includes some extensions to and omissions from the standard. These deviations from the syntax or functionality of the standard are described in [[SQL Data Definition Language (DDL)]] and [[SQL Data Manipulation Language (DML)]]. </p>		SQL Server DDL and DML support includes some extensions to and omissions from the standard. These deviations from the syntax or functionality of the standard are described in [[SQL Data Definition Language (DDL)]] and [[SQL Data Manipulation Language (DML)]]. </p>

ELowell: /* Model 204 SQL processing configurations */

2015-07-14T18:07:04Z

Model 204 SQL processing configurations

← Older revision		Revision as of 18:07, 14 July 2015
Line 12:		Line 12:
	SQL processing for PC clients is provided by the Model 204 Connect<span class="superstar">★</span> Suite. The following figure illustrates the PC clients that can be configured with the Connect<span class="superstar">★</span> 32-bit ODBC Model 204 driver, using a TCP/IP connection to PC clients. SQL processing for PC clients is also provided by JDBC for Model 204 or .NET Framework.		SQL processing for PC clients is provided by the Model 204 Connect<span class="superstar">★</span> Suite. The following figure illustrates the PC clients that can be configured with the Connect<span class="superstar">★</span> 32-bit ODBC Model 204 driver, using a TCP/IP connection to PC clients. SQL processing for PC clients is also provided by JDBC for Model 204 or .NET Framework.

	For more information, see the [[:Category:Connect\|Connect wiki pages]].		For more information, see the [[:Category:Connect*\|Connect<span class="superstar">★</span> wiki pages]].

	<p class="caption" style="width:468px">Model 204 SQL Server and clients</p>		<p class="caption" style="width:468px">Model 204 SQL Server and clients</p>

ELowell: /* Model 204 SQL processing configurations */

2015-07-14T17:56:59Z

Model 204 SQL processing configurations

← Older revision		Revision as of 17:56, 14 July 2015
Line 12:		Line 12:
	SQL processing for PC clients is provided by the Model 204 Connect<span class="superstar">★</span> Suite. The following figure illustrates the PC clients that can be configured with the Connect<span class="superstar">★</span> 32-bit ODBC Model 204 driver, using a TCP/IP connection to PC clients. SQL processing for PC clients is also provided by JDBC for Model 204 or .NET Framework.		SQL processing for PC clients is provided by the Model 204 Connect<span class="superstar">★</span> Suite. The following figure illustrates the PC clients that can be configured with the Connect<span class="superstar">★</span> 32-bit ODBC Model 204 driver, using a TCP/IP connection to PC clients. SQL processing for PC clients is also provided by JDBC for Model 204 or .NET Framework.

	For more information, see the ~~<var class="book">Rocket Model 204~~ Connect~~<span class="superstar">★</span> Suite Installation and Programming Guide</var>~~.		For more information, see the [[:Category:Connect\|Connect wiki pages]].

	<p class="caption" style="width:468px">Model 204 SQL Server and clients</p>		<p class="caption" style="width:468px">Model 204 SQL Server and clients</p>

ELowell at 20:16, 15 April 2015

2015-04-15T20:16:20Z

← Older revision		Revision as of 20:16, 15 April 2015
Line 96:		Line 96:
	The primary security protection for issuing SQL DDL and DML is provided by SQL GRANT and REVOKE statements and SQL views. GRANT and REVOKE define who is allowed to perform a given operation on a given SQL object. Views allow you to define subsets of the database to which you can selectively grant access. </p>		The primary security protection for issuing SQL DDL and DML is provided by SQL GRANT and REVOKE statements and SQL views. GRANT and REVOKE define who is allowed to perform a given operation on a given SQL object. Views allow you to define subsets of the database to which you can selectively grant access. </p>
	<p>		<p>
	You can also replace Model 204 SQL security with privilege checking by an external security package. You provide user exits to the security package in a Model 204-defined format. For details, see ~~the~~ [[~~#Category:Security interfaces\|Security interfaces~~]] ~~wiki topics~~.</p>		You can also replace Model 204 SQL security with privilege checking by an external security package. You provide user exits to the security package in a Model 204-defined format. For details, see [[SQL security exits]].</p>

	==Model 204 SQL processing components==		==Model 204 SQL processing components==

ELowell at 21:59, 1 April 2015

2015-04-01T21:59:11Z

← Older revision		Revision as of 21:59, 1 April 2015
Line 2:		Line 2:
	Model 204 provides industry standard SQL access to Model 204 data through client-server technology. The Model 204 SQL Server provides full SQL processing in the basic Model 204 address space or virtual machine (ONLINE module) in the z/OS, z/VSE, and VM operating systems. The client-server architecture allows the Model 204 SQL Server to service networked PC clients.		Model 204 provides industry standard SQL access to Model 204 data through client-server technology. The Model 204 SQL Server provides full SQL processing in the basic Model 204 address space or virtual machine (ONLINE module) in the z/OS, z/VSE, and VM operating systems. The client-server architecture allows the Model 204 SQL Server to service networked PC clients.

	===Model 204 SQL processing configurations===		==SQL topics==
			The SQL documentation consists of the pages listed below.
			This list is also available as a "See also" link from each of the pages.

			{{Template: SQL topic list}}

			==Model 204 SQL processing configurations==

	SQL processing for PC clients is provided by the Model 204 Connect<span class="superstar">★</span> Suite. The following figure illustrates the PC clients that can be configured with the Connect<span class="superstar">★</span> 32-bit ODBC Model 204 driver, using a TCP/IP connection to PC clients. SQL processing for PC clients is also provided by JDBC for Model 204 or .NET Framework.		SQL processing for PC clients is provided by the Model 204 Connect<span class="superstar">★</span> Suite. The following figure illustrates the PC clients that can be configured with the Connect<span class="superstar">★</span> 32-bit ODBC Model 204 driver, using a TCP/IP connection to PC clients. SQL processing for PC clients is also provided by JDBC for Model 204 or .NET Framework.
Line 10:		Line 16:
	<p class="caption" style="width:468px">Model 204 SQL Server and clients</p>		<p class="caption" style="width:468px">Model 204 SQL Server and clients</p>
	<p class="figure">[[File:SQL_Server_UG_fig_1-1.gif]]</p>		<p class="figure">[[File:SQL_Server_UG_fig_1-1.gif]]</p>

	~~==SQL topics==~~
	~~The SQL documentation consists of the pages listed below.~~
	~~This list is also available as a "See also" link from each of the pages.~~

	~~{{Template: SQL topic list}}~~

	==How the SQL Server works within Model 204==		==How the SQL Server works within Model 204==