DSXchange

Hi All

I am wanting to derive the location of $DSHOME\Engine\bin in a routine on a Windows installation. However it seems that this environment variable $DSHOME (or eqivalent) does not exist, or I just cant find it. It is mkdbfile I need run.

I have found the variable "SPackagePath" which returns "E:\Ascential\DataStage\Package". I know I can manipulate this to get what I want, however is there a more direct method.

Thanks in advance.

Just create a systems variable DSHOME and enter E:\Ascential\DataStage\Engine\bin in the value field. Then you can use %DSHOME% in your routine the same way as you use the $DSHOME variable in Unix environment.

Thanks lstsaur, however I have considdered this and would prefer a dynamic solution that does not require re-configuration between environments. Unfortunately they differ from server to server.

I'm not aware of any more direct method, which is why I documented the scriptbeginning from DSPackagePath. Gee, that was so long ago! I'd forgotten it! Must get around to changing the accreditation notice.

Thanks Ray

DSPackagePath it is.

Actually, that's not the case. You could create a small function (exposed by OLE Automation) that read the relevant registry entry and returned the pathname contained therein.

If you're already in DataStage, the System(32) function returns the pathname.