You can use Transaction Analysis Workbench to save data from any
supported log record type to a comma-separated values (CSV) file. You can use the CSV file with
other applications, such as PC-based spreadsheet applications. A CSV file created by Transaction Analysis Workbench contains selected fields from a single log record type and
code.
Before you begin
Before using the Transaction Analysis Workbench ISPF dialog to create
a CSV file from log files in your ad hoc list, you must define a form
for the corresponding log record type and code.
About this task
The procedure described here uses the Transaction Analysis Workbench ISPF dialog to generate
JCL that invokes the CSV command of the Transaction Analysis Workbench report and extract
utility.
The ISPF dialog generates JCL that uses only a subset
of the features of the CSV command. To use other
features of the CSV command, edit the generated
JCL or write your own JCL.
Procedure
- On the Transaction Analysis Workbench Primary
Option Menu, select
option 4
.
Your personal ad hoc list of log files is displayed.
- If the list does not already include the log files that
you want to process, insert those log files now.
For details on inserting log files, including log streams, on this panel, see
Browsing logs in your personal ad hoc list.
You can create a CSV file
either from one or more data sets, or from a single log stream. You cannot create a CSV file from a
mix of data sets and log streams, or from multiple log streams.
- Type SUB next
to one or more log files, and then press Enter.
The Submit
Batch Request window opens.
- Optionally, specify filtering criteria and an interval
to extract only matching records.
- Select CSV, and then specify the
details of the CSV file, including the name of the form that specifies
the type of log record and the fields that you want to save to the
CSV file.
The panel suggests a data
set name based on a template that you specify in ISPF dialog option 0.3
.
- Press Enter to generate the JCL for the request.
The
JCL is displayed in an edit panel.
- Submit the job: enter SUB on the command
line.
- Press the the Exit function
key (F3) to
exit the edit panel.
- Use your site-specific procedures to view the job output.