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....
Load SQl from a file at run time
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 81
- Joined: Mon Nov 21, 2005 4:17 am
- Location: Sydney, Australia
- Contact:
Load SQl from a file at run time
SURESH NARASIMHA
Re: Load SQl from a file at run time
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.
How are you seeing 'the session has completed'?suresh.narasimha wrote:I'm able to see the oracle session has completed ...but the control is not back to datastage.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 81
- Joined: Mon Nov 21, 2005 4:17 am
- Location: Sydney, Australia
- Contact:
Load SQl from a file at run time
Hi Chulett
I can see my session completed from Oracle Enterprise manager.
I can see my session completed from Oracle Enterprise manager.
SURESH NARASIMHA