Load SQl from a file at run time

suresh.narasimha · Post by **suresh.narasimha** » Mon Aug 18, 2008 8:36 pm

Hi

I'm trying to select data using OCI 8 stage ( Source ) with the query type option as Load SQl from a file at run time.

I'm able to see the oracle session has completed ...but the control is not back to datastage.

The job is still running with no data selected.

Im using datastage 7.5.1A

Suggestions please....

chulett · Post by **chulett** » Mon Aug 18, 2008 9:00 pm

Loading the sql at runtime from a file doesn't fundamentally change how queries behave. Meaning it will behave the same as if you'd entered that query in the stage itself, so that in and of itself isn't the issue here.

suresh.narasimha wrote:I'm able to see the oracle session has completed ...but the control is not back to datastage.

How are you seeing 'the session has completed'?

suresh.narasimha · Post by **suresh.narasimha** » Mon Aug 18, 2008 11:08 pm

Hi Chulett

I can see my session completed from Oracle Enterprise manager.

chulett · Post by **chulett** » Tue Aug 19, 2008 7:17 am

Right. I meant define 'complete'. Session not active? Cursors closed? What does your DBA say is going on? Or is that you? Seeing as how you have OEM.

DSXchange