Re: SQL to only check for existence:

Try pasting the following into an SQLRPGLE source and substitute your library 
and file for qiws/qcustcdt. I ran it over a file with c.350,000 records, it was 
instant.

di                s              1p 0
c/exec sql
c+ set :i = (select 1 from sysibm/sysdummy1
c+           where exists(select * from qiws/qcustcdt))
c/end-exec
c                   eval      *inlr = *on

-------------- Original message -------------- 
From: "rick baird" <rick.baird@xxxxxxxxx> 

> 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 Midrange Systems Technical Discussion (MIDRANGE-L) mailing list 
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx 
> To subscribe, unsubscribe, or change list options, 
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l 
> or email: MIDRANGE-L-request@xxxxxxxxxxxx 
> Before posting, please take a moment to review the archives 
> at http://archive.midrange.com/midrange-l. 
>