PDA

View Full Version : Script Conversion


scuzzy
05-28-02, 17:06
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 help

scuzzy
05-28-02, 18:06
Never mind....

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



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