DSXchange

masterControl table .Below are the fileds of the table

MasterProcess Identifier
Process Start timestamp
Process End timestamp
Process Control Status Code
Valuation date
Fixed variable indicator
Lastupdate time stamp

Please let me know how to update the control table fields .
I need to capture each time my process start timestamp and process end timestamp and whether it is fixed or variable load .

First let me stress that this table is something your site has created, it's not part of DataStage out of the box.

I would imagine that MasterProcess Identifier has its value generated within a master controlling sequence which then passes it to all other jobs, including the one that updates your control table, via a job parameter.

The next three can be resolved via calls to the DataStage API (in particular the DSGetJobInfo() function).

I have no idea what ValuationDate is supposed to do. Presumably your site has documentation explaining this. And the same is true of FixedVariableIndicator.