Range Lookup Compile Error

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
mikegohl
Premium Member
Premium Member
Posts: 97
Joined: Fri Jun 13, 2003 12:50 pm
Location: Chicago
Contact:

Range Lookup Compile Error

Post by mikegohl »

I get a compile error in a range lookup. Does any one have any ideas?

##################################################################
#### STAGE: Lookup_3
## Operator
transform
## Operator options
-table
-range "StartItem <= Item AND EndItem > Item"
-keep
-allow_dups
-flag run
-name 'V0S3_LookupItemsRangeRef_MJG_Lookup_3'

## General options
[ident('Lookup_3'); jobmon_ident('Lookup_3')]
## Inputs
0< [] 'Range_Description:Range_Description.v'
1< [view (
StartItem, ">=", Range_Description.EndItem, "<",0)=Warehouse;
)] 'Warehouse:Warehouse.v'
## Outputs
0> [] 'Lookup_3:Warehouse_Items.v'

Here are the errors:

#W IIS-DSEE-TOSH-00049 15:39:12(008) <main_program> Parameter specified but not used in flow: DSPXWorkingDir [osl/osl.C:621]
##E IIS-DSEE-TOSH-00003 15:39:12(009) <main_program> Syntax error: Error in "transform" operator: Error in operator arg: In field "StartItem": Expected ";", got: ",", line 14
[osl/osl.C:135]
##E IIS-DSEE-TOSH-00003 15:39:12(010) <main_program> Syntax error: Error in "transform" operator: Error in operator arg: In field "StartItem": Expected ";", got: ",", line 14
[osl/osl.C:135]
##E IIS-DSEE-TCOS-00029 15:39:12(011) <main_program> Creation of a step finished with status = FAILED. [osh.C:1081] (LookupItemsRangeRef_MJG.Lookup_3)
Michael Gohl
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Can you post how the ranges were specified in the Lookup stage?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
mikegohl
Premium Member
Premium Member
Posts: 97
Joined: Fri Jun 13, 2003 12:50 pm
Location: Chicago
Contact:

Post by mikegohl »

Resolved. I changed the key and recompiled with not problem. I changed it back to the exact same key and range. It compiled an ran fine. No idea why.
Michael Gohl
Post Reply