RE: SQL State 55019 code -7008

Thanks all...

I probably had it in the compile command in RDi. I have some that I created myself (i.e. the source lib is different than the pgm object lib).
I can't imagine changing the CMD default.

Worst part about it was that the procedure in the pgm was returning the SQL State, but the call was not checking it. I feel like I'm always in a hurry to get things done.

Greg

-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Charles Wilt
Sent: Monday, June 20, 2022 4:50 PM
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: SQL State 55019 code -7008

Sure, you could have
-- used CHGCMDDFT
-- updated the compile command used by RDi
-- created your own compile command for RDi to use

The way to prevent this is to include a EXEC SQL SET OPTION COMMIT=*NONE;
In the source...

Charles


On Mon, Jun 20, 2022 at 1:02 PM Greg Wilburn <
gwilburn@xxxxxxxxxxxxxxxxxxxxxxx> wrote:

I recently had to recompile an SQLRPGLE program that contained an SQL
Delete statement. The source code had not changed for 3 years, yet the
delete portion of the program failed.

In debug, I could see the SQL code -7008 SQL State 55019.

We've never had journaling enabled for this (or any) file... And the
program never contained the EXEC SQL SET COMMIT OPTION = *NONE statement.

I'm just curious as to why this program worked previously (for 3 years),
then ceased to work after I recompiled it (for another reason)?
Could my RDi CRTSQLRPGI command have contained something that would
implicitly set NO COMMIT? (about a year ago, I had to recreate my
environment)
Or was this something with a PTF update?

This is the second time I've encountered this same issue in the past
year. I'd like to know when and how it was introduced.

TIA,
Greg
[Logo]<https://www.totalbizfulfillment.com/> Greg Wilburn
Director of IT
301.895.3792 ext. 1231
301.895.3895 direct
gwilburn@xxxxxxxxxxxxxxxxxxxxxxx<mailto:gwilburn@xxxxxxxxxxxxxxxxxxxxxxx>
1 Corporate Dr
Grantsville, MD 21536
www.totalbizfulfillment.com<http://www.totalbizfulfillment.com>
--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com