Script Conversion

Hey,
Here is an SQL script that works in Sybase and I need a script that does the same thing but works for DB2. Does anyone know what it is?
SELECT type, price, advance FROM test_table ORDER BY type COMPUTE SUM(price), SUM(advance) BY type
Thanks for you helpNever mind...

I discovered that DB2 doesn't support "Compute" rows

__________________________
Help Cure Cancer (http://www.scuzzy.refhost.net/HCC)