ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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


Article ID: 20102


Updated On:


RC Compare for DB2 for z/OS



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.


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.


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