Record count

srinivas143 · Post by **srinivas143** » Thu Oct 02, 2008 6:37 am

Hi All,

I want to extract the record count of the data loaded into the target.

Some body can help me how to get the info by using a routine..some thing like as below.

pJobStatus = DSGetJobInfo (DSJ.ME,DSJ.JOBINTERIMSTATUS)

Could you pls help me.

Kind Regards

Minhajuddin · Post by **Minhajuddin** » Thu Oct 02, 2008 6:46 am

This can be easily accomplished by writing a basic routine which counts the number of records on a *link* attached to a *stage* in a particular *job*.
However, keep in mind that it is best to run this routine after the job which does the loading. As for the routine you can find plenty of them on this site just do a search for DSGetLinkInfo.

srinivas143 · Post by **srinivas143** » Mon Oct 06, 2008 10:13 am

Hi

Any sample code for this??

Kind Regards

chulett · Post by **chulett** » Mon Oct 06, 2008 11:07 am

Code? There certainly are usage examples of the DSGetLinkInfo function in the online help.

ArndW · Post by **ArndW** » Mon Oct 06, 2008 11:11 am

Or use search to look for example DSGetLinkInfo in DSXchange.

srinivas143 · Post by **srinivas143** » Mon Oct 06, 2008 11:21 am

Thank you ...I will look into those...