Equivalent stage/Universe database

hhh · Post by **hhh** » Fri Sep 22, 2006 12:29 am

We have universe database stage in server job so what is corresponding stage or any utility in PX ?
As i want to find out all job name in current project.
Please suggest me on this topic.

Regards,
Hiten

ray.wurlod · Post by **ray.wurlod** » Fri Sep 22, 2006 4:10 am

Why not use a server job?

hhh · Post by **hhh** » Fri Sep 22, 2006 4:30 am

Hi Ray,
In one of our project , we dont use server job.
[quote="ray.wurlod"]Why not use a server job? ...[/quote]

ArndW · Post by **ArndW** » Fri Sep 22, 2006 6:22 am

The DataStage PX product does not have the capability out of the box of directly reading UniVerse or DataStage Hashed Files. This is why Ray politely suggested using Server.
If you need to process Hashed files you will need to use ODBC in PX jobs or write your own stage. I suggest you see if you can make an exception in this project and use a server job, if only to read the file into a dataset. This will save many hours of work.

ray.wurlod · Post by **ray.wurlod** » Fri Sep 22, 2006 4:58 pm

hhh wrote:In one of our project , we dont use server job.

Why not? You have it. If you own a set of screwdrivers, do you elect not to use some of them on some ideological basis?

If you really must use a parallel job - and I again state that there is no good reason to here - then you can construct an appropriate query to be executed in an External Source stage.