DSXchange

I have installed DS Server on windows.
I need to get the following infomation about Job:
No. of rows processed
No. of rows affected
No. of rows rejected
Could you please tell which function or logic I need to implement to get this information.

Thanks in advance.

No. of rows processed is captured automatically, and is logged in the "active stage finishing" event in the job log, is viewable using the monitor, and can be captured with DataStage API functions (which includes the dsjob command line interface).

No. of rows affected is something you'll need to ask your database server about - it's not a piece of information DataStage records. DataStage will only tell you how many rows it sent to the database server.

No. of rows rejected may or may not be accurately reported, depending on the array size setting you choose. If you choose an array size of 1, then it will be accurate, and regular reject handling will capture the rejected rows, enabling you to send them somewhere else and, yes, to count the rows passing along that link.

Can you please tell me the specific API function as i have tried out but couldn't find out any.

Thanks in advance.

DSGetLinkInfo() or DSGetStageInfo()