How do I add a WHERE clause to my UNLOAD in a Migration Strategy?

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

Issue/Introduction

Description:

Creating a migration strategy requires that a WHERE clause be added to the UNLOAD of the data.
This information can be added in the Implode/Explode Services option of the strategy by specifying a name for the WHERE clause.

Solution:

On the RC/M Implode/Explode Services screen after scrolling to the right the following will display:

RMPLTB1  16.0 ------- RC/M Implode/Explode Services ------ 13/08/26 09:19
COMMAND ===>                                             SCROLL ===> PAGE
                                                                              
STRATEGY ===> D1344917       DESCRIPTION  ===>                          
CREATOR  ===> USERID01       SHARE OPTION ===> U (U,Y,N,X,L)             
SRC SSID ===> D91A           NEW OBJECTS  ===> N (U,Y,N)                 
------------------------------------------------------------- USERID01 

Under the WHERE heading, specify Y and a name for the WHERE clause...

  >-EXPL OPT-+ AUX RTN MQT SEQ      SECU ALL       NUMBER                         
S     S/A TG        IMP IMP IMP  IMP   RI RITY ROWS OF ROWS   WHERE                
_   _    _    _    _      _       _     _   _    _    ________   Y  W100

The Data Query Edit screen will then display on which your WHERE conditions can be specified.

Environment

Release: ENDV2A00200-14.5-Endevor-SCM Interface-for DB2 for z/OS
Component: