Why can't I use input column in a lookup condition?

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
vmcburney
Participant
Posts: 3593
Joined: Thu Jan 23, 2003 5:25 pm
Location: Australia, Melbourne
Contact:

Why can't I use input column in a lookup condition?

Post by vmcburney »

I've got DataStage 7.5.1 with the new lookup condition functionality. I want to add a lookup condition based on an input column, but when I bring up the right mouse menu in the condition field the "Input Column" option is greyed out, if I manually type the column name it is rejected. The manual shows a few examples of lookup conditions that use input field names. Does anyone know why mine are greyed out?
ashwin2912
Participant
Posts: 57
Joined: Wed Jan 26, 2005 10:22 pm
Location: India

Re: Why can't I use input column in a lookup condition?

Post by ashwin2912 »

I have this condition in DataStage 7.5 and it works fine (Its only for the master file though..not for the lookup file)
vmcburney
Participant
Posts: 3593
Joined: Thu Jan 23, 2003 5:25 pm
Location: Australia, Melbourne
Contact:

Post by vmcburney »

This has been submitted to Ascential as a GUI bug after being reproduced by support. Sometimes the Input Column field is greyed out. It can be fixed by unlinking the reference link and linking it again. It can also be fixed by shuffling links on the input link order tab (if you have more then one reference link).
Post Reply