Re: SQL and Journaling

[Pete Hall <peteh@xxxxxxxxxx>]

At 08:01 09/30/1998 , Bob Clark 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.

RUNSQLSTM LIB/FILE SRCMBR(MBR) COMMIT(*NONE)????

Pete Hall
peteh@inwave.com 
http://www.inwave.com/~peteh/

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