SELECT
BILL_TO,
NVL(SUM(expense.quantity),0.00) qty
NVL(SUM(decode(expense.expense_type,REV,expense.total)),0.00) rev FROM expense WHERE expense.id=268435656 GROUP BY bill_to
When I run that query in SQL*Plus, it runs perfect but when I try to run in
DataStage using Oracle(v.
![Cool 8)](./images/smilies/icon_cool.gif)
Error calling subroutine: *DataStage*DSR_SELECT (Action=2); check DataStage
is set up correctly in project esidwdev
(The connection is broken (81002))
What Im doing wrong???
thanks in advance.
Rahim
Rahim Ladha
e-mail : rahimladha@hotmail.com
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp