View an EQF (Extended Query Facility) WHERE clause that was saved in a migration strategy

Products

• RC/Migrator for DB2 for z/OS
• RC Compare for DB2 for z/OS

Issue/Introduction

When creating a RC/Migrator for Db2 for z/OS (RCM) migration strategy there is an option, EQF (Extended Query Facility), to create and save a WHERE
clause when specifying the Primary Object Selection. Once created and saved, this WHERE clause in the EQF, how can it be viewed along with others created.

Resolution

Create a new Create Migration Strategy and get to the Create Migration Strategy screen...

The EQF's are stored based on the object type that is being selected as the primary object.

Select with an "S" the object type and in the 'Where' option type a 'S' and a Query List will be displayed.

The sample below is finding EQF's created for DATABASE objects. This is because each EQF has a SQL query that will access the appropriate DB2 Catalog table in question.

For Database objects it will be SYSIBM.SYSDATABASE

---------------- RC/M Create Migration Strategy --------------- yy/mm/dd hh:mm
COMMAND ===>

Strategy ===> TEST        Description  ===>
Creator  ===> authid1     Share Option ===> U (U,Y,N,X,L)   SRC SSID ===> ssid
-------------------------------------------------------------------------------

PRIMARY OBJECT TYPE SPECIFICATION. ( Select one type with 'A' , 'S', or 'E' )
        _ Storage Group
        s Database
        _ Tablespace
        _ Table
        _ Materialized Query Table
        _ Index
        _ View
        _ Synonym/Alias
        _ Trigger
        _ Routine
        _ Sequence

PRIMARY OBJECT SELECTION SPECIFICATION.
 Name ==> *                   >  Creator ==> *         > Where ==> s

.
.
Pre existing queries of the object type DATABASE are displayed.
.

20.0   -------------------- Query List -------------------  yyyy/mm/dd hh:mm
Command ==>                                                   SCROLL ===> CSR

   Name ==> *             Creator ==> *             For Panel: RMDATABS
                                                                             >
------------------------------------------------------------------------------
  NAME       CREATOR  DESCRIPTION                    SHARE DEFAULT
_ ________   authid1  ______________________________ _ N    _ N <= CREATE NEW
_ TEST1      authid1  Test EQF one                     N    _ N
_ TEST2      authid1  Test EQF two                     N    _ N
******************************* BOTTOM OF DATA ********************************

With the Query List displayed, the options are 'S' - Select the query for execution. 
                                               'Y' - Edit the query 
                                               'D' - Delete an existing query

Additional Information