Selecting and viewing data

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.

Note: To display the data in the Sheet view, Link to Selection The Link to Selection icon controls the display of data in the Sheet view when a selection is made in the Records view. must be selected.

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.

Displaying data from a database

The Records view shows a list of all the application IDs and tranasaction IDs in the data. You can restrict the number of records in the list by selecting one or more IDs from the lists. Multiple selections can be made by holding down the Ctrl key. There are several tools supplied with the CICS PA plug-in that you can use to limit the amount of data in the sheet view. For more information, see Refining the data selection