The Analyze Query window enables you to
-
Interrogate and update data in a database using SQL syntax and semantics.
-
Experiment with the Query Processor call-level interface (CLI) without having to write a COBOL or ALGOL program.
-
Obtain diagnostic information about queries for purposes of optimization and to send to Unisys support for analysis.
-
Use different character sets than the ClearPath MCP coded character set.
-
Control the access rights to the database for users by defining permissions.
Through the Analyze Query window, you can enter and execute the following SQL statements and view their results:
-
CALL
-
DELETE
-
INSERT
-
SELECT
-
UPDATE
You can also enter the following permissions commands to control access rights to the database:
-
GRANT
-
REVOKE
-
LIST PERMISSIONS
For information on how to specify permissions, see
You can also enter commands to dynamically alter the schema of a database as described in Section 2 of the Relational Database Server for ClearPath MCP Query Processor Programming Guide.
The Analyze Query window has two panes: a text pane and a results pane.
