Table of Contents
- Starting Relational Design Center
- Understanding the Relational Design Center Interface
- Using the Menu Bar
- Understanding Relational Mappings for SQL
-
- Default SQL Names
- Global Data Defaults
- Disjoint Data Set Defaults
- Embedded Data Set and Occurring Item Defaults
- Initial Values
- Set and Access Defaults as Indexes
- Set and Subset Defaults as Views
- Data Item Defaults
- Link Defaults
- Group Defaults
- Physical Option Defaults
- Restart Data Set Defaults
- SQL Referential Integrity Constraints
- Internal Large Objects (LOBs)
- SQL TIME
- SQL DATE
- Date Construct
- Security
- View Construct
- Working with Servers
- Working with Databases
- Working with Database Schemas
-
- Modifying Data Sets
- Modifying Occurring Items
- Modifying Variable-Format Items
- Modifying Indexes (Sets and Subsets)
- Modifying Data Items (Columns and Primary Keys)
- Creating SQL Dates
- Modifying SQL Dates
- Creating Integrity Constraints
- Modifying Integrity Constraints
- Creating SQL Views
- Modifying SQL Views
This section describes the Relational Design Center, which is a schema administration tool that enables SQL access to Enterprise Database Server databases. Relational Design Center enables the database owner to perform a variety of tasks against the databases. Depending on the type of database or file processed, the owner of the database can perform the following tasks:
-
Generate an SQL schema (relational view) for Enterprise Database Server databases.
-
Define and modify schema attributes to be used for mapping an Enterprise Database Server description file.
-
View a mapped Enterprise Database Server database definition.
Once you have created an SQL description of your database, you can 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:
-
Relational Database Server for ClearPath MCP Query Design Center
-
JDBC for ClearPath MCP
-
ODBC for ClearPath MCP
-
ClearPath MCP environment applications that use the SQL call-level interface (CLI) such as COBOL or ALGOL
Relational Design Center offers the following features:
-
Creation of SQL descriptions for existing Enterprise Database Server databases
-
SQL security using views, including row and column security
-
Referential integrity
-
Ability to disable all updates
-
Concurrent access to Enterprise Database Server databases with Enterprise Database Server and SQL applications
-
Enterprise Database Server items specified as SQL date items
-
Use of Enterprise Database Server data names while using SQL facilities
-
New SQL names for Enterprise Database Server data sets, sets, and data items
-
Exclusion of certain Enterprise Database Server data sets, sets, or data items from the generated SQL descriptions
-
Multiple interfaces from which to generate SQL descriptions of existing Enterprise Database Server databases
