RE: RPGILESQL PGM

[Buck Calabro <Buck.Calabro@xxxxxxxxxxxx>]

>> The statement should look like this, I think:
>>  C/EXEC SQL
>>  C+ DECLARE C1 CURSOR  FOR
>>  C+   SELECT * FROM PFfile where
>>  C+     SNSCC >=:FC AND SNSCC <=:TC and
>>  C+     SNSYY >=:FY AND SNSYY <=:TY and
>>  C+     SNSMM >=:FM AND SNSMM <=:TM and
>>  C+     SNSDD >=:FD AND SNSDD <=:TD
>>  C/End-Exec

You need to compare entire fields: date from disk vs date parameter.  Concat
and digits might help on the disk side:  where (digits(snscc) concat
digits(snsyy) concat digits(snsmm) concat digits(snsdd)) between :FC and
:TC.

You're already combining the individual parameters into a date parameter,
but you may need to make it a character instead of a date, especially for
performance reasons.
  --buck