Is there a CHANGE ALL command available when editing a freeform query?

Document ID : KB000018179
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

In many cases, a freeform query is lengthy and requires changes to the SQL. TSO ISPF has a CHANGE ALL command that will change alloccurrences of a selected string.

Solution:

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 needto be imported back into Report Facility.