Re: Evaluate complex conditions -- MIDRANGE-L

You suggest that an SQL process is not a performance pig compared to 
properly written RPGIV program.   Is there any experience out there to 
support or confute this?

I ask because we notice that whenever one of the SQL gurus starts an SQL 
process off the command line all the rest of us might as well go for 
coffee until the SQL is done. 

_______________________
Booth Martin
Booth@MartinVT.com
http://www.MartinVT.com
_______________________




Marco Facchinetti <facchinetti@yahoo.com>
Sent by: owner-midrange-l@midrange.com
10/25/2000 05:28 AM
Please respond to MIDRANGE-L

 
        To:     MIDRANGE-L@midrange.com
        cc: 
        Subject:        Re: Evaluate complex conditions

Martin, if your purpose is a Query Tool my experience says
that is better find something ready on the market.
About performance: if an sql statement is too heavy the
same one done in (eg.) RPG will take a very long time to be
executed. If you got the right logical files defined in you
DB you'll get good performace if not....
Anyway if your are looking to eval or check an expression
just remember tha procedure calls can be recursive, so you
don't need any stack, procedures do it for you. 

Enjoy...

--- booth@martinvt.com wrote:
> I have 4 problems with an SQL solution. 
> 
> 1-I don't know SQL well enough to  write the strings on
> the fly. 
> 2-Users I know can't fill in a command line string
> suitably for an SQL 
> solution, 
> 3-the few instances of SQL selections I've seen have
> performance pigs in 
> that SQL would suck in the sides of the machine in an
> interactive job, and 
> even with that still respond slowly.
> 4-giving users full flexibility with and/or selections
> just doesn't work 
> well.  Their intentions are good but the example given
> yesterday is a 
> wonderful example of the problem.  ( "give me all
> registered voters in New 
> Hampshire and Vermont" will list just a few energized
> citizens that like 
> to vote early and vote often.)
> 
> imho
> _______________________
> Booth Martin
> Booth@MartinVT.com
> http://www.MartinVT.com
> _______________________
> 
> 
> 
> 
> Marco Facchinetti <facchinetti@yahoo.com>
> Sent by: owner-midrange-l@midrange.com
> 10/24/2000 03:34 AM
> Please respond to MIDRANGE-L
> 
> 
>         To:     MIDRANGE-L@midrange.com
>         cc: 
>         Subject:        Re: Evaluate complex conditions
> 
> SQL?
> --- booth@martinvt.com wrote:
> > Terry, the only method I've been able to create and
> then
> > understand again 
> > a week later, is to make a series of subroutines.  Each
> > subroutine will 
> > have a test for a condition and will flip a flag if the
> > condition is not 
> > met.  Something like this:
> > 
> >  C    Eval      DoItFlag = 'Yes'
> >  C    Exsr    Test1
> >  C    If         DoItFlag = 'Yes' And Test1Flag = 'Yes'
> >  C    EXSR   Test1SR
> >  C    End
> >  C    If         DoItFlag = 'Yes' And Test2Flag ='Yes'
> >  C    EXSR   Test2SR
> >  C    End
> >  C    If         DoItFlag = 'Yes' And Test3Flag = 'Yes'
> >  C    EXSR   Test3SR
> >  C    End
> >   C    If         DoItFlag = 'Yes'
> >  C    EXSR   OKToDoSR
> >  C    End 
> > 
> > 
> > _______________________
> > Booth Martin
> > Booth@MartinVT.com
> > http://www.MartinVT.com
> > _______________________
> > 
> > 
> > 
> > 
> > Terry Grider <tgrider@arkansas.net>
> > Sent by: owner-midrange-l@midrange.com
> > 10/23/2000 12:43 PM
> > Please respond to MIDRANGE-L
> > 
> > 
> >         To:     MIDRANGE-L@midrange.com
> >         cc: 
> >         Subject:        Re: Evaluate complex conditions
> > 
> > Sorry guys,  I didn't do a very good job of explaining
> > what I was looking 
> > for.
> > I don't mean I want code that is an example of testing
> > for complex 
> > conditions, I
> > mean I'm looking for code that will evaluate statements
> > like the one in my
> > original example and determine the truth of the
> > statement.  You see, I'm 
> > writing
> > a query tool and I want the user to be able to provide
> > selection criteria 
> > in an
> > english style IF format similar to cobol or other query
> > tools I've seen. I 
> > can
> > currently handle simple criteria with "and/or"
> > connectors, but I can't 
> > seem to
> > come up with a good method for handling multiple levels
> > of parenthesis.
> > 
> > Terry Grider wrote:
> > 
> > > Has anyone ever written or seen an example of program
> > code designed to
> > > evaluate complex conditions?  For example, if you
> > wanted to evaluate a =
> > > b and (c = d or c = e or c = f).  I'm looking for
> > something that can do
> > > multiple levels of parenthesis and all "and/or"
> > combinations.
> > >
> > > --
> > > Terry Grider
> > > tgrider@arkansas.net


__________________________________________________
Do You Yahoo!?
Yahoo! Messenger - Talk while you surf!  It's FREE.
http://im.yahoo.com/
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to 
MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: 
david@midrange.com
+---




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