RE: Embedded sql without index faster than with index

-----Message d'origine-----

[mailto:rpg400-l-bounces@xxxxxxxxxxxx] De la part de Schutte,
Michael D

What happens if you code it like so.

Select fields from files where :inputclientNbr in (0,
clientNumber) and :inputAmt in (0, amount)

When inputClientNbr host variable is 0, then all clients
would end up getting selected, otherwise only the
inputclientnumber is selected.

When inputAmt is 0, then all transaction amounts will be
selected, otherwise only that transaction amount would be.

User can enter one client number, an upper and a lower amount and a start and end date, hence I used between.

I'm building my cursor like this :

wSql =
'SELECT * FROM MYFILE +
WHERE +
DATE BETWEEN ''' + wDate1 + ''' AND +
''' + wDate2 + ''' AND +
CLIENT BETWEEN ' + wClientN1 + ' AND +
' + wClientN2 + ' AND +
AMOUNT BETWEEN ' + wAmount1 + ' AND +
' + wAmount2 + ';

EXEC SQL
PREPARE S1 FROM : wSql;


How would the syntax be if I used host variables?