My apologies. I assumed you were writing to the table using
RPG's WRITE. Some days ago I answered a post for someone
who wanted to use SQL created indexes with "traditional"
RPG statements and I thought you were in the same boat.


Luis Rodriguez

message: 11
date: Wed, 10 Oct 2007 12:31:36 -0400
from: Trevor Perry <trevor@xxxxxxxxxx>
subject: Re: SQL table journal requirement


I was receiving an error in the joblog that told me it
could not write to
the file because the file was not journalled. And, there
were no records

I did solve the problem, and the files are now being
journalled - which is
what I want.


On 10/10/07 12:22 PM, "Luis Rodriguez"
<luis.rodriguez2@xxxxxxxxx> wrote:


AFAIK, journalled SQL tables aren't required in order
write to SQL tables from a RPG program. In our shop we
that all the time.

What kind of error message are you getting?


Luis Rodriguez
--- midrange-l-request@xxxxxxxxxxxx wrote:

message: 7
date: Wed, 10 Oct 2007 10:25:54 -0400
from: Trevor Perry <trevor@xxxxxxxxxx>
subject: SQL table journal requirement

I created a set of SQL tables withOUT a collection -
therefore, without
journals. I cannot write records from RPG, since the
tables are not

I have since created the Collection, and solved the
problem. However, is
there a way to turn off the requirement that an SQL
be journalled so I
can write to it?


Luis Rodriguez

IBM Certified Systems Expert
eServer i5 iSeries Technical Solutions

Tonight's top picks. What will you watch tonight? Preview the hottest shows on Yahoo! TV.

This thread ...

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

This mailing list archive is Copyright 1997-2020 by 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].