Re: SQL to only check for existence:

Michael,

PERFECT!!   works like a charm (at least where a match appears near
the beginning of the access path).

I'll now test where the first match is near the end of the access
path, see what kind of response I'll get then.

thanks!

Rick

On 4/18/06, Michael_Schutte@xxxxxxxxxxxx <Michael_Schutte@xxxxxxxxxxxx> wrote:
> Ooopss
>
> Select 1 into :myflag is what I meant.
>
> Michael Schutte
> Work 614-492-7419
> email  michael_schutte@xxxxxxxxxxxx
>
>
>
>             Michael_Schutte@b
>             obevans.com
>             Sent by:                                                   To
>             rpg400-l-bounces@         RPG programming on the AS400 /
>             midrange.com              iSeries <rpg400-l@xxxxxxxxxxxx>
>                                                                        cc
>
>             04/18/2006 11:02                                      Subject
>             AM                        Re: SQL to only check for
>                                       existence:
>
>             Please respond to
>              RPG programming
>              on the AS400 /
>                  iSeries
>             <rpg400-l@midrang
>                  e.com>
>
>
>
>
>
>
> myFlag = 0
>
> Select 1 into :verify where ...
>
> If one record is found, verify will equal 1.
>
> Michael Schutte
> Work 614-492-7419
> email  michael_schutte@xxxxxxxxxxxx
>
>
>
>             "rick baird"
>             <rick.baird@gmail
>             .com>                                                      To
>             Sent by:                  "Midrange Systems Technical
>             rpg400-l-bounces@         Discussion"
>             midrange.com              <midrange-l@xxxxxxxxxxxx>, "RPG
>                                       programming on the AS400 / iSeries"
>                                       <rpg400-l@xxxxxxxxxxxx>
>             04/18/2006 10:56                                           cc
>             AM
>                                                                   Subject
>                                       SQL to only check for existence:
>             Please respond to
>              RPG programming
>              on the AS400 /
>                  iSeries
>             <rpg400-l@midrang
>                  e.com>
>
>
>
>
>
>
> hey all,
>
> Is there a way to run an SQL statement that doesn't (necessarily)
> return anything, but only checks for the existence of one or more
> records based on a where statement - similar to a SETLL and %found?
>
> I've got a rather complicated SQL statement using:
> LIKE '___abc___'    or it could be:
> LIKE ______xyz'
>
> - over a very large file, and I'm having performance issues.
>
> I don't want to do a count(), because I don't care how many, only that
> at least one exists.   with count, it would have to read through the
> entire file to determine it.
>
> I also tried just doing a select - optimize for 1 row and a single
> fetch, but that seemed to take forever too.  It appears as if it is
> searching the entire file, instead of stopping at the first one.
>
> help!
>
> Rick
>
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>
>
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>
>
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>