RE: Limit Result Set in Open Query File

[Dave Boettcher <DBoettch@xxxxxxxxxxxxxxxx>]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]
You might want to check out the parameter on OPNQRYF called

Performance optimization:

  Performance optimization . . .   *ALLIO        *ALLIO, *MINWAIT, *FIRSTIO

  Number of records  . . . . . .                 1-2147483647


Never had occasion to use it but it might do what you want if faster
processing is the question.

Dave Boettcher

> -----Original Message-----
> From: Joel R. Cochran [SMTP:jrc@masi-brac.com]
> Sent: Monday, April 08, 2002 10:49 AM
> To:   'rpg400-l@midrange.com'
> Subject:      Limit Result Set in Open Query File
>
> Does anyone know if there is a way with OPNQRYF to limit the number of
> results returned?  Say I want the first 10 "Smith"s in a file but there
> are
> a thousand... can I tel OPNQRYF file to only return the first ten to limit
> the processing time?
>
> TIA,
>
> Joel R. Cochran
> Director of Internet Services
> VamaNet.com
> (800)480-8810
> mailto:webmaster@vamanet.com
>
>