Reference Link with mutli row result set

chulett · Post by **chulett** » Mon Apr 23, 2007 10:58 pm

There are several, problem is the various parts of the technique seem to be scattered around in multiple posts. I know what's involved but couldn't really find everything laid out all at once.

Here is one decent example that I could find. Other suggested Exact Match search keywords for you:

multi-row result set
multiple row result set
build.index
create.index

Someone should really write a FAQ for this.

georgesebastian · Post by **georgesebastian** » Tue Apr 24, 2007 2:19 am

Hi Everyone,

Reference Link with mutli row result set - can anyone tell me how can you set this in server jobs?

Thanks
George

nick.bond · Post by **nick.bond** » Tue Apr 24, 2007 2:31 am

I'm sure this has been covered before - have a search for it......

georgesebastian · Post by **georgesebastian** » Tue Apr 24, 2007 3:27 am

nick.bond wrote:I'm sure this has been covered before - have a search for it......

Hi Nick,

I searched for it.
But couldnt find much useful information regarding this one..
If you know any specific thread,can you please post that one.

thanks
George

georgesebastian · Post by **georgesebastian** » Tue Jul 03, 2007 2:21 am

Can anyone please explain this
When i searched i got only one thread
viewtopic.php?t=109355&highlight=VOC+entry

Thanks
george

JoshGeorge · Post by **JoshGeorge** » Tue Jul 03, 2007 6:06 am

In Transformer stage properties you can check the option for reference link with mutli row result set and enable this.

chulett · Post by **chulett** » Tue Jul 03, 2007 7:01 am

You only got one thread when you searched for what? Are you still looking for 'multi-row' information or VOC entry help now?

If still the former, did you try some of the keywords I suggested? Oddly, it was made at a time when the clock on the server was borked, so it shows up before your original post, but those keywords worked for me. And I directly linked to one as well.

georgesebastian · Post by **georgesebastian** » Tue Jul 03, 2007 9:41 pm

JoshGeorge wrote:In Transformer stage properties you can check the option for reference link with mutli row result set and enable this.

Thanks Josh,

So if we check this option and in the lookup there are multiple rows which are matching the key,all these rows will be selected?

Thanks
George

chulett · Post by **chulett** » Tue Jul 03, 2007 9:44 pm

Yes, and this option will only appear if the Reference Link originates from a UV or ODBC stage.

georgesebastian · Post by **georgesebastian** » Tue Jul 03, 2007 10:35 pm

JoshGeorge wrote:In Transformer stage properties you can check the option for reference link with mutli row result set and enable this.

Thanks Josh,

So if we check this option and in the lookup there are multiple rows which are matching the key,all these rows will be selected?

Thanks
George

georgesebastian · Post by **georgesebastian** » Tue Jul 03, 2007 10:36 pm

JoshGeorge wrote:In Transformer stage properties you can check the option for reference link with mutli row result set and enable this.

Thanks Josh,

So if we check this option and in the lookup there are multiple rows which are matching the key,all these rows will be selected?

Thanks
George

ArndW · Post by **ArndW** » Tue Jul 03, 2007 10:36 pm

georgesebastian · Post by **georgesebastian** » Wed Jul 04, 2007 2:47 am

chulett wrote:Yes, and this option will only appear if the Reference Link originates from a UV or ODBC stage.

Thanks Craig,

Thats a new information to me.

Sorry Craig,I am not a premium member thats why i was not

able to see fully your firstpost.

Thanks all
Georg

georgesebastian · Post by **georgesebastian** » Wed Jul 04, 2007 2:52 am

chulett wrote:Yes, and this option will only appear if the Reference Link originates from a UV or ODBC stage.

Thanks Craig,

Thats a new information to me.Is there any special reson why only for UV and ODBC why not for OCI,DRS etc

Sorry Craig,I am not a premium member thats why i was not

able to see your first post entirely.

Thanks all
George

georgesebastian · Post by **georgesebastian** » Wed Jul 04, 2007 2:56 am

chulett wrote:Yes, and this option will only appear if the Reference Link originates from a UV or ODBC stage.

Thanks Craig,

Thats a new information to me.Is there any special reson why only for UV and ODBC why not for OCI,DRS etc

Sorry Craig,I am not a premium member thats why i was not

able to see your first post entirely.

Thanks all
George