PH04971: PROP OF VARCHAR INVALID VALUE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Customer is performing Column Map processing involving the use
  of the PROP function on a VARCHAR or VARGRAPHIC column.
  The related tables receive the PROPed value and it may be
  incorrect.
  
  This is a SYSROUTE of B30 APAR PH04970.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Optim for z/OS users.                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. Customer is performing Column Map    *
  *                      processing involving the use of the     *
  *                      PROP function on a VARCHAR or           *
  *                      VARGRAPHIC column.                      *
  *                      The related tables receive the PROPed   *
  *                      value and it may be incorrect.          *
  *                      2. Customer is performing Column Map    *
  *                      processing involving the use of the     *
  *                      PROP function. The PROP has been        *
  *                      specified on a CHILD table which        *
  *                      follows the PARENT table in the         *
  *                      processing order.                       *
  *                      The value in the affected PARENT column *
  *                      becomes invalid and the user is not     *
  *                      being informed that the PROP could not  *
  *                      be processed                            *
  *                      because of the processing order of the  *
  *                      tables.                                 *
  ****************************************************************
  * RECOMMENDATION: Apply the provided fix.                      *
  ****************************************************************
  1. The PROP logic is incorrect processing VARCHAR and VARGRAPHIC
  values.
  2. PROP processing lacks logic to detect inconsistent value
  propagation resulting from the table processing order.
  

Problem conclusion

• Optim processing logic will be corrected.
  The following PROP function processing enhancements will be
  implemented by this APAR:
  
  1. The PARENT tables will no longer receive a default value
  (from the child table PROP column). Note that this is a change
  in the existing product behavior.
  2. When a table (column) participating in a propagation set does
  not receive a value resulting from the PROP source value table
  (column) because of the table processing order then such missing
  value will be recognized as PROP processing error and result in
  a processing error and return code being set to 12.
  The following error message will be found in the
  PROCESSING report:
  
  Value PROPAGATION between related tables was incomplete. Inspect
  the Column Map Value PROPAGATION SETS below.
  
  3. The PROPAGATION sets used by the process will then be listed
  following the Column Map report. They will be annotated with
  the following comments:
  
  Note: * next to the Column Name above indicates the column
          providing the PROP value for this set.
       ** next to the Column Name above indicates a table which
          did not receive a value during PROP processing because
          such value was not available due to the table processing
          order.
          A change in the order of tables in the AD of the EXTRACT
          or ARCHIVE file may be required.
  
  4. When the propagation error occurs then the REPORT_LEVEL will
  be forced to DETAIL to allow for Column Map and PROP set listing
  irrespective of the REPORT_LEVEL specified for the process.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

• FOP00003 FOP00103 FOP00203 FOP00303 FOP00B   FOP01B   FOP05B
  FOP07B   FOP08B   FOP09B   FOP0AB   FOP0BB   FOP0ITKA FOP1ODRV
  FOP1OSFN FOP3DTPR FOP4IPMN FOP4PEMN FOP4PMMN FOP4TRCE FOP9APIM
  FOP9GINF FOPCFPMN FOPCXLIB FOPD2V85 FOPD2V91 FOPD2VA5 FOPD2VNN
  FOPHSTM  FOPIO    FOPK03   FOPK05   FOPK10   FOPLUAH  FOPMADDE
  FOPMAFCN FOPMAIN  FOPMAMAI FOPMARCN FOPMCBMN FOPMCDRT FOPMCENU
  FOPMCMAI FOPMCMMN FOPMCOFN FOPMCOLA FOPMCOLP FOPMDBMN FOPMDDDL
  FOPMDMAI FOPMDPRC FOPMDXTR FOPMECMN FOPMEMAI FOPMIXMM FOPMMCMN
  FOPMMCMR FOPMMJBS FOPMMUNU FOPMMUTL FOPMSELM FOPMTMDB FOPMUXIM
  FOPODPP  FOPOMN   FOPRS10  FOPRS8   FOPRS9   FOPUMCBT FOPUUNLD
  FOPVOU   FOPZFBMN FOPZFMMN FOPZMAIN FOPZSUB
  

Fix information

• Fixed component name

  OPTIM MOVE FOR

• Fixed component ID

  5655V0700

Applicable component levels

• RB70 PSY UI60408

     UP18/12/22 P F812

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.