Re: SQL to only check for existence:

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.