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

book

Article ID: 18179

calendar_today

Updated On:

Products

CA RC/Migrator CA Endevor SCM Interface DB2 Administration CA RC Compare for DB2 for z/OS CA RC Extract for DB2 for z/OS CA RC/Query CA RC Secure for DB2 for z/OS CA RC Update for DB2 for z/OS CA Compile/PRF for CICS and TSO CA Report Facility CA Database Analyzer for DB2 for z/OS CA Fast Unload for DB2 for z/OS CA Fast Check for DB2 for z/OS CA Fast Index for DB2 for z/OS CA Fast Load for DB2 for z/OS CA Rapid Reorg for DB2 for z/OS

Issue/Introduction

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.

Environment

Release:
Component: BIPRF