RE: Limit Result Set in Open Query File

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