Re: check sqlrpgle code for missing SQLCOD SQLSTATE after a sql operation

"RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> wrote on 06/24/2019
07:03:39 PM:

----- Message from John Yeung <gallium.arsenide@xxxxxxxxx> on Mon,
24 Jun 2019 14:13:38 -0400 -----

To:

RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>

Subject:

Re: check sqlrpgle code for missing SQLCOD SQLSTATE after a sql

operation
. . .
. . .
. . .

I don't work with a lot of SQLRPGLE code myself, but I would expect
that for any given source member which contains multiple uses of SQL,
it's likely that SQL code/state checking is consistently used
throughout the member, or consistently not used anywhere in the
member.

John,

Not in my experience. I frequently see a check for SQL completion/error
after a fetch but not after open, close, and other statements--it really
is often hit or miss even within the same source member.

Michael Quigley
Computer Services
The Way International