Re: sql fetch

David,

FETCH is quite straightforward. Could you extend a little over your error
message (maybe send the text and ID?). Otherwise, check the number of rows
specified in the sentence.

Regards,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries


On Thu, Oct 15, 2009 at 9:08 AM, David FOXWELL <David.FOXWELL@xxxxxxxxx>wrote:

Somewhere, deep in the heart of an application, it would seem that an SQL
Fetch has not been coded as it should have been. It's ending in error and
the error isn't caught. In the job log a message says that the fetch
returned more than one row. The result is that a letter destined for a
particular client is not printed. If we try and run the same thing in a test
environment, it works. It just occasionally doesn't work in production. We
can see the program running the fetch in the log, but which instance of the
program...

I'm running a tool to find all instances of Fetch in all rpg sources. I'll
then look to see which ones are in the modules making up the program.

While I'm waiting for that to finish, maybe someone out there would have
some clues about where to look, or watch out for.

Thanks.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.