search cancel

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


Article ID: 18179


Updated On:


RC Compare for DB2 for z/OS Report Facility Database Analyzer for DB2 for z/OS Fast Unload for DB2 for z/OS Fast Check for DB2 for z/OS Fast Index for DB2 for z/OS Rapid Reorg for DB2 for z/OS



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.


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.


Component: BIPRF