SOURCE AND TARGET STAGE COUNT

aschindler · Post by **aschindler** » Tue May 21, 2013 4:21 am

Hi,

I need to get the link count for source and target for my jobs,i'm able to get source count using DSGetLinkInfo,since DSGetLinkInfo will always return the outgoing link count for a particular stage,its giving target stage count as 0 as target stage is last stage in my job.

source count is the outgoing link count from source stage,but for target that is the last stage.

so i need to get incoming link count to the target stage.

Please let me know how get the target count.

jerome_rajan · Post by **jerome_rajan** » Tue May 21, 2013 4:32 am

The input link to your target stage will be the output link to some stage, right? Pass the name of the penultimate stage that feeds your target as the 'Stage Name'.

ray.wurlod · Post by **ray.wurlod** » Tue May 21, 2013 5:36 am

Use consistent link naming conventions, then you can interrogate the link row counts using a single generic routine.

aschindler · Post by **aschindler** » Tue May 21, 2013 5:46 am

Is there any other option available ,since i can't hardcode the penultimate stage manually as there are more no.of jobs and also my src and tgt stage names are identical for all jobs ie.., src stage name starts with SRC and target with TGT.

so it would be more flexible ,if i can use TGT stage to get count,as i'm retrieving the job details from datastage repository table with where clause : where name like'TGT%'

Please let me know if there is any other option to get the row count flowing into the TGT stage

aschindler · Post by **aschindler** » Tue May 21, 2013 6:18 am

Thanks Prasson,

Can you also tell where can i run these queries and i need to capture the reults in a table.

can i run below query in Universe stage or is there any separate stage to access or query the operation console tables.

Please elaborate.

chulett · Post by **chulett** » Tue May 21, 2013 6:31 am

Are you on "8.7 onwards" as noted?

Your stage in the DSGetLinkInfo() call should be a transformer in a Server job, an active stage. More than likely you can get both source (incoming) and target (outgoing) counts from it.

prasson_ibm · Post by **prasson_ibm** » Tue May 21, 2013 7:27 am

Hi,
No you can not get these information using Universe stage since it is not stored in universe repository.
Which databse you are using for XMETA repository.I think your Opertation tables will be there in same database. If it is you need to connect to that database.

aschindler · Post by **aschindler** » Tue May 21, 2013 9:22 am

Hi Chulett,

I'm using datatstage 8.7 Version.

Can u briefly explain how to get source and target count using DSGetLinkInfo(),since this function by default returning outgoing link count for a particular stage.

But i need incoming count for a particular stage.

chulett · Post by **chulett** » Tue May 21, 2013 10:06 am

If you are on 8.7 then these statistics are already being captured for you. To get "incoming" for a stage, check the "outgoing" from the immediately previous stage.

jerome_rajan · Post by **jerome_rajan** » Tue May 21, 2013 10:10 pm

If on DataStage 8.5 or below, this is what I could think of.

Code: Select all

$INCLUDE DSINCLUDE JOBCONTROL.H
Link_Handle = DSAttachJob(JobName,DSJ.ERRNONE)
PenultimateStageName = DSGetLinkInfo(Link_Handle,TargetStageName,LinkName,DSJ.LINKSTAGE)
Ans=DSGetLinkInfo(Link_Handle,PenultimateStageName,LinkName,DSJ.LINKROWCOUNT)

Disclaimer: There might be a more optimal solution than this.

prasson_ibm · Post by **prasson_ibm** » Wed May 22, 2013 4:31 am

This is what i am doing in my project.

Code: Select all

$INCLUDE DSINCLUDE JOBCONTROL.H
JobName = JobNm
StageName = StageNm
LinkName = LnkNm
hJob1 = DSAttachJob(JobName, DSJ.ERRNONE)
RowInputCount = DSGetLinkInfo(hJob1,StageName,LinkName,DSJ.LINKROWCOUNT)
Ans = RowInputCount

Output of the routine is rowcount,its can be Inputrowcount as well output rowcount,just you need to pass appropiate link name ,stage name and job name.

aschindler · Post by **aschindler** » Wed May 22, 2013 5:27 am

Thanks Jerome,

It worked.