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

Document ID : KB000020102
Last Modified Date : 14/02/2018
Show Technical Document Details


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.