JavaScript is disabled on your browser. Please enable JavaScript to enjoy all the features of this site.
Relational Database Server for ClearPath MCP Query Processor Installation and Operations Guide
Using the DMQUERY Utility
Sidebar
Prev
|
Next
Using the DMQUERY Utility
Table of Contents
What Is the DMQUERY Utility?
Using DMQUERY Utility Commands
BYE
CANCEL
CLOSE
COMMIT WORK
DEFINE
DIAGNOSE
DO
OPEN
PARSE
QD
REPEAT
ROLLBACK WORK
SAVEPOINT
SET
SHOW
Running the DMQUERY Utility Interactively Through CANDE
Running the DMQUERY Utility in Batch Mode
DMQUERY Utility Files
Contents
Search
Overview
Documentation Updates
What's New?
What Is Query Processor?
Installing Query Processor
Hardware and Software Requirements
Hardware Requirements
MCP Environment Software Requirements
Windows Environment Software Requirements
Linux Environment 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
Tree View
Properties View
Opening Tables
Viewing Table Results
Viewing Column Results
Text Pane
Results Pane
Analyze Query Window Commands
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
Default Properties
Enabling Trace
Command Line Interface
Overview
Argument Examples
Sample Output
Using Relational Design Center
Starting Relational Design Center
Understanding the Relational Design Center Interface
Tree View
Properties View
User Assistance View
Output View
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
Adding a Server
Removing a Server
Importing a Relational Schema
Creating a SQL Database
Working with Databases
Opening a Database
Removing a Database
Refreshing a Database
Restoring a Database
Getting the SQL Schema
Saving the Schema
Loading a Schema
Applying Schema Modifications
Modifying an SQL Database
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
Default Properties
Enabling Trace
Query Processor Server Administration
Configuring Query Processor Server Resources
Preparing a Database to Be a Resource
Controlling the Query Processor Server
Starting and Stopping the Query Processor Server
Obtaining Help Information
Automating Query Processor Server Initialization
Initiating the TCP/IP Configuration
Obtaining Query Processor Server Status
Viewing Server Log Information in the MCP Environment
Identifying the Server Log
Understanding Server Log Contents
Viewing Trace Information on the Server
Diagnostic Trace
Identifying the Trace File
Enabling the Trace Facility
Closing Trace Files Automatically
Retrieving Dump Files
Identifying the Dump File
Displaying the Dump File
Obtaining Log and Trace Information using MCPSQL Diagnostic Software
Modifying the MCPSQL/CONFIG File
Creating an Initialization File
Obtaining SQL Statements Querying the MCPSQL Database
Query Processor Configuration Control Facility
Using the Query Processor Configuration Control Facility
Understanding the Query Processor Configuration File
Creating the Query Processor Configuration File
Release Specification
User Specification
Program Specification
Default Release Specification
Resource Specification
Using the CCS Clause
Using the Limit Clause
Setting a Default Release Limit
Limit Clause Enforcement
Sample Query Processor Configuration Files
Using the Schema Administrator
Ensuring Description File and Control File Accessibility
Reviewing the Results File of a SQLVIEW Command Generation
Viewing the Schema
Using the Schema Administrator Input File
Manually Enabling SQL Access to an Enterprise Database Server Database
Generating the SQL Descriptions
Listing the Description
Using the DMQUERY Utility
What Is the DMQUERY Utility?
Using DMQUERY Utility Commands
BYE
CANCEL
CLOSE
COMMIT WORK
DEFINE
DIAGNOSE
DO
OPEN
PARSE
QD
REPEAT
ROLLBACK WORK
SAVEPOINT
SET
SHOW
Running the DMQUERY Utility Interactively Through CANDE
Running the DMQUERY Utility in Batch Mode
DMQUERY Utility Files
Using the Loader Utility
What is the Loader Utility
Running the Loader Utility
Setting Up the Configuration File
Rules and Filters
Writing Rules
Writing Filters
Setting Up the Data File
Output Files
Using Stored Procedures
Permissions—Assigning Access Rights to Database Structures
Common Constructs
GRANT
REVOKE
LIST PERMISSIONS
Saving and Restoring Permissions
Configuring Kerberos Authentication for Java in the Windows Environment
Configuring Secure Communications
Configuring Secure Connections in the Windows Environment
Enabling Secure Connections for Query Processor
Disabling Secure Connections for Query Processor
Troubleshooting
Limitations and Restrictions
Case-Sensitive Passwords
Troubleshooting Kerberos Login Connection
Issues with Third-Party SQL Tools
Microsoft Access
Microsoft Query for Excel 2016
Oracle SQL *Plus and Oracle SQL Developer
Warning Messages
Error Messages
Query Processor Performance Guidelines
Search Highlighter (On/Off)
