JR34616: COMPILE FAILURE ON A LOOKUP STAGE WITH RANGE LOOKUP

Download Fix Pack 2 for InfoSphere Information Server Version 8.1

APAR status

• Closed as program error.

Error description

• Compile failure on a lookup stage with range lookup with
  following error messages.
  
  ##I IIS-DSEE-TFCN-00006 20:33:24(001) <main_program> conductor
  uname: -s=Windows_NT; -r=1; -v=5; -n=AA5074670; -m=Pentium
  ##I IIS-DSEE-TOSH-00002 20:33:24(002) <main_program>
  orchgeneral: loaded
  ##I IIS-DSEE-TOSH-00002 20:33:24(003) <main_program> orchsort:
  loaded
  ##I IIS-DSEE-TOSH-00002 20:33:24(004) <main_program> orchstats:
  loaded
  ##W IIS-DSEE-TOSH-00049 20:33:25(000) <main_program> Parameter
  specified but not used in flow: DSPXWorkingDir
  ##E IIS-DSEE-TOSH-00003 20:33:25(001) <main_program> Syntax
  error: Error in "transform"  operator: Error in operator arg: In
  field "SALES_DT_CHAR": Expected ";", got: ",", line 7
  
  ##E IIS-DSEE-TCOS-00029 20:33:25(002) <main_program> Creation of
  a step finished with status = FAILED.
  (XXXXX.Lookup_215)
  
  ***
  0001: //
  0002: // Generated file to implement the
  V0S215_XXXXX_Lookup_215 transform
  operator.
  0003: //
  0004:
  0005: // define our input/output link names
  0006: inputname 0 Str_Joi_TagetMonth1;
  0007: tablename 0 Str_Joi_TargetMonth2;
  0008: outputname 0 Str_Trf_FilMonth;
  0009:
  0010: initialize {
  0011:  // define our row rejected variable
  0012:  int8 RowRejected0;
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Customers using the parallel lookup stage with range lookup
  where a lookup range has been entered and then removed
  ****************************************************************
  PROBLEM DESCRIPTION:
  Under some circumstances columns can be left with key
  expressions even though
    they are not marked as keys. This can lead to a compilation
  failure like:
  
  ##E IIS-DSEE-TOSH-00003 20:33:25(001) <main_program> Syntax
  error: Error in "transform"  operator: Error in operator arg:
  In
  field "SALES_DT_CHAR": Expected ";", got: ",", line 7
  ****************************************************************
  RECOMMENDATION:
  For 8.1, install patch_JR34616_client_windows_8100
  ****************************************************************
  

Problem conclusion

• In some cases the compiler was not checking to ensure that
  columns with key expressions had the column key indicator set to
  true.
  

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

• CLIENT
  

Fix information

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R810 PSN

     UP