DSXchange

I have some Jobs in Develoment environment which is having various Job parameters(Database username,Database password etc) defined in one parameter set.These Job parameters are different from Development ,Test and production environment.How to make sure that no changes should be done to the Datastage Jobs so that it will use new values depends upon environment?

Use Values Files with your Parameter Sets, and protect the higher environment projects.

I think even i am using different value files [ex-valuefile1 consists of parameters related to Test environment and
valuefile2 consists of parameters related to Production environment] while running the Job depends on environment I have to select the value file manually.I do not want to do this because I should not do any changes or manual selection after jobs are deployed in Test and production environment.Please correct me i am wrong?

How do You pass the Value-file to be chosen to your jobs? As a hardcoded string on the sequence?

Usually I'd expect you to pass the parameter-set itself to the job without choosing the name of the value-file. The value-file is then chosen at runtime when starting the activity that calls the job. This can be a different file in different environments.

you can pass the different value as parameter. if you are triggering the sequencer from unix script.