× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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
+---

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.