RE: RPGILESQL PGM

Thank you everyone for respond,
I tried to move "and" to the end of statement, how you have been suggested, it
still does not work.
Buck, I think that concatenation idea is really could help.
 Is it exact syntax what I should put in my SQL statement for the "cat"?
Also my Fdate and Tdate should be declare in RPG DS as 8 characters?
Thank you. Suffering haha.
<<<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.<<<

------------------( Forwarded letter 1 follows )---------------------
Date: Thu, 6 Jun 2002 15:01:25 -0400
To: rpg400-l@midrange.com
From: Buck.Calabro@commsoft.net
Sender: rpg400-l-admin@midrange.com
Reply-To: rpg400-l@midrange.com
Subject: RE: RPGILESQL PGM

>> 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
_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.