Editing, Copying, and Deleting Composite Queries
Use the Edit, Copy, and Delete links in the Composite Query Manager search page (PSCPQSRCH) to edit, copy, and delete existing composite queries.
Navigation
Image: Composite Query Manager search page
This example illustrates the Composite Query Manager search page, including the Edit, Copy, and Delete links.
To edit composite queries:
Select Reporting Tools, Composite Query, Composite Query Manager.
The Composite Query Manager search page appears.
Click the Search button.
A list of existing composite queries appears.
Click the Edit link for the composite query that you want to edit.
The Composite Query Manager page appears. From this page, you can edit the composite query by adding base queries, defining prompts and expressions, applying aggregate functions, and so on.
Image: Composite Query Manager page
This example illustrates the Composite Query Manager page, where you can edit the composite query.
To delete composite queries:
Select Reporting Tools, Composite Query, Composite Query Manager.
The Composite Query Manager search page appears.
Click the Search button.
A list of existing composite queries appears.
Click the Delete link for the composite query that you want to delete.
A delete warning message appears.
Image: Delete warning message
This example show the delete warning message when you delete a composite query.
Click the OK button to confirm that you want to delete the selected composite query.
The Composite Query Manager search page reappears, displaying a delete confirmation message.
Use the Copy Composite Query page (PSCONQRSCOPY) to copy the composite queries.
Image: Copy Composite Query page
This example illustrates the fields and controls on the Copy Composite Query page.
Steps Used to Copy Composite Queries
To copy composite queries:
Select Reporting Tools, Composite Query, Composite Query Manager.
The Composite Query Manager search page appears.
Click the Search button.
A list of existing composite queries appears.
Click the Copy link for the composite query that you want to copy.
The Copy Composite Query page appears.
Enter a unique name, set the status, and select the type for the target composite query.
Optionally, modify the query description and comment for the target composite query.
Click the Save button.
The Composite Query Manager search page appears, listing the cloned composite query along with other existing composite queries.
Composite Query is a managed object that can be copied between databases using database project. To copy a composite query between databases:
Use Application Designer to create a project.
Insert a Composite Query definition into the project.
Copy the database project (that has the Composite Query definition) between databases.
Note: Database projects that have the Composite Query definitions can also be exported to or from file and imported to or from file.
Image: Application Designer - Insert into Project dialog box
This example illustrates Application Designer - Insert into Project dialog box. Composite Query is one of the definition types.
