Re: SQL to only check for existence:

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.