Google Mail Calendar Documents Reader Web more »
Recently Visited Groups | Help | Sign in
Google Groups Home
Message from discussion Use prepared statement - problem
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Follow-up To:
Add Cc | Add Follow-up to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers that you hear
 
kolev.kg  
View profile   Translate to Translated (View Original)
 More options 2 July, 09:38
Newsgroups: ibm.software.network.directory-integrator
From: "kolev.kg" <kolev...@gmail.com>
Date: Thu, 2 Jul 2009 01:38:16 -0700 (PDT)
Local: Thurs 2 July 2009 09:38
Subject: Re: Use prepared statement - problem
I assume you have put this statement in a lookup connector, correct?

If so then it is normal to get such an error if your link criteria is
not bound to a unique constraint, i.e. you are querying for something
that can be present in multiple records at the same time. In your case
you have 3 records which "end_date" field is NULL. When you get
multiple entries returned the AL gives you the opportunity to further
filter the records or to put them all in the resultant entry before
doing the input map. Since the AL does not know what exactly you might
want to be done you have been given the ability to specify your
intentions using a hook - "On Multiple Entries" to be precise. In that
hook you could cycle throughout all the entries that matched your
criteria using a script.

Best Regards,
Kaloyan Kolev.


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message, you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.

Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2009 Google