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

["Kyle Collie" <kcollie@xxxxxxxxx>]

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.