DSXchange

I have this query,

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. OCI it create the following err.

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

rahim, send a list of the column definitions in the stage...it would be helpful to us...

-Ken





rahimladha@hotmail.com on 01-Aug-2001 17:14



Please respond to datastage-users@oliver.com

To: datastage-users
cc:
Subject: Oracle Decode problem in DataStage


I have this query,

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. OCI it create the following err.

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