PM73656: SQL CAPTURE ISSUES ASN0552E WITH SQLCODE310 AFTER ALTER TABLE TO ADD NOT NULL DECIMAL COLUMN.

APAR status

• Closed as program error.

Error description

• SQL capture issues ASN0552E with sqlcode310 after alter table
  command to add a not null decimal column.
  

Local fix

Problem summary

• SQL capture may issue sqlcode310 when a decimal not null is
  added to the cd table via alter add command.
  

Problem conclusion

• The logic to insert into the CD table did not handle default
  decimal values correctly.
  

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

• ASN
  

Fix information

• Fixed component name

  WS REPLICATION

• Fixed component ID

  5655L8800

Applicable component levels

• R910 PSY

     UP