parameter set clarification

vamsi.4a6 · Post by **vamsi.4a6** » Mon May 06, 2013 12:48 am

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?

ray.wurlod · Post by **ray.wurlod** » Mon May 06, 2013 1:43 am

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

vamsi.4a6 · Post by **vamsi.4a6** » Mon May 06, 2013 3:46 am

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?

BI-RMA · Post by **BI-RMA** » Mon May 06, 2013 4:58 am

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.

sultan@cts · Post by **sultan@cts** » Mon May 06, 2013 5:12 am

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