Re: SQL table journal requirement

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/