Hi, all,
I am trying to figure out how to retrieve the value/formula contained in a Stage Variable.
I am using Stage Variables for Reject logic, and I would like to use the logic I have entered to populate a table for supplementary information for error reporting.
I would like to end up with a file like:
VariableName Value
--------------- ------
V1Name If not(isnull(<field1>)) then....
V2Name fieldx <=50
V3Name ....etc
DSGetJobInfo returns the List of Stage Variables...but how can I get the VALUE of the SV?
Retrieving the value of a Stage Variable
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 40
- Joined: Thu Mar 30, 2006 6:30 am
- Location: Near Geneva, Switzerland
- Contact:
sjhouse wrote:All you would need to do is create a output link to a sequential file, set up the constraints appropriately and put the stage variables in the derivation for the appropriate columns in your file.
Also, the formulas can be stored in columns as varchars.
I have tried that solution already, but when I put the Stage Variable name into the transformer, it only results in the VALUE of the formula (0 or 1), not the formula itself.
Any other ideas would be welcome...
thanks
W
The DSGetStageInfo() call will only give you the stage variable names but not the formula/derivations thereof. This metadata is not exposed via any of the APIs. The values are stored in the DS_JOBOBJECTS table but are not meant to be accessed.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 301
- Joined: Thu Jul 14, 2005 10:27 am
- Location: Melbourne, Australia
- Contact:
<b>John McKeever</b>
Data Migrators
<b><a href="https://www.mettleci.com">MettleCI</a> - DevOps for DataStage</b>
<a href="http://www.datamigrators.com/"><img src="https://www.datamigrators.com/assets/im ... l.png"></a>
Data Migrators
<b><a href="https://www.mettleci.com">MettleCI</a> - DevOps for DataStage</b>
<a href="http://www.datamigrators.com/"><img src="https://www.datamigrators.com/assets/im ... l.png"></a>