Accessing different Project info from existing project

[ahmediftikhar]

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.

[ArndW]

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.

[ray.wurlod]

Oh yes you can! Just qualify the table name (DS_JOBS) with the schema name.

Code: Select all

SELECT CATEGORY FROM Project2.DS_JOBS WHERE NAME = 'OtherJob';

UniVerse/SQL (DataStage/SQL) is compliant with standards, so supports qualifying a table name with a schema name. Each project is a schema.

[kduke]

Nice one, Ray. Learn something all the time.

[chulett]

Seconded... had no clue you can do that.

[ahmediftikhar]

Ray, No luck... I tried with the syntax u gave.

Any other clue.

[rsaliah]

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.

[kduke]

Ray

It did not work for me either. Ds7.5.1A

[ArndW]

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.

[ray.wurlod]

Initial response is that it works in UniVerse/SQL. I will test using DataStage/SQL and let you know.