JR58102: CONNECTOR STAGE NULL VALUE WITH NOT NULLABLE BEHAVIOR

APAR status

• Closed as program error.

Error description

• When customer runs the job with a row that has a null value
  ina column which is not nullable within the database, they
  expected to see an entry in the job log indicating the db2
  error of 'Assignment of a null value to a not nullable column
  is not allowed'.Instead though, all that happens is the job
  aborts and a generic logentry
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Users developing jobs on Server canvas, storing data with DB2
  connector. When input data is targetting table that is defined
  as CHAR (x) NOT NULL and the input data might be NULL the issue
  might occur
  ****************************************************************
  PROBLEM DESCRIPTION:
  While working on Server canvas it is possible to pass the NULL
  value within the column that is defined as NOT NULL. Such
  behavior is possible only in Server jobs, as Parallel jobs are
  more strict while checking data types. In case of Server jobs,
  when the column is defined as CHAR(x) and the value to insert is
  NULL, DB2 Connector is creating an x-character long string of
  spaces. Effectively, INSERT SQL statement is successful, even
  though the column in DB2 is defined as NOT NULL.
  ****************************************************************
  RECOMMENDATION:
  Install patch JR58102
  ****************************************************************
  

Problem conclusion

• After the fix, an attempt is made to INSERT the NULL value which
   results in SQL error. Input row is not inserted in the
  database. Warning is visible in job log indicating SQL statement
   execution failure.
  

Temporary fix

• n/a
  

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

• RB50 PSY

     UP