Creating Structured Inquiries

Creating a structured inquiry is easy. You tell MICF that you are about to create an inquiry. Name the inquiry and assign it to a catalog group. Next you define the steps that make up the inquiry. You can cancel, save, or execute the inquiry. If you decide to execute the inquiry before saving it, you will have an opportunity to cancel, save, or modify it after execution.
micsrm140
Creating a structured inquiry is easy. You tell MICF that you are about to create an inquiry. Name the inquiry and assign it to a catalog group. Next you define the steps that make up the inquiry. You can cancel, save, or execute the inquiry. If you decide to execute the inquiry before saving it, you will have an opportunity to cancel, save, or modify it after execution.
Note:
If you have not done so already, we recommend that you invoke MICF and actually create some test inquiries as you read the rest of this section.
To create a direct inquiry, select option 2, Database Inquiries, from the Primary MICF Menu (see Panels, Menus, and Commands for details). This menu takes you to the Database Inquiries panel. Enter the line command I (Insert) on any line in the Cmd column. The Insert Database Inquiry panel displays.
On this panel, you can specify the inquiry name (one to six characters), title, and author. Defaults are provided. You can override these defaults. The catalog group name and title are copied from the information that applies to the line on which you entered the I. If you want to change either of them, you can do so here.
Note:
If you want to change any of the information about this panel later, make a copy of this panel first.
Since you are creating a structured inquiry, specify option 2 on the Command line at the top of the Insert Database Inquiry panel. The Structured Inquiry selection panel displays.
MICF Inquiry Step Display
------------------------- MICF Inquiry Step Display ------------------------- Command ===> Scroll ===> CSRModifying CA MICS Inquiry: TSOLD1 - Daily TSO User Ranking Reports Execute ===> N (Y/N) Execution Mode ===> BATCH (BATCH/FOREGROUND) Line Cmds: S Select I Insert D Delete M Move R Repeat C Copy Cmd Inquiry Step Input File - ------------------------------------------------------------ ----------- _ CA MICS File Selection DAYS TSU _ Common Data Selection - Select Previous Day FILE1 _ Execution-Time Data Selection - Select SYSID FILE1 _ Execution-Time Data Selection - Select ZONE FILE1 _ Execution-Time Data Selection - Select HOUR FILE1 _ Data Element Derivation - Compute TSOPCSR FILE1 _ Ranking Report - Top 5 Resource Consumers by Hour FILE1 _ Ranking Report - Top 5 Throughput by Hour FILE _ Execution-Time Data Selection - Restrict for Resp. Ranking FILE1 _ Ranking Report - Worst 5 Response by Hour FILE1 ****************************** BOTTOM OF DATA *********************************
Note:
If you had selected an existing structured inquiry and were in the MODIFY mode, you would see the MICF step display panel for that inquiry. The step display panel lists each of the steps in the inquiry See MICF Inquiry Step Display. It is created automatically as you define a structured inquiry. You can add more steps to an inquiry by using the I (Insert) line command. The Structured Inquiry Menu displays.
Structured Inquiry Menu
----------------------------- Structured Inquiry --------------------------- Option ===> Composing CA MICS Inquiry: SI1 - Sample Structured Inquiry- 1 - CA MICS File Selection Specify CA MICS File, Timespan, and Database for inquiry input. 2 - Data Extract Extract CA MICS data to CSV files or CA-DATACOM tables. 3 - Color Graphics Structured inquiry functions for color graphics output. 4 - Printed Reports Structured inquiry functions for printed reports. 5 - Printer Graphics Structured inquiry functions for printer graphics output. 6 - Statistical Analysis Structured inquiry functions for statistical analysis. 7 - Data Manipulation Subset, summarize, and/or enhance the input file. 8 - Full Screen SAS Processing Process the input file with the SAS Full Screen Product (FSP). 9 - Inquiry Function Catalog Display Display a scrollable list of MICF inquiry functions
Option 1
MICS
File Selection on this menu is similar to the
MICS
files selection operation described in Creating Direct Inquiries. The major difference is that this option is a stand-alone function when creating structured inquiries, not part of the report definition panel.
Option 2
This option lets you extract
MICS
data to CSV files and
Datacom
tables.
Options 3, 4, 5, and 6
These options are detailed in Selecting Reports.
Option 7
This option provides several optional data manipulation tools that let you subset, sort, and summarize files. In addition, you can add elements to the data in a file, combine files, and change data element labels and formats.
Option 8
Full Screen SAS Processing, lets you use the SAS Full Screen Product to browse and edit intermediate files.
Option 9
Inquiry Function Catalog Display, is a scrollable list of all the MICF features you can reach from the other options on this panel.
Follow these steps: