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

["Kyle Collie" <kcollie@xxxxxxxxx>]

Our SysAdmin normally stays on top of the PTF's. He just stays away
from anything that is referred to as a "test" PTF which requires
others.

On 11/22/06, rob@xxxxxxxxx <rob@xxxxxxxxx> wrote:
> Ok, on your WRKPTFGRP you have some clutter left over from previous
> releases - hence the Not Installed.  Example SF99530 is the last cume you
> put on for V5R3.  Pretty much the same for the Not applicable's also.
> Note:  This is NOT always the case.  You could have downloaded a group,
> load it to apply at the next IPL but not have done that IPL yet.  Those
> would say Not Installed or some such thing also.  But that doesn't look
> like what you have done.  You can use option 4 to blow the obsolete ones
> away.  That's a common task to do after an upgrade.
> For your problem, these are the most important ones.
> PTF Group             Level  Status
> SF99540                6297  Installed
> SF99539                  29  Installed
> SF99504                   6  Installed
> This is level we are at, but we just put on the latest last weekend.  On
> the cume, it's a Julian date sort of reference - day 297 of year 2006.
> You can hit F11 for more detail.
> You're actually not in too bad a shape.  When you said you recently
> upgraded to V5R4 I was concerned that perhaps you never applied a cume or
> a group.  That alone was my reason for asking.
>
> 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 03:01 PM
> Please respond to
> RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
>
>
> To
> "RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
> cc
>
> Subject
> 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.
> >
> >
> --
> 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.