The Queries view displays the predefined queries that are supplied with the CICS® IA plug-in, any queries that you have created and saved, and any query results that you have saved. You can create, edit, or run a query, and organize queries and their results into folders and subfolders.
When you create a query, you can query any resources in any combination. You can add filters to the query to refine the results, and you can define the structure of the results that are displayed in the Resources view. You can modify existing queries, whether they are supplied predefined queries or queries that you created.
When you run a query, you can save the search results in a list under the query name in the Queries view for future reference. Queries are saved to your workspace, which is defined when you install the product. You can modify the workspace location at any time when running CICS Explorer®.
Before you create a query, click the name of the folder where you want to save the new query. You cannot move a query after it is saved.
To create a new folder, click the name of the parent folder for the new folder. Then either click Valid query and folder names.
in the toolbar menu, or right-click then click . A new folder is created with the name New folder. To rename the folder, type over this name, ensuring that you use valid characters. For more information, seeTo copy the definition of a query to the clipboard, select the query, right-click, then click Copy. You can then paste the definition into the same folder, or a different folder, in the Queries view. You can also paste the query definition into a text editor and view the SQL strings that are run against the database tables. This feature is useful if you want to use your own methods to run SQL and collect results.
To run a query, select the query, right-click, then click Run. The results of the query are shown in the Show Resources view view. The name of the query is displayed in the toolbar of the view. If a CICS query includes the Collection ID and a specific collection ID is set as the current scope, this scope is also displayed in the toolbar.
To save the query results and list them under the query name in the Queries view, click Valid query and folder names.
in the toolbar menu. The Save query results window is displayed, where you can enter a suitable description for the results. Ensure that you use valid characters; seeIn the following example, the query results are named Before Fix 123456 applied.
The query results description, together with the data and time that the query ran, is listed as a child of the query in the Queries view. In the following example, the data for the query result Before Fix 123456 applied is listed as a child of the All programs using files query.
To copy a set of query results to the clipboard, right-click the required results, then click Copy. You can then paste the data into a spreadsheet or other tools for analysis.
To open a set of query results and view the data that was saved in the Show Resources view, right-click the required results, then click Run.
If you open a different query result, a similar query runs on different dates. You can compare different query results to see what has changed and build up a picture of change over time. For more information, see Comparing resources.
You can delete individual query results. If you delete a query, all of its query results are also deleted.