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

Article Id: 20102

Status: Published

Updated On: 21-03-2018 07:16

Legacy Id: TEC597915

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: