Re: SQL and Journaling

At 08:01 AM 9/30/98 -0500, you wrote:
>We have recently created a couple of files to hold summary information
>retrieved from our production files.  We are updating the files using
>SQL run from a source file.  Our problem is that with 500,000 records in
>this file, the journaling overhead is ridiculous.  Is there any way that
>we can do this without journaling?  We chose SQL in the first place
>because of the union capabilities.  We can not do want we want very
>easily in Query/38 or Query/400.

However you can probably achieve what you want with OPNQRYF.  You do not
have to journal to use SQL.  It turns it on by default, but you can turn it
off.  The downside is that in the event of an error, SQL gives you an
implicit rollback capability with journaling turned on.

Al




+--------------------------------------------------+
| Please do not send private mail to this address. |
| Private mail should go to barsa@ibm.net.         |
+--------------------------------------------------+

Al Barsa, Jr. - Account for Midrange-L
Barsa Consulting, LLC.  
400 > 390

Phone:  914-251-9400
Fax:    914-251-9406


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---