Problem with Lookup Stage (Range)

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
JSilva
Participant
Posts: 2
Joined: Thu Aug 11, 2016 7:50 pm

Problem with Lookup Stage (Range)

Post by JSilva »

Hi, I have a problem in Lookup Stage parallel V 9.1

I do have a table with amount, the second table has ranges, in stream link I have defined the range for the amount

Example:
STREAM LINK
Key Field: BCOME
Amount: 2555,10

REFERENCE LINK
Key Field: BCOME
DSLink25.LWR_VAL: 0,00
DSLink25.UPR_VAL:3000,00

Stream link defined range
Range(DSLink25.LWR_VAL, ">=", DSLink25.UPR_VAL, "<=",0)) -> This line in red

When I compile the job, it shows me:

Column Amount: Range(DSLink25.LWR_VAL, ">=", DSLink25.UPR_VAL, "<=",0)
Variable 'Range' not defined

I appreciate your help
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post by roy »

Hi,
Try reediting this range lookup; perhaps the entire build the entire stage a new.

The fact that it is red suggest that something is wrong!
Roy R.
Time is money but when you don't have money time is all you can afford.

Search before posting:)

Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Image
PaulVL
Premium Member
Premium Member
Posts: 1315
Joined: Fri Dec 17, 2010 4:36 pm

Post by PaulVL »

also are you 100% sure that both links are sorted via the same key criteria?
Post Reply