JR34851: WARNING MESSAGE GENERATED BY LOOKUP STAGE: CONVERTING A NULLABLE SOURCE TO A NON-NULLABLE RESULT.

Download Fix Pack 2 for InfoSphere Information Server Version 8.1

APAR status

• Closed as program error.

Error description

• IS 8.0.1 fixpack1 on AIX
  
  Warning Message:: lkp_po_nbr: When checking operator: On output
  data set 0: When binding output interface field "gl_cmp_key" to
  field "gl_cmp_key": Converting a nullable source to a
  non-nullable result; a fatal runtime error could occur; use the
  modify operator to specify a value to which the null should be
  converted.
  
  Reviewed the job design.  The source gl_cmp_key and target
  gl_cmp_key are both defined as not null.  The warning message
  seems to be wrong.
  

Local fix

• This fix is included in 8.0.1 fix pack 3
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  ODBC EE users are affected
  ****************************************************************
  PROBLEM DESCRIPTION:
  Warning message generated by lookup stage: Converting a nullable
  source to a non-nullable result.
  ****************************************************************
  RECOMMENDATION:
  Upgrade to IS 8.1
  ****************************************************************
  

Problem conclusion

• Fixed in 8.1 and later versions.
  

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

• R810 PSN

     UP