RE: SQL State 55019 code -7008

[Greg Wilburn <gwilburn@xxxxxxxxxxxxxxxxxxxxxxx>]

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