Product Overview

Relational Database Server for ClearPath MCP provides a highly available environment, designed to support large relational databases and high-volume online transaction processing. Relational Database Server incorporates a variety of validation, audit/recovery, and access control capabilities designed to support mission-critical applications.

General Features

Create, Query and Update Relational Databases

The Relational Database Server for ClearPath MCP enables you to: create relational databases using a data definition language (DDL) and the Relational Design Center schema administration tool.

After you have created a relational database, you can query and update it using standard Structured Query Language (SQL)-compliant tools (such as the Query Design Center) and from Java, COBOL and ALGOL applications. A JDBC driver is available for use by Java applications running on MCP JProcessors, as well as on Windows, UNIX, and Linux servers.

Add SQL Capabilities to Existing Enterprise Database Server Databases

The Relational Database Server for ClearPath MCP enables you to add SQL capabilities to existing Enterprise Database Server databases. This allows you to use SQL-compliant tools to access and update the database in addition to the Enterprise Database Server’s host language interface and other data access tools.

The Relational Design Center is a schema administration tool that you can use to enable SQL access to Enterprise Database Server databases. This enables you to perform inquiries or updates against the data in the database by using any tool or application that generates SQL data manipulation language (DML) statements compatible with the Unisys implementation of SQL. For example, these tools or applications include:

Tools and Utilities

Query Processor

The Query Processor is an SQL parser, optimizer, and query execution engine. The Query Processor accepts and executes SQL commands and interacts with the database to return the expected results.

The Query Processor is compliant with the SQL-92, entry level with extensions, data manipulation language (DML) as defined by the American National Standards Institute (ANSI) document X3.135-1992, “Database Language SQL.”

SQL Call-level Interface (CLI) for COBOL and ALGOL Programs

The Relational Database Server provides an SQL call-level interface (CLI) that you can use in COBOL85, COBOL74, and ALGOL programs.

The CLI is a standard SQL interface that enables programs to open databases, accept and manage queries, create and use cursors, specify transaction behavior including isolation levels, and commit or roll back transactions. In addition, the CLI enables programs to detect, handle, and report errors; retrieve query descriptions; and handle parameterized queries for efficient program execution.

The CLI conforms to a subset of the SQL CLI as defined by the International Organization for Standardization document ISO/IEC 9075-3:1999, “Information technology -- Database languages -- SQL -- Part 3: Call-Level Interface (SQL/CLI)”.

JDBC Driver

The JDBC application program interface (API) was developed by Oracle to provide programmatic access to relational data from Java applications.

The JDBC driver—which is based on the JDBC 4.0 Specification published by Oracle— provides programmatic access to Relational Database Server databases and to SQL-enabled Enterprise Database Server databases. The JDBC driver enables you to

The JDBC driver implements a type 4 driver. The driver provides access to databases from a Java application running on MCP JProcessors and on Windows, UNIX, and Linux servers.

Relational Design Center

The Relational Design Center is an interactive schema administration tool that enables you to create and maintain database schemas. You can use the Relational Design Center to:

Query Design Center

The Query Design Center is an interactive tool that administrators and developers can use to design and execute ad-hoc SQL requests against Relational Database Server databases and SQL-enabled Enterprise Database Server databases. This tool makes it easy to design and execute queries against databases and test these queries outside of user applications.

Using Query Design Center, you can specify your solution in terms of joins, ordering, columns to display, and so on. You do not have to use SQL syntax; Query Design Center can automatically build the syntax of your queries based on your input. If you are fluent in SQL, however, you can manually enter and execute SQL syntax

Loader Utility

The Loader utility is a command line tool that facilitates the import of large amounts of data from a file into a table of a Relational Database Server database. The utility is useful for activities such as batch updating of the database from information derived from other databases or for migrating data extracted from some other database.

The utility enables you to describe the form of the input data and to establish various filtering and mapping rules for cases where the input data does not precisely reflect the table in the target database. You can also indicate that only portions of the data from the file be loaded into the table.

New Features/Enhancements

The following features and enhancements were added for this release:

Ordering Information

Source code is not available for this product.

Product Information

Refer to the following documents for more information: