RE: SQL Problem

[Scott Mildenberger <Smildenber@xxxxxxxxxxxx>]

You have to tell the system you are not using commitment control, either
with your compile options or inside the program.  Sorry, can't give details
as we dont' use embedded SQL here.  Committment control requires the file to
be journaled.

Scott Mildenberger

> -----Original Message-----
> From: THarteau@felkerbrothers.com [mailto:THarteau@felkerbrothers.com]
> Sent: Friday, December 20, 2002 7:15 AM
> To: RPG400-L@midrange.com
> Subject: SQL Problem
>
>
>
> Its not working.  I am getting SQL error code 7008. We don't
> journal any
> files, and this is the only place in the program I use this
> file.  This is
> in my test environment.  I was using the physical file first, and that
> didn't work either. Any ideas on how to make this work?
>
> This is my job log:
>       Query options retrieved file QAQQINI in library QUSRSYS.
>       **** Starting optimizer debug message for query .
>       Query options used to build the OS/400 query access plan.
>       All access paths were considered for file FLTL03.
>       Additional access path reason codes were used.
>       Arrival sequence access was used for file FLTL03.
>       Member FLTL03 not journaled to journal *N.
>       FLTL03 in V64BPCSTF not valid for operation.
>       SQLCOD = -000007008.
>