RE: Can a Query fill the system? -- MIDRANGE-L

Subject: RE: Can a Query fill the system?
From: "Joe Pluta" <joepluta@xxxxxxxxxxxxxxxxx>
Date: Wed, 2 Oct 2002 16:56:41 -0500
Importance: Normal
List-archive: <http://archive.midrange.com/midrange-l/>
List-help: <mailto:midrange-l-request@midrange.com?subject=help>
List-id: Midrange Systems Technical Discussion <midrange-l.midrange.com>
List-post: <mailto:midrange-l@midrange.com>
List-subscribe: <http://lists.midrange.com/cgi-bin/listinfo/midrange-l>,<mailto:midrange-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/cgi-bin/listinfo/midrange-l>,<mailto:midrange-l-request@midrange.com?subject=unsubscribe>

> From: Vance Stanley
>
>  Hi Pam,
> We recently had a situation where a user wrote a query that built
> a physical file that was big
> enough to bring our system down. (This took several hours by the
> way).  Anyway, we found a way to
> limit the size of a physical file that is generated by query. It
> is done by creating a data area
> in QGPL that looks like this:

Here's a ton of stuff on QQUPRFOPTS:

http://www.mcpressonline.com/mc?50@38.GVj7aEaWXFj.1@.214a2ac9

You may have to register to access this article, if so, registering is free.

Joe

As an Amazon Associate we earn from qualifying purchases.

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.