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 .
Operating Control Table?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.