When you have connected to the database, or loaded the CSV data into the CICS® PA plug-in, you can select and view all of the data, or a subset, as a spreadsheet in the CICS PA Sheet view. You can also copy and paste this information into a spreadsheet application, for example Microsoft Excel.
If the CSV data is not yet loaded into the CICS PA plug-in, or you have not connected to a database, follow the steps in the task Connecting to a database, or Loading CSV data, before continuing.
The Records
view shows a list of all the APPLIDs and Transids in the data. If
your data spans a large date range you can restrict the data to view
by using the Date-time selection dialog .Click the Dates
tooltip icon. in the Records view to display the
Date-time selection dialog and select the date range to analyze, as
shown in the following screen capture.
The Date-time selection dialog displays highlighted dates. However, these dates are not used unless Records after and Records before check boxes are selected. When these check boxes are not selected, data for all dates within the system are displayed. You must check the Records after and Records before check boxes to use these dates.
When you have selected the date range and clicked OK, a list of the APPLIDs in the date range is displayed in the Records view. When you select one or more APPLIDs, the resulting data is shown in the Sheet view.