Re: embeded SQL question

["Mike Naughton" <mnaughton@xxxxxxxxxxxx>]

Others have made good suggestions, but here's one more:

C            parm1    IfEq   *blanks
C                          Eval   Begin1 = *Loval
C                          Eval   End1 = *Hival
C                          Else
C                          Eval    Begin1 = parm1
C                          Eval    End1 = parm1
C                          EndIf

C/EXEC SQL DECLARE MYCUR CURSOR FOR 
. . . .
C+           field3a  = field3b  and field5a  Between :Begin1 and :End1
C/END-EXEC 

etc.

hth

RPG400-L@midrange.com writes:
>and I have to filter the records according to input parameter in the 
>following sequence
>
>Parm1 if not eq *blanks
>
>C/EXEC SQL DECLARE MYCUR CURSOR FOR 
>C+  SELECT   field1a ,  field2a ,  field3a,  field4a, field5a 
>C+           field6a,  field1b,  field2b, field3b, field4b 
> C+  FROM     FileA , FileB 
>C+  WHERE 
>C+           field1a  = field1b AND 
>C+           field2a  = field2b AND 
>C+           field3a  = field3b  and field5a  = : parm1 
>C/END-EXEC 


Mike Naughton
Senior Programmer/Analyst
Judd Wire, Inc.
124 Turnpike Road
Turners Falls, MA  01376
413-863-4357 x444
mnaughton@juddwire.com

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---