DSXchange

Posted: **Tue Jan 18, 2011 12:04 am**

Can anybody share a subroutine which returns the count from the source stage link and to a target stage link and to a reject stage link. It is very urgent.

Posted: **Tue Jan 18, 2011 3:18 am**

Use a simple basic routine and here is a sample:

Code: Select all

DEFFUN svtGetLinkCount(JobName, StageName ,LinkName) CALLING "DSU.COUNT.FILES"

*************************************************************************************************************************
* Header files to be included
*************************************************************************************************************************
#include DSINCLUDE JOBCONTROL.H

Ans = 0

*************************************************************************************************************************
* Create local variable for arguements
*************************************************************************************************************************
ThisJob = JobName
ThisStage = StageName
ThisLink = LinkName

*************************************************************************************************************************
* Get the handle of the job
*************************************************************************************************************************
JobHandle = DSAttachJob(ThisJob, DSJ.ERRFATAL)

*************************************************************************************************************************
* Get row count for the link
*************************************************************************************************************************
Result = DSGetLinkInfo (JobHandle, ThisStage, ThisLink, DSJ.LINKROWCOUNT)

*************************************************************************************************************************
* Release the handle
*************************************************************************************************************************
Nothing = DSDetachJob(JobHandle)

*************************************************************************************************************************
* Return the row count
*************************************************************************************************************************
Ans = Result

Return(Ans)

Posted: **Tue Jan 18, 2011 4:05 am**

We don't do "urgent". We especially don't do "very urgent". DSXchange is an all-volunteer site whose members post as and when they can. If you need urgent help, sign up with your official support provider for priority service and learn just how much "urgent" costs.

My own observation: Nothing properly planned gets the chance to be urgent.

Posted: **Tue Jan 18, 2011 5:16 am**

Where and how can i call this routine kirtikumar?

Posted: **Tue Jan 18, 2011 5:58 am**

Hi Pradeep,

Do not post empty messages . Do not try to prove a point which is incorrect.
Try to learn.

Regards
Sreeni

Posted: **Tue Jan 18, 2011 8:01 am**

Not empty but sometimes people put their only message in the subject line of their reply and you can only see it when you reply. And people still seem to think the only way to reply in a thread is to quote another one in its entirety... sheesh.

Fixed both.

DSXchange

Routine for getting the count in the link

Routine for getting the count in the link