|
midrange.com
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 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.
