Re: Query question

[Dean Booth <dbooth@xxxxxxxxxxxxxxxx>]

I don't know about backwards, but the fact that we need these clever workarounds
in order to do conditional defines is absurd.  My vote for the most clever goes
to the person using data as a parameter in the substr command.

I was going to submit my "zipneg" logic, where I create a field that is equal to
zero if another numeric value is negative.  Turn off rounding, add a big 
constant
to your value and divide by the same big constant.  You'll get 1 if the number 
is
positive, 0 if negative ("zip" if "neg"-ative) provided your big constant is
bigger than any value of the data.  Then multiply your data by zipneg to
eliminate negative values.

After coming up with this trick I was briefly proud of myself, then I shuddered
in horror as I realized where my career path had taken me.  Does "stone knives
and bearskins" ring any bells?  Don't get me wrong:  I deeply appreciate how 
much
effort the developers of Query put into functions that process time to the
microsecond, and also DBCS processing.  One of these days I'm going to find out
what DBCS is.

What do you all use to quickly pump data out of the system?  What products out
there are *lots* better that Query?

thanks, Dean

"Draper, Dale" wrote:

> Uh, aren't we going backwards here? This whole thing started when someone
> decided that On/Off could be replace with 1's and 0's. :)
>
> +---
> | 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
+---