Re: SQL

["Buck" <buck.calabro@xxxxxxxxxxxx>]

> The raw data is a file from Premenos. There is some simple filtering such
as
> an Active status, only want in this case 850's, and so on. So I created a
file
> out of this. Then in a different statement I do a Select Distinct, so as
to weed
> out dups. Now this Select Distinct prints out just the names. I would like
to
> provide a simple sequential number, w/ a total. Bear in mind, that this
simple
> report will likely grow into something far more interesting.

Excellent!  I have a much better idea where you're headed now.

Here's how I would do this in RPG.  (RPG because that's the list, and
becuase if will allow you to be maximally flexible - moreso than a simple
query.)

define a DS externally described, based on your work file

Declare a cursor
set counter to 1

loop
  fetch next into the DS
  exit loop if end of data
  increment counter
  print line, including counter
repeat
print total line, using last value of counter

  --buck