Accessing different Project info from existing project
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 22
- Joined: Thu Jul 29, 2004 8:10 am
Accessing different Project info from existing project
Hi
I need to access some project info from the existing project. Meaning, lets say, I'm querying for category information in UV as below..
SELECT CATEGORY FROM DS_JOBS WHERE NAME='JobName';
I need to get the same information for the job which is there in different project. How do I query the different project being there in the existing one?
Many thanks
Ahmed.
I need to access some project info from the existing project. Meaning, lets say, I'm querying for category information in UV as below..
SELECT CATEGORY FROM DS_JOBS WHERE NAME='JobName';
I need to get the same information for the job which is there in different project. How do I query the different project being there in the existing one?
Many thanks
Ahmed.
I'm not quite sure what you are looking for in this case. Each project has it's own DS_JOBS hashed file so you cannot directly query this file across several projects.
<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:
Oh yes you can! Just qualify the table name (DS_JOBS) with the schema name.
UniVerse/SQL (DataStage/SQL) is compliant with standards, so supports qualifying a table name with a schema name. Each project is a schema.
Code: Select all
SELECT CATEGORY FROM Project2.DS_JOBS WHERE NAME = 'OtherJob';
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.
-
- Participant
- Posts: 22
- Joined: Thu Jul 29, 2004 8:10 am
Re: Accessing different Project info from existing project
Not sure what information you need but you may be able to get it by using the command line utility "dsjob". If it's specifically the category you need then this won't help, but there's plenty more useful info available...
Regu.
Regu.
Me neither, but the docs state that it should work; I've tried a number of UV_SCHEMA definitions and decided to wait for Ray to post a response. I have 7.5.x as well.
<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: