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.

CA RC/Migrator for DB2 for z/OS (RCM): Does the RCM IBM Unload (IBMULD) model support a 'Where' clause based on an EQF?


Article ID: 200029


Updated On:


Database Management for DB2 for z/OS - Administration Suite RC/Migrator for DB2 for z/OS


 A Migration Strategy is created using an EQF (Extended Query Facility) to unload a subset of records based on the EQF.  The EQF 'Where' is found on the Implode/Explode Services Screen.

          20.0   --------- RC/M Implode/Explode Services -------- yy/mm/dd hh:mm

 COMMAND ===>                                                  SCROLL ===> PAGE



 CREATOR  ===> authid                     SHARE OPTION ===> U (U,Y,N,X,L)            

 SRC SSID ===> ssid                            NEW OBJECTS  ===> N (U,Y,N)                

 ------------------------------------------------------------------ authid  < >


    + >-EXPL OPT-+ AUX RTN MQT SEQ      SECU ALL         NUMBER                       

 S      A   TG     IMP IMP IMP IMP   RI          RITY  ROWS    OF ROWS                  WHERE              

 _      A   A      _   _   _   _     _  _       _          _         _              ________              S MODELS__         

 ******************************* BOTTOM OF DATA ********************************


The Migration strategy is analyzed using the Exclusive Analysis Option 'D' to generate data only movement,  no objects.

The IBM Unload Utility model is used; IBMULD.  The generated analysis output does not include a 'where' clause in the unload parameters, why?


Release : 20.0

Component : CA RC/Migrator for DB2 for z/OS


RC/Migrator for DB2 for z/OS IBM Unload Model (IBMULD) does not support a 'Where' clause. 

Both the RBP(Batch Processor) Unload(UNLOAD) and CA Fast Unload(FUNLD) utility models do support an EQF being specified in the Strategy definition which generates a 'where' clause based on the EQF specified.  Change the unload utility model being used in the analysis to UNLOAD or FUNLD if the Where clause is needed by using the “X” line command when the model is updated, to activate UNLOAD or FUNLD.

Additional Information

Please refer to our documentation below for more detail:

Utilities referenced by the @Default Model ID

Extended Query Facility