Trevor,

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.

Regards,

Luis Rodriguez
------------------------------

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

Luis,

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
written.

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

Thanks,
Trevor



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

Trevor,

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

What kind of error message are you getting?

Regards,

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 -
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



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.
http://tv.yahoo.com/


This thread ...


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].