Page 1 of 1
List of all Px Stages
Posted: Thu Dec 11, 2008 7:42 am
by Vinothbaskaran
Hi,
Can you let me know the names of all ( atleast most) parallel stages in datastage. I mean the name that Datastage uses.
Eg : for oracle PxOracle ( i want these names )
Thanks!
Posted: Thu Dec 11, 2008 2:21 pm
by ray.wurlod
Code: Select all
SELECT @ID FROM DS_STAGETYPES WHERE @ID NOT LIKE '\\%';
Thanks!
Posted: Thu Dec 11, 2008 10:28 pm
by Vinothbaskaran
Thank you Ray!
Also can you let me know as where to fire this query?
Posted: Thu Dec 11, 2008 11:13 pm
by ray.wurlod
Administrator client Command window or within a dssh shell in the project directory on the DataStage server machine.
Thanks!
Posted: Fri Dec 12, 2008 12:27 am
by Vinothbaskaran
Thanks Ray!
Posted: Fri Dec 12, 2008 4:44 am
by aaryabhatta
I was trying this query, it worked from adminsitrator client but the following error is thrown using dssh command.
=DataStage/SQL: Table "DS_JOBS" does not exist.
Any idea why is it so?
Posted: Fri Dec 12, 2008 4:45 am
by aaryabhatta
Same error for all tables
=DataStage/SQL: Table "DS_STAGETYPES" does not exist.
=DataStage/SQL: Table "DS_JOBS" does not exist.
yeah!
Posted: Fri Dec 12, 2008 6:20 am
by Vinothbaskaran
It d same here too!
In ADMN client it working.. but not in dssh..
btw.. can somebody tell me as how to list all the tables in Datastage SQL prompt??? i.e in dssh...
Posted: Fri Dec 12, 2008 8:06 am
by chulett
ray.wurlod wrote:Administrator client Command window or within a dssh shell in the project directory on the DataStage server machine.
Either that or "LOGTO" the project in question after you connect.