List of all Px Stages

Vinothbaskaran · Post by **Vinothbaskaran** » Thu Dec 11, 2008 7:42 am

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!

ray.wurlod · Post by **ray.wurlod** » Thu Dec 11, 2008 2:21 pm

Code: Select all

SELECT @ID FROM DS_STAGETYPES WHERE @ID NOT LIKE '\\%';

Vinothbaskaran · Post by **Vinothbaskaran** » Thu Dec 11, 2008 10:28 pm

Thank you Ray!

Also can you let me know as where to fire this query?

ray.wurlod · Post by **ray.wurlod** » Thu Dec 11, 2008 11:13 pm

Administrator client Command window or within a dssh shell in the project directory on the DataStage server machine.

Vinothbaskaran · Post by **Vinothbaskaran** » Fri Dec 12, 2008 12:27 am

Thanks Ray!

aaryabhatta · Post by **aaryabhatta** » Fri Dec 12, 2008 4:44 am

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?

aaryabhatta · Post by **aaryabhatta** » Fri Dec 12, 2008 4:45 am

Same error for all tables

=DataStage/SQL: Table "DS_STAGETYPES" does not exist.
=DataStage/SQL: Table "DS_JOBS" does not exist.

Vinothbaskaran · Post by **Vinothbaskaran** » Fri Dec 12, 2008 6:20 am

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...

chulett · Post by **chulett** » Fri Dec 12, 2008 8:06 am

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.

DSXchange

List of all Px Stages

List of all Px Stages

Thanks!

Thanks!

yeah!