JR31129: DATASTAGE 7.5.1A ISVALID PARALLEL FUNCTION IS NOT WORKING FOR TYPE INT64 WHEN THE VALUE IS GREATER THAN THE MAXIMUM VALUE

APAR status

• Closed as program error.

Error description

• DataStage 7.5.1A: IsValid parallel function is not working for
  type
  Int64 when the value is greater than the max value for Int64
  
  The IsValid parallel function is not working for type Int64 when
  the value passed in is greater than the maximum value for Int64.
  
  For example:
  
  IsValid ("Int64", 9999999999999999998)  returns 1 (True).
  
  
  The Int64 value type represents integers with values ranging
  from negative 9,223,372,036,854,775,808 through positive
  9,223,372,036,854,775,807.  Therefore the value passed in is not
  a valid Int64 value.  In this case IsValid should return false.
  
  If you pass in a non-numeric character to the IsValid function
  for type Int64 it will correctly return false in that case.
  
  For example:
  
  IsValid ("Int64", "=") returns 0 (False).
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Parallel jobs utilizing the Transformer Stage's IsValid()
  function to check the validity of an INT64 type.
  ****************************************************************
  PROBLEM DESCRIPTION:
  When using the IsValid function in the Transformer stage,
  invalid results are returned for values outside the range of an
  INT64 type.
  ****************************************************************
  RECOMMENDATION:
  Apply patch JR31129
  This change is included in 8.1 Fix Pack 1.
  ****************************************************************
  

Problem conclusion

• Resolution was to correct the function that checks for range
  validity - added a missing check for INT64 types.
  

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

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R751 PSN

     UP