JR31960: PROBLEM WITH IS 8.0.1 AIX LOOKUP STAGE NULL HANDLING

APAR status

• Closed as program error.

Error description

• Incorrect warning EXAMPLE: When binding input interface field
  "FIELD"
  to field "FIELD": Converting a nullable source to a non-nullable
  result; a fatal runtime error could occur;
  use a modify operator to specify the value to which the null
  should be converted.
  
  This warning is wrong because the field definition in the lookup
  stage is nullable on both sides (input and output). It seems
  that the error results from the Lookup-stream where the matched
  field is defined NOT
  NULL
  

Local fix

• This fix is included in 8.0.1 fixpack 3
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Users of parallel lookup in any version of IS
  ****************************************************************
  PROBLEM DESCRIPTION:
  by the user when an input key column in  nullable and the
  matching lookup key column is not.
  ****************************************************************
  RECOMMENDATION:
  Install patch JR31960
  This change is included in 8.1 Fix Pack 1.
  ****************************************************************
  

Problem conclusion

• Fixed lookup to handle this correctly as there should be no
  warning in this case.
  

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

• SERVER
  

Fix information

• Fixed component name

  INFO SRVR PLATF

• Fixed component ID

  5724Q3612

Applicable component levels

• R801 PSN

     UP