Does the RCM IBM Unload (IBMULD) model support a 'Where' clause based on an EQF in RC/Migrator
Article ID: 200029
Updated On:
Products
Issue/Introduction
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
STRATEGY ===> MIGEMP5 DESCRIPTION ===> TEST SELECT A FEW ROWS
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?
Environment
Release : 20.0
Component : RC/Migrator for DB2 for z/OS
Resolution
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
Feedback
