RE: SQL Question

I was wondering...  couldn't you use the new variables you created on the
as tags?


 Select SMONTH,
        Dec(Sum(ONTSHP),7,0) As TONT,
        Dec(Sum(TOTSHP),7,0) As TSHP,
        Dec(TONT / TSHP * 100.0000 ,7,2) As ON_TIME_P


Ciao!
Michael Schutte
Classic Italian dishes with a Bob Evans Twist - Enjoy our new Homestyle
Pastas!


rpg400-l-bounces@xxxxxxxxxxxx wrote on 11/08/2006 03:54:16 PM:

<snip>

Select SMONTH,
       Dec(Sum(ONTSHP),7,0) As TONT,
       Dec(Sum(TOTSHP),7,0) As TSHP,
       Dec(Dec(Sum(ONTSHP),7,0) / Dec(Sum(TOTSHP),7,0) * 100.0000 ,7,2)
As
ON_TIME_P

</snip>



Thanks, Eric. That did it. First time I have run into this.

--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing

list

To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.