× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  • Subject: Re: SQL and Journaling
  • From: bclark@xxxxxxxxxxxx (Bob Clark)
  • Date: Thu, 01 Oct 1998 10:01:35 -0500
  • Organization: US Safety

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


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.