Table of Contents
- 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
This section describes the Query Design Center, which is an interactive tool that administrators and developers can use to design and execute ad-hoc SQL requests against the Relational Database Server for ClearPath MCP Query Processor. This tool makes it easy to design and execute queries against Enterprise Database Server and test these queries outside of user applications.
Using Query Design Center, you specify your solution in terms of joins, ordering, columns to display, and so on. You do not use SQL syntax. Query Design Center automatically builds the syntax of your queries based on your input through the Design Query window. However, if you are fluent in SQL, you can manually enter and execute SQL syntax using the Analyze Query Window.
Query Design Center also has a command line interface from which users can execute SQL script files. A SQL script can contain one or more SQL statements.
