× 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.


  • Subject: Re: Evaluate complex conditions
  • From: rob@xxxxxxxxx
  • Date: Wed, 25 Oct 2000 08:55:33 -0500


1)  This will come with experience.  See also #4.
2)  See also #4
3)  I think others have answered this with logical file selection and what
not.  Go hear John Sears talk at COMMON.  Most of what he says applies
regardless of green screen, GUI or whatever.  There are tips to monitoring
performance.  Do a STRDBG, with no program name, prior to starting SQL or
Query.  Also turn on full logging for your job.  Check your joblog
afterwards.
4)  The problem isn't with the SQL.  The problem is with how you get the
data from the users.  Regardless of whether you are using RPG, OPNQRYF, SQL
or whatever you still have to convert what they say into something which
the data retrieval method will understand.  Maybe giving them access to
STRQM will work better.  The prompter has some of the friendliness of
Query/400, but you can break out of the prompter if you need to do
something complex like parenthetical expressions.
If the problem calls for just a few select fields then perhaps you'd be
better served with a front end screen similar to:

Item number   xxxxxxxxxxxxxxx   F4 for list, *ALL for all
Item class    xxxx  F4 for list, *ALL for all
On Hand<      xxxxxxxxxxxxxxxx
and so on...

You can get fancier:  ranges, allowing multiple values, etc.

Rob Berendt

==================
Remember the Cole!


                                                                                
                                         
                    booth@martinvt.com                                          
                                         
                    Sent by:                   To:     MIDRANGE-L@midrange.com  
                                         
                    owner-midrange-l@mi        cc:                              
                                         
                    drange.com                 Subject:     Re: Evaluate 
complex conditions                              
                                                                                
                                         
                                                                                
                                         
                    10/24/00 04:18 PM                                           
                                         
                    Please respond to                                           
                                         
                    MIDRANGE-L                                                  
                                         
                                                                                
                                         
                                                                                
                                         




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
> >
> > +---
> > | 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
> > +---
>
> --
> Terry Grider
> tgrider@arkansas.net
>
>
> +---
> | 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
> +---


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



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

As an Amazon Associate we earn from qualifying purchases.

This thread ...


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.