Is there a Report Facility CHANGE ALL command available when editing a freeform query
search cancel

Is there a Report Facility CHANGE ALL command available when editing a freeform query

book

Article ID: 18179

calendar_today

Updated On:

Products

Report Facility

Issue/Introduction

In many cases, a Report Facility (PRF) freeform query is lengthy and requires changes to the SQL. TSO ISPF has a CHANGE ALL command that will change all
occurrences of a selected string.

Resolution

Report Facility does not have a CHANGE ALL command similar to TSO ISPF. Report Facility users have to issue the "TO" command.
The TO command lets you copy a generated SQL query to a sequential or partitioned data set for export to SPUFI or another program.
Once the dataset is created the CHANGE ALL command can be issued in ISPF EDIT. Once the changes are made, the Query will then need
to be imported back into Report Facility.