Re: Opinions on approach, please...



"Robert" <no@xxxxxx> wrote in message
news:0tui34tb10bvrb6afb5v0h0mnietfqrj8b@xxxxxxxxxx
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.

You give up too easily... :-)

If I do a FETCH immediately it will return EOF. I can treat that as an
invalid key in this case.

Pete.
--
"I used to write COBOL...now I can do anything."



.