job id & sequence id

dodda · Post by **dodda** » Thu May 14, 2009 9:14 am

Hello

I have a requirement where i need to get the Unique job id and unique sequence id which are unique to every job and every sequene and insert those values in the database.

I have searched through forums and didnt find proper answer.

Appreciate if you can help

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu May 14, 2009 9:48 am

Aren't there name unique ?

dodda · Post by **dodda** » Thu May 14, 2009 10:11 am

yes jobnames are unique. but the requirement is to have the job id and sequence id.

please help me in getting those values

Thanks

priyadarshikunal · Post by **priyadarshikunal** » Thu May 14, 2009 10:20 am

Whats the requirement?
can't you generate a surrogate key which will serve as unique id.

chulett · Post by **chulett** » Thu May 14, 2009 10:31 am

What are you considering to be the "unique sequence id"? Do you mean the internal number DataStage assigns at job creation time? If so, you do realize this isn't a static value, yes? It can change over the life of the job.

ray.wurlod · Post by **ray.wurlod** » Thu May 14, 2009 4:59 pm

Code: Select all

SELECT NAME, JOBTYPEIND FROM DS_JOBS WHERE NAME NOT LIKE '\\%';

If you like you can build a DataStage job to use this query in a UniVerse stage (DSN = localuv) and use the results to populate your database table.