reference link with multi row result set

girishoak · Post by **girishoak** » Thu May 06, 2004 5:51 am

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

crouse · Post by **crouse** » Thu May 06, 2004 6:33 am

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!

-Craig

girishoak · Post by **girishoak** » Thu May 06, 2004 7:25 pm

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