View/Custom SQL errors out
Posted: Tue Oct 04, 2005 10:55 am
Hi again, ![Smile :)](./images/smilies/icon_smile.gif)
So, I'm trying to track down a "Abnormal termination of stage...transform detected". Did a reset...nothing. So, I go to try and view the data in the Oracle OCI8 stage. The first stage has custom sql (with variables) running against a view in Oracle. When I run View Data... I get this error:
Problem is, I can't change either for the job to perform as it is supposed to. How do you get custom sql to work with a view in 7.5? This job ran fine in 5.2.2.
![Smile :)](./images/smilies/icon_smile.gif)
So, I'm trying to track down a "Abnormal termination of stage...transform detected". Did a reset...nothing. So, I go to try and view the data in the Oracle OCI8 stage. The first stage has custom sql (with variables) running against a view in Oracle. When I run View Data... I get this error:
If I change the custom sql to generated sql, it works or if I change the view to a table, it works.Error calling subroutine: DSD.Browse (Action=3); check DataStage is set up correctly in project DRDWSrProtDev
Error calling subroutine: DSD.Browse (Action=2); check DataStage is set up correctly in project DRDWSrProtDev
(The connection is broken (81002))
Problem is, I can't change either for the job to perform as it is supposed to. How do you get custom sql to work with a view in 7.5? This job ran fine in 5.2.2.