Not able to connect Oracle 11g through 7.5 PX Jobs
Moderators: chulett, rschirm, roy
Not able to connect Oracle 11g through 7.5 PX Jobs
Hi ALL,
I am not able to connect Oracle 11g through Datastage 7.5 PX Jobs, though I am able to do so using Server Jobs.
Please let me know if any settings need to be changed due to this.
I am not able to view data through the Oracle Enterprise Stage when I am doing so.
regards,
Saraswati
I am not able to connect Oracle 11g through Datastage 7.5 PX Jobs, though I am able to do so using Server Jobs.
Please let me know if any settings need to be changed due to this.
I am not able to view data through the Oracle Enterprise Stage when I am doing so.
regards,
Saraswati
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
I am using simple select like, SELECT 'SARASWATI' A FROM DUAL.
Through server Job I am getting 'SARASWATI' after doing a View Data.
Through Parallel Job, I am getting this error:
"No rows were returned from the View Data server command.
Would you like to view the command's output?"
Even if you do an OK, there is nothing in the Command Output.
As mentioned previously the database here is on Oracle 11g.
Through server Job I am getting 'SARASWATI' after doing a View Data.
Through Parallel Job, I am getting this error:
"No rows were returned from the View Data server command.
Would you like to view the command's output?"
Even if you do an OK, there is nothing in the Command Output.
As mentioned previously the database here is on Oracle 11g.
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 1
- Joined: Wed Dec 10, 2008 3:40 pm