Re: sql fetch

[Luis Rodriguez <luisro58@xxxxxxxxx>]

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.