Re: Opinions on approach, please...

On Mon, 26 May 2008 00:25:40 +1200, "Pete Dashwood" <dashwood@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:

"Arnold Trembley" <arnold.trembley@xxxxxxxxxxxxxxxx> wrote in message
news:q29_j.13798$j41.5537@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

It probably depends on whether "record not found" is a valid COBOL result
for a START command.

Certainly, some of the programs specify INVALID KEY in the START command.
I'm building template code to deal with that by testing the SQLSTATE in the
application program and doing the same logic as INVALID KEY does presently.

I will not work. SQL does not return an error when open cursor finds zero rows.
.