Using Windows System Variables inside Before/After routine

[ggarze]

Is there a way inside a Before/After routine to retrieve a Windows system variable, not a DataStage variable, but a system variable defined on the Windows server?

Thanks

[ggarze]

I actually figured it out. If anyone else needs it you use:

Call DSExecute('DOS', "Echo %WIN_VARIABLE%", return_value, return_code)

The return_value does have a none viewable character at the end so you'll need to leve that off, especially if you are using it as a file path.

[ray.wurlod]

The non-viewable character is the line terminator, converted to a field mark.

Code: Select all

Call DSExecute('DOS', "echo %WIN_VARIABLE%", return_value, return_code) 
Result = Convert(@FM, "", return_value)