Re: SQL Internal Error

I should do that. Finding the time is the hard part. Thanks for doing so.

Those SQL -901s cause the collection of a wealth of diagnostic information
for IBM, so I anticipate they would be able to provide great service in
resolving the issue.

Mike

On Tue, Mar 12, 2019 at 1:26 PM Scott Mildenberger <
smildenberger@xxxxxxxxxxxx> wrote:

I have opened PMR's on -901 errors and twice IBM acknowledged the error
and published PTF's to fix the issue.

Scott Mildenberger | Software Developer | Washington Corporations | 101
International Drive | Missoula, MT 59808 | Office: (406) 523-1536 |
www.washcorp.com

-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Mike
Jones
Sent: Tuesday, March 12, 2019 1:47 PM
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: SQL Internal Error

SQL -901 errors are, in my opinion, IBM defects. They tend to occur only
in complex SQL. I've always just tweaked the code until the error
eventually disappears. I've worked around the problem about 30 times.

Usually, the job log contains an MCH error as well.

Because they are defects, they don't tend to make sense. For me, the SQL
failing has always been valid. The common thread is complex SQL.

Good luck,

Mike
--
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@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.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@xxxxxxxxxxxx for any subscription related
questions.

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