Re: Embedded SQL "Create Table as" problems after V5R4 upgrade

I'm not really sure how to read this or, more specifically, how to
answer you. Below is a partial listing from WRKPTFGRP:

Opt  PTF Group             Level  Status
    SF99540                6115  Installed
    SF99539                  29  Installed
    SF99530                6045  Not installed
    SF99529                  75  Not applicable
    SF99504                   4  Installed...

Kyle

On 11/22/06, rob@xxxxxxxxx <rob@xxxxxxxxx> wrote:

Also, what does WRKPTFGRP show?


Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"Kyle Collie" <kcollie@xxxxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
11/22/2006 01:03 PM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
"RPG List" <rpg400-l@xxxxxxxxxxxx>
cc

Subject
Embedded SQL "Create Table as" problems after V5R4 upgrade






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.