Operating Control Table?

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
pkll
Participant
Posts: 73
Joined: Thu Oct 25, 2012 9:45 pm

Operating Control Table?

Post by pkll »

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 .
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply