Re: SQL and Journaling

[bclark@xxxxxxxxxxxx (Bob Clark)]

Thank you.  It's amazing that I've gone 36 years wihout being snake-bit.

Pete Hall wrote:

> 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
> +---
begin:vcard
n:Clark;Bob
x-mozilla-html:FALSE
org:US Safety
adr:;;;Lenexa;Ks;66214;USA
version:2.1
email;internet:bclark@ussafety.com
title:Programmer/Analyst
tel;fax:913-599-1703
tel;work:913-599-5555 x274
x-mozilla-cpt:;0
fn:Bob Clark
end:vcard