DSXchange

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

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

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

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? ...

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.

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