Message from discussion
Use prepared statement - problem
Path: g2news1.google.com!postnews.google.com!c36g2000yqn.googlegroups.com!not-for-mail
From: "kolev.kg" <kolev...@gmail.com>
Newsgroups: ibm.software.network.directory-integrator
Subject: Re: Use prepared statement - problem
Date: Thu, 2 Jul 2009 01:38:16 -0700 (PDT)
Organization: http://groups.google.com
Lines: 16
Message-ID: <4fe41370-9e31-4ece-ba16-6136545e5133@c36g2000yqn.googlegroups.com>
References: <c84e7df0-70ee-4628-be0c-d8071d67687d@18g2000yqa.googlegroups.com>
NNTP-Posting-Host: 195.212.29.187
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1246523896 31119 127.0.0.1 (2 Jul 2009 08:38:16 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 2 Jul 2009 08:38:16 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: c36g2000yqn.googlegroups.com; posting-host=195.212.29.187;
posting-account=9gGbVAoAAAAdhZmpmOYcB5--h-ES_03h
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US)
AppleWebKit/530.5 (KHTML, like Gecko) Chrome/2.0.172.33 Safari/530.5,gzip(gfe),gzip(gfe)
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.
|
