SQL catalog reporting and querying - Revision history

ELowell: /* Report Selection 1: Generate DDL */

2017-10-27T19:09:30Z

Report Selection 1: Generate DDL

← Older revision		Revision as of 19:09, 27 October 2017
Line 153:		Line 153:
	The first reporting option on the Main Menu is to generate the SQL DDL from the existing SQL catalog (CCACAT file) data. This DDL is output in valid SQL syntax that you can use to rebuild the catalog. You can also use it to report the existing catalog data in a standard format familiar to SQL users.</p>		The first reporting option on the Main Menu is to generate the SQL DDL from the existing SQL catalog (CCACAT file) data. This DDL is output in valid SQL syntax that you can use to rebuild the catalog. You can also use it to report the existing catalog data in a standard format familiar to SQL users.</p>

	<p class="note"><b>Note:</b> Currently the CCACATREPT subsystem does not generate DDL statement delimiters. However, semicolons are required by the CVI utility. You can add delimiters by hand or use another SQL utility that does not require DDL delimiters. The Connect<span class="superstar">★</span> ODBC unsupported utilities, DDLWIN and CLIIVP, are examples of utilities which accept DDL input lines without delimiters.</p>		<p class="note"><b>Note:</b> Currently the CCACATREPT subsystem does not generate DDL statement delimiters. However, semicolons are required by the CVI utility. You can add delimiters by hand or use another SQL utility that does not require DDL delimiters. The [[Connect*_for_ODBC\|Connect<span class="superstar">★</span> for ODBC]] unsupported utilities, DDLWIN and CLIIVP, are examples of utilities which accept DDL input lines without delimiters.</p>

	===Specifying report input parameters===		===Specifying report input parameters===

JAL: Dictionary and SQL server from RKTools main menu

2017-06-23T00:33:09Z

Dictionary and SQL server from RKTools main menu

← Older revision		Revision as of 00:33, 23 June 2017
Line 19:		Line 19:
	</ul>		</ul>

	As an Application Subsystem utility, CCACATREPT is subject to typical Application Subsystem security, as described in [[System requirements for Application Subsystems]]. This is the case whether you are accessing CCACATREPT directly from your Model 204 command line as described on this page, or whether you are accessing from the [[RKWeb]] interface. RKWeb uses [[Janus Web Legacy Support]] to serve facsimiles of the screens described on this page.		As an Application Subsystem utility, CCACATREPT is subject to typical Application Subsystem security, as described in [[System requirements for Application Subsystems]]. This is the case whether you are accessing CCACATREPT directly from your Model 204 command line as described on this page, or whether you are accessing from the [[RKTools#mainmenu\|RKTools main menu]] or the [[RKWeb]] interface. RKWeb uses [[Janus Web Legacy Support]] to serve facsimiles of the screens described on this page.

	===Logging in===		===Logging in===

JAL: /* Logging in */ rename link

2017-06-16T23:21:01Z

Logging in: rename link

← Older revision		Revision as of 23:21, 16 June 2017
Line 22:		Line 22:

	===Logging in===		===Logging in===
	Before you can log in to CCACATREPT, the CCACATREPT subsystem must already have been started with the Model 204 <var>START SUBSYSTEM</var> command. If you access CCACATREPT from the RKWeb interface, this command is probably already issued as part of the ~~recommended set up during~~ [[RKTools installation#Janus Web rules for RKWeb\|~~RKTools installation~~]].		Before you can log in to CCACATREPT, the CCACATREPT subsystem must already have been started with the Model 204 <var>START SUBSYSTEM</var> command. If you access CCACATREPT from the RKWeb interface, this command is probably already issued as part of the [[RKTools installation#Janus Web rules for RKWeb\|recommended set up for RKWeb]].

	To log in to CCACATREPT, at your Model 204 Online prompt enter <code><b>CCACATREPT</b></code> and press Enter.		To log in to CCACATREPT, at your Model 204 Online prompt enter <code><b>CCACATREPT</b></code> and press Enter.

	The CCACATREPT Main Menu is displayed.		The CCACATREPT Main Menu is displayed.

JAL: mention RKWeb

2017-06-16T19:16:59Z

mention RKWeb

Show changes

JAL: mention RKWeb

2017-06-14T00:47:45Z

mention RKWeb

← Older revision		Revision as of 00:47, 14 June 2017
Line 19:		Line 19:
	</ul>		</ul>

	As an Application Subsystem utility, CCACATREPT is subject to typical Application Subsystem security, as described in [[System requirements for Application Subsystems]].		As an Application Subsystem utility, CCACATREPT is subject to typical Application Subsystem security, as described in [[System requirements for Application Subsystems]]. This is the case whether you are accessing CCACATREPT directly from your Model 204 command line as described on this page, or whether you are accessing from the [[RKWeb]] interface. RKWeb uses [[Janus Web Legacy Support]] to serve facsimiles of the screens described on this page.

	===Logging in===		===Logging in===
			Before you can log in to CCACATREPT, the CCACATREPT subsystem must already have been started with the Model 204 <var>START SUBSYSTEM</var> command. If you access CCACATREPT from the RKWeb interface, this command is probably already issued as part of the recommended set up during [[RKTools installation#Janus Web rules for RKWeb\|RKTools installation]].
	Before you can log in to CCACATREPT, the CCACATREPT subsystem must already have been started with the Model 204 START SUBSYSTEM command.

	To log in to CCACATREPT, at your Model 204 Online prompt enter <code><b>CCACATREPT</b></code> and press Enter.		To log in to CCACATREPT, at your Model 204 Online prompt enter <code><b>CCACATREPT</b></code> and press Enter.

JAL: misc formatting

2015-08-03T18:57:36Z

misc formatting

Show changes

ELowell: /* ODBC_STATISTICS view */

2015-04-01T21:16:08Z

ODBC_STATISTICS view

← Older revision		Revision as of 21:16, 1 April 2015
Line 2,101:		Line 2,101:
	</tr>		</tr>
	</table>		</table>

			==See also==
			{{Template:SQL topic list}}

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

ELowell: Created page with "To review the current contents of the SQL catalog you can query the catalog directly or you can use CCACATREPT, the SQL catalog reporting utility. This topic describes CCACATR..."

2015-03-20T21:26:40Z

Created page with "To review the current contents of the SQL catalog you can query the catalog directly or you can use CCACATREPT, the SQL catalog reporting utility. This topic describes CCACATR..."

Show changes