Re: SQL table journal requirement

[Trevor Perry <trevor@xxxxxxxxxx>]

Thanks!

Next question would be, why would I ever do WITH NC?





On 10/10/07 11:44 AM, "Colin Redman" <colin.redman@xxxxxxxxxxxxxx> wrote:

> Or on your INSERT statement, specify WITH NC (No commitment control)
>
> Colin
> ----- Original Message -----
> From: "Pete Helgren" <Pete@xxxxxxxxxx>
> To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
> Sent: Wednesday, October 10, 2007 3:52 PM
> Subject: Re: SQL table journal requirement
>
>
> > The only time I have run across this is when I use SQL within RPG.  I
> > usually compile with with commitment control *NONE and it takes care of
> > the problem.
> >
> > I can't say I have exactly encountered your situation before though. I'd
> > have to try it.
> >
> > Pete Helgren
> >
> > Trevor Perry wrote:
> > > I created a set of SQL tables withOUT a collection - and therefore,
> > > without
> > > journals. I cannot write records from RPG, since the SQL tables are not
> > > journalled.
> > >
> > > I have since created the Collection, and solved the problem. However, is
> > > there a way to turn off the requirement that an SQL table be journalled
> > > so I
> > > can write to it?
> > >
> > > Thanks,
> > > Trevor