|
IBM offerred a "test" PTF (scheduled to be GA'ed by Febuary) but sounded less than confident that it would solve our problem. Our SysAdmin is less than eager to apply a test PTF. I would have thought that "create table ... as ..." would be a pretty common SQL statement. If it is an issue, I would have exprected to have "heard" (on this and other lists) something about it by now. Kyle On 11/22/06, rick baird <rick.baird@xxxxxxxxx> wrote:
WELL! that explains a lot! I think it's PTF time. On 11/22/06, Kyle Collie <kcollie@xxxxxxxxx> wrote: > Sorry, I should have included that in the original post. > > SQLCOD = -000000901 > > And this is the result of DSPMSGD RANGE(SQL0901) MSGF(QSQLMSG) > > Message ID . . . . . . . . . : SQL0901 > Message file . . . . . . . . : QSQLMSG > Library . . . . . . . . . : QSYS > Message text . . . . . . . . : SQL system error. > > On 11/22/06, rick baird <rick.baird@xxxxxxxxx> wrote: > > Kyle, > > > > can you run the offending program in debug to determine what the value > > of SQLCOD is? > > > > if so, hopefully therein will lie your answer. > > > > On 11/22/06, Kyle Collie <kcollie@xxxxxxxxx> wrote: > > > We have noticed a problem with sql internal errors after an upgrade to > > > V5R4. Embedded SQL that has worked for years is now quietly failing > > > with non-fatal sql internal errors. > > > > > > This is happening with the "create table as (select statement) with > > > data" sql command. We are now getting CPF4204 messages "Internal > > > failure occurred in query processor." > > > > > > This is a "quiet" error in that isw does not halt the program. > > > > > > Anyone else seen this? > > > > > > Kyle > > > -- > > > This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list > > > To post a message email: RPG400-L@xxxxxxxxxxxx > > > To subscribe, unsubscribe, or change list options, > > > visit: http://lists.midrange.com/mailman/listinfo/rpg400-l > > > or email: RPG400-L-request@xxxxxxxxxxxx > > > Before posting, please take a moment to review the archives > > > at http://archive.midrange.com/rpg400-l. > > > > > > > > -- > > This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list > > To post a message email: RPG400-L@xxxxxxxxxxxx > > To subscribe, unsubscribe, or change list options, > > visit: http://lists.midrange.com/mailman/listinfo/rpg400-l > > or email: RPG400-L-request@xxxxxxxxxxxx > > Before posting, please take a moment to review the archives > > at http://archive.midrange.com/rpg400-l. > > > > > -- > This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list > To post a message email: RPG400-L@xxxxxxxxxxxx > To subscribe, unsubscribe, or change list options, > visit: http://lists.midrange.com/mailman/listinfo/rpg400-l > or email: RPG400-L-request@xxxxxxxxxxxx > Before posting, please take a moment to review the archives > at http://archive.midrange.com/rpg400-l. > > -- This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/rpg400-l or email: RPG400-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/rpg400-l.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
