A fix is available
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 number
JR34616
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
810
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-10-21
Closed date
2009-11-04
Last modified date
2009-11-04
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
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"InfoSphere DataStage"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
12 October 2021