DSParam and DSEnv file

sharmabhavesh · Post by **sharmabhavesh** » Tue Jan 15, 2013 5:41 am

We are starting with a new data migration project. In the meanwhile, I have been asked to create DSParam file.
I am not sure what exactly is the difference between DSParam and DSEnv file. Tried searching but didn't get anything worthwhile. Can anyone please help?

chulett · Post by **chulett** » Tue Jan 15, 2013 8:25 am

DSparam is automatically created for you. So what exactly have you been tasked with? Do you have an existing project they want you to transfer DSParam information from?

sharmabhavesh · Post by **sharmabhavesh** » Tue Jan 15, 2013 2:55 pm

Thanks Chulett
Actually niether me nor my manager knows much about Datastage

:P. So he asked me to find out how DSParam file is created. Now you have answered to the creation part.
I am now curious to know if DSParam file is different from DSEnv file. If yes, how?

ray.wurlod · Post by **ray.wurlod** » Tue Jan 15, 2013 3:46 pm

Well, you could look at them. Incidentally, there is no file called DSParam (it's called DSParams).

There is one dsenv file. It resides in the DSEngine directory and, primarily, sets up environment variables globally for all DataStage processes.

There is one DSParams file for each project. It resides in the project directory and stores settings - including environment variables - created in the DataStage and QualityStage Administrator client.

If an environment variable exists in both locations, the value in DSParams takes precedence.