Re: sum in SQL?

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>]

Sounds like a nice product. But STRQMQRY gives you some of that
functionality and is included in OS/400 - and might be adequate for many
projects. E.g., if you have a replacement variable but do not specify its
SETVAR on STRQMQRY, you are prompted for the value. As someone mentioned,
you don't even have to get the SQL licensed product, unless you want to
customize reports more easily than fighting with query management tags.

Drill down is NOT a part of it, however.

All in all, IMO, an under-utilized, very flexible mechanism.

Cheers

Vern

At 06:31 AM 12/12/2002 -0600, you wrote:
> Nah, too much effort, even if you're doing it for a report. What's even
> cooler is the ability to prompt for the variable when the user clicks an
> icon on their desktop, and launches the ViewPoint piece of the software.
>
> I just did a project for a JDE client in Cleveland. The client was having
> problems with highlighting its problem receivables. I created a view where
> the collector is prompted for a collector code and the number of days old
> for outstanding invoices. A few seconds after clicking OK, a display pops up
> showing customer number/name, amount, invoice number, contact info and age
> of the invoice. This is sorted in descending order by age, so the collector
> can "go get 'em". Also, while the collector is talking to the customer, and
> needs to see details about an invoice, they can then "drill down" to the
> invoice line item level.
-snip-

> Paul Nelson
> 630-327-8665 Cell
> 708-923-7354 Home
> ----- Original Message -----
> From: "Don" <dr2@cssas400.com>
> To: <midrange-l@midrange.com>
> Sent: Wednesday, December 11, 2002 9:30 PM
> Subject: Re: sum in SQL?