Perform the following steps to start Query Design Center:
-
On the Start menu, point to Programs, Unisys MCP, and Query Processor for ClearPath MCP Utilities, and then click Query Design Center.
The Open Connection dialog box appears.
-
Perform one of the following actions:
-
Type your log-in credentials without a resource name, and click OK.
Refer to “Usercode and Password Conventions” later in this section for details on specifying your usercode and password.
The Resources window is displayed.
-
Type your log-in credentials including a resource name, and click OK.
Refer to “Usercode and Password Conventions” later in this section for details on specifying your usercode and password.
The Analyze Query window is displayed.
Notes:-
To authenticate log-in credentials using your ClearPath MCP usercode and password, select the MCP option in the Authentication list and type your log-in credentials.
-
To authenticate log-in credentials using Kerberos credentials, select the Kerberos option in the Authentication list.
To encrypt your Kerberos credentials, select the Encryption option in the Encryption list.
-
If only read access is allowed on the database, select the Read Only check box. The ReadOnly property in the qdc.properties file controls the default setting of this option. The value 1 indicates read-only access.
-
-
-
Proceed with your work as desired.
Usercode and Password Conventions
The usercode can consist of usercode, accesscode, and chargecode combinations as shown in the following syntax. Accesscode and chargecode requirements are defined by your system administrator.
──<usercode>─┬──────────────────────────────────────┬──────────────────┤
├─ /<accesscode>───────────────────────┤
├─ /<chargecode>───────────────────────┤
└─ /<accesscode>/<chargecode>──────────┘The password can consist of a password and an optional accesscode password as shown in the following syntax:
──<password>─┬────────────────────────────┬────────────────────────────┤
└─ /<accesscode password>────┘