Re: [SQL7008] URLGROUP in TEFF not valid for operation.

[Nick_Vrtis@xxxxxxxxx]

Joe,

I had a similar situation.  When I ran the application from a PC, it worked
OK.  When I ran it from the AS/400, I needed to create the journal.  Don't
know why though.  I do agree that there are situations where journaling is
not necessary.  In my case, I was just building a temporary table with the
Java app so that I could read it with a CGI easier.  The table was always
going to be recreated, so there really wasn't any point in journaling it.

Nick




"Joe Teff" <joeteff@earthlink.net>@midrange.com on 05/01/2000 08:31:36 PM

Please respond to JAVA400-L@midrange.com

Sent by:  owner-java400-l@midrange.com


To:   <JAVA400-L@midrange.com>
cc:

Subject:  Re: [SQL7008] URLGROUP in TEFF not valid for operation.


>By default, SQL updates and inserts on the /400 require
>commitment control, which in turn requires journalling.  This
>doesn't have anything to do with Java, per se, since the
>same behavior occurs with any language that invokes SQL
>to do its database work.  In my opinion, AS/400 programmers
>and administrators need to get over their irrational fear of
>database journalling - it doesn't cost all that much any more,
>and it enables some wonderful capabilities.

I use jounalling frequently and am a big proponent of it. OTOH,
there are plenty of situations where journalling is just not
necessary. What I don't understand about this particular
situation is that I am using another file the exact same way
that is also not journaled and everything works fine. Why would
it matter for one file and not another?

Joe Teff

+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---



+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---