Re: V5R1 question - CPF4238 & SQL7008

Hi Dennis,
We got this error msg too, and it looked as though the default for COMMIT
has changed on the CRTSQLRPG cmd. It needs to be *None for BPCS.
cheers,
Clare

----- Original Message -----
From: "Dennis Munro" <DMunro@badgerminingcorp.com>
To: "Midrange List (E-mail)" <MIDRANGE-L@midrange.com>
Sent: Monday, September 30, 2002 5:00 PM
Subject: V5R1 question - CPF4238 & SQL7008


> AS/400 720 running V5R1 since Labor Day weekend & current with "all" ptf's
> at that time.
>
> Ran a "test" of the month-end process on the machine & I got a
> escape/diagnostic message that does not make sense.  First CPF4238 (Sev
> 50/Escape) "Member ILI not journaled to journal *N" which was followed by
> SQL7008 (Sev 30/Diagnostic) "ILI in BPCSF not valid for operation" with
> reason code 3 "ILI not journaled, or no authority to the journal.  Files
> with an RI constraint action of CASCADE, SET NULL, or SET DEFAULT must be
> journaled to the same journal."
>
> Did a DSPFD on the file & it shows number of constraints as zero (-0-) &
the
> file is not being journaled.  So what is causing these messages to occur?
> The program seemed to run correctly & the report generated was what I was
> expecting.  There are eight files referenced by this program & all eight
got
> the same two messages & all eight have no constraints & they are not
> journaled.
>
> Thanks - Dennis.
>
> Dennis Munro
>
> "I love deadlines.  I especially like the whooshing sound they make as
they
> go flying by."  Dilbert's Words Of Wisdom:
>
> Badger Mining Corporation
> www.badgerminingcorp.com
> dmunro@badgerminingcorp.com
> (920) 361-2388
>
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> or email: MIDRANGE-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>