ClearPath MCP 20.0
May 2021
8222 3819-004
Copyright © 2021 Unisys Corporation.
Warranty Disclaimer
NO WARRANTIES OF ANY NATURE ARE EXTENDED BY THIS DOCUMENT. Any product or related information described herein is only furnished pursuant and subject to the terms and conditions of a duly executed agreement to purchase or lease equipment or to license software. The only warranties made by Unisys, if any, with respect to the products described in this document are set forth in such agreement. Unisys cannot accept any financial or other responsibility that may be the result of your use of the information in this document or software material, including direct, special, or consequential damages.
You should be very careful to ensure that the use of this information and/or software material complies with the laws, rules, and regulations of the jurisdictions with respect to which it is used.
The information contained herein is subject to change without notice. Revisions may be issued to advise of such changes and/or additions.
Notice to U.S. Government End Users: This software and any accompanying documentation are commercial items which have been developed entirely at private expense. They are delivered and licensed as commercial computer software and commercial computer software documentation within the meaning of the applicable acquisition regulations. Use, reproduction, or disclosure by the Government is subject to the terms of Unisys’ standard commercial license for the products, and where applicable, the restricted/limited rights provisions of the contract data rights clauses.
Table of Contents
- Overview
- Installing Query Processor
-
- Hardware and Software Requirements
- Installing the Query Processor Software in the MCP Environment
-
- Manually Assigning the Query Processor Library Function Names to the Server Library Code File Titles
- Creating the Server Configuration File (MCPSQL/CONFIG)
- Changing the Name and Location of the Query Processor Configuration File
- Creating the Server Configuration File (MCPSQL/SERVER/CONFIG)
- Setting the Query Processor Server Timeout Interval
- Configuring the TCP/IP Distributed Systems Services (DSS)
- Optional Installation Tasks
- Installing the Query Processor Utilities in the Windows Environment
-
- Installing the Query Processor Utilities in the Linux Environment
- Updating a Relational Database Server for ClearPath MCP Query Processor Database
- Updating an Enterprise Database Server Database
- Updating an SQL Database
- Migrating from an SQL Query Processor for ClearPath MCP Database to a Relational Database Server for ClearPath MCP Query Processor Database
- Migrating an Enterprise Database Server Database
- Migrating an SQL Database
- Removing the Query Processor Software
- Reinstalling the Query Processor Software
- Troubleshooting
- Updating Enterprise Database Server Databases with SQL Queries
- Updating Enterprise Database Server Data Sets with SQL Queries
- Using Query Design Center
-
- Starting Query Design Center
- Using the Menu Bar
- Setting the Look and Feel of the Interface
- Determining Connection Status
- Opening Tables
- Viewing Table Results
- Viewing Column Results
- Preparing and Executing a Query
- Saving and Restoring Permissions
- Saving a Query
- Saving Query Results
- Opening a Query
- Enabling Manual Commit Mode
- Setting Transaction Isolation Levels
- Creating a Savepoint
- Rolling Back to a Savepoint
- Setting the Row Limit
- Generating a QGraph
- Generating a QDump
- Command Line Interface
- Using Relational Design Center
-
- 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
- Query Processor Server Administration
-
- Configuring Query Processor Server Resources
- Preparing a Database to Be a Resource
- Controlling the Query Processor Server
- Automating Query Processor Server Initialization
- Obtaining Query Processor Server Status
- Viewing Server Log Information in the MCP Environment
- Viewing Trace Information on the Server
- Retrieving Dump Files
- Obtaining Log and Trace Information using MCPSQL Diagnostic Software
- Query Processor Configuration Control Facility
- Using the Schema Administrator
- Using the DMQUERY Utility
- Using the Loader Utility
- Using Stored Procedures
- Permissions—Assigning Access Rights to Database Structures
- Configuring Kerberos Authentication for Java in the Windows Environment
- Configuring Secure Communications
- Troubleshooting
- Query Processor Performance Guidelines
