PH38185: RATIONAL PROGRAMMING PATTERN 9.7.0 : NOT NULL WITH DEFAULT IS NOT GENERATED ON AN ALTER TABLE

Rational Programming Patterns Interim Fix 5 for 9.7.1
Rational Programming Patterns Interim Fix 11 for 9.7
Rational Programming Patterns 9.7.2
Rational Programming Patterns Interim Fix 15 for 9.6.2

APAR status

• Closed as fixed if next.

Error description

• In RPP 9.6.2, NOT NULL WITH DEFAULT is not generated
  on an ALTER TABLE
  
  Adding a dataelement DTESUF X(8) in dataagregate TA01,
  used in packblockbase MDCRAR.
  
  In -ce, specifying
  CMS456 = 'P ' to have NOT NULL WITH DEFAULT.
  
  In packblockbase MDCRAR,
  
  In -dr for an ALTER TABLE and for the generated DDL
  NOT NULL WITH DEFAULT is not generated
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All users using ddl generation                               *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * NOT NULL WITH DEFAULT is not generated on an ALTER TABLE     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

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:

Fix information

Applicable component levels

• R970 PSY

     UP

• R971 PSY

     UP