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




This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].