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 is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.
