Counting number of row level constraints used in a Job

Django · Post by **Django** » Wed Aug 19, 2009 6:10 am

Hi,

I have a requirement for counting the number of row level constraints used in transformer for a complex datastage server job. Kindly let me know if there's any way to get the count.

Thanks in advance

ArndW · Post by **ArndW** » Wed Aug 19, 2009 6:33 am

Do you mean how many stage output links have constraints or how many rows go through those constraints at runtime?

chulett · Post by **chulett** » Wed Aug 19, 2009 7:07 am

Open the job, open each transformer and count. You did say "a" job, after all.

Django · Post by **Django** » Wed Aug 19, 2009 11:36 pm

I have to count the number of stage output link which has constraints.

ArndW wrote:Do you mean how many stage output links have constraints or how many rows go through those constraints at runtime? ...

Django · Post by **Django** » Wed Aug 19, 2009 11:54 pm

We are trying to come up with a datastage job which can study any other complex server job.

For Example:
To find the number stage variables used in a job.
"DSGetStageInfo(hJob,stagename,DSJ.VARLIST)" function can be used in the Job Control to get the list of stage variables.

Now my requirement is to get the count for row level constraints used in the job.

chulett wrote:Open the job, open each transformer and count. You did say "a" job, after all.

kduke · Post by **kduke** » Thu Aug 20, 2009 1:46 am

I would export the jobs and do a string search. Otherwise you will need to learn the repository tables.