Page 1 of 1

reference link with multi row result set

Posted: Thu May 06, 2004 5:51 am
by girishoak
Hi,

I am trying to get multiple rows usign uv odbc lookup stage. As per the help given by datastgae, I tried to search "reference link with multi row result set " checkbox option. I clicked number of times on the header of link, but it never showed me this option. Can anybody tell me how to get this option. I need it badly.

Thanks in advance

Girish Oak

Posted: Thu May 06, 2004 6:33 am
by crouse
In the tranformer stage, click on "stage properties" icon (upper left).

Click input tab. In drop down for "Input name:" select the reference link.

At the bottom of the screen will be the check box.

Well hidden, indeed! :wink:

-Craig

Posted: Thu May 06, 2004 7:25 pm
by girishoak
ohh....it was very simple.thank you very much. I didnt try this at all, I just followed instruction of Datastage Help and caught in mess.

Thanks again.

Girish Oak