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

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.