MQSeries.net :: View topic - How create relationship and use then at one time

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Interchange Server + Adapters » How create relationship and use then at one time

How create relationship and use then at one time

« View previous topic :: View next topic »

Author

Message

jeevan

Posted: Wed Nov 16, 2005 12:16 pm Post subject: How create relationship and use then at one time

Grand Master

Joined: 12 Nov 2005
Posts: 1432

Can someone help in how to create static/dynamic relationship and how to use them at one look up?

jeevan

Posted: Wed Nov 16, 2005 12:50 pm Post subject: Further question

Grand Master

Joined: 12 Nov 2005
Posts: 1432

Let me be more clear. I have field in destination bo in map that have fixed value. i have to use relationship for this. Can you please give me the step, creating relationship and use. I am supposed to use the look up for once for all field not times and again

Ratan

Posted: Wed Nov 16, 2005 1:34 pm Post subject:

Grand Master

Joined: 18 Jul 2002
Posts: 1245

Create a static (lookup) relationship with two participants (source and destination).

When deploying the relationship select the option to "Create schema". This will create the necessary tables (source and destination).

populate the source table with your source values and the destination with the destination values making sure that the Primary key field is the same for each source, destination pair.

Use the relationship using the api call Relationship.retrieveInstances(relationshipName, sourceParticipantName, sourceValue);
_________________
-Ratan

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Interchange Server + Adapters » How create relationship and use then at one time

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP