JR37032: FIELD COMING FROM TERADATA CONNECTOR WAS RETURNED AS NULLABLE IN VERSION 8.0.1 BUT AFTER UPGRADE TO 8.1 FIELD IS NOT NULLABLE

APAR status

• Closed as program error.

Error description

• The job uses Teradata connector as a source. The column is
  actually non-nullable in Teradata database, but the column is
  overridden in the DataStage job to be nullable. In DataStage
  version 8.0.1 where this job was designed, the connector
  framework would correctly choose the nullable attribute as
  taking precedence when reconciling the metadata difference. In
  8.1, the connector framework now incorrectly reconciles the
  column to not-nullable.  This causes significant problems in
  downstream job stages which are expecting null values to be
  present or not present as the job logic dictates, resulting in
  incorrect output that can be hard to detect.
  

Local fix

• A modify, transform or copy stage can be inserted immediately
  after the teradata connector stage to re-map the column to be
  nullable.
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  ALL
  ****************************************************************
  PROBLEM DESCRIPTION:
  When a database connector selects from a non-nullable
  CHAR/VARCHAR column into a nullable Char/VarChar field of equal
  length, the connector framework's schema reconciliation returns
  the field as non-nullable which is a change in behavior from
  8.0.1.
  ****************************************************************
  RECOMMENDATION:
  Install the patch for JR37032.
  ****************************************************************
  

Problem conclusion

• The connector framework's schema reconciliation now returns the
  field as nullable as it was in 8.0.1.
  

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

• ENGINE
  

Fix information

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R810 PSN

     UP