JR31437: WHEN INSERTING NULL INTO NUMERIC FIELD, ENCOUNTER ERROR WITH PRECISION.

APAR status

• Closed as program error.

Error description

• When trying to insert NULL into numeric field, the job log
  reports error ORA-01438: value larger than specified precision
  allowed for this column. Customer is running z/OS Linux
  Information Server 8.0.1
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  all platforms.
  ****************************************************************
  PROBLEM DESCRIPTION:
  This problem stems from give a NULL string expression for
  INTEGER varaible/
  But these are binary values and we can not give character
  expression here.
  
  ****************************************************************
  RECOMMENDATION:
  Use patch from Unified source code.
  ****************************************************************
  

Problem conclusion

• In Unified code we are not loading nullable INTEGER  values
  using loader type iNTEGER. We use packed decimal type.
  The field can be a BLANK to load a NULL. The BLANK field is not
  a legal decimal value anyway.
  

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

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R801 PSN

     UP