Hi, Is there a way to materialize environment variables (those variables defined in administrator for a project ) in a transformation stage? I see the ability to materialize local variables. I'm looking to place the value of these variables as actual data in a sequential file.
I'm not really set on using a transformation stage if there is some other way to do this. Example would be a environment variable with the database name in it.
thanks!
materializing environment variables in a datastage job
Moderators: chulett, rschirm, roy
I'm not at a workstation where I can test this now, but if you cannot use the user-defined variables directly, then you declare them as part of your job parameters, call them with a value of "$PROJDEF" and use them in the transform stage.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
You need to have created them in the project via the Administrator first, did you do so? If you did, you'd need to expand a teeny bit on the problem you are having. Saying "not able to materialize" doesn't really give us much to go on.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
I believe you are looking for function: GetEnvironment, because you cannot use Environment Variables directly in a transformer like the job parameter. You have to call the function to return the value for you.
Pneuma Lin.
pneumalin@yahoo.com
pneumalin@yahoo.com