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
Equivalent stage/Universe database
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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?hhh wrote:In one of our project , we dont use server job.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.