How to use config files in Datastage

Riku · Post by **Riku** » Mon Feb 18, 2008 10:40 pm

Friends,can any one give me ideas how to call config files in Datastage job.We already use job parameters on this issue but want to use config files for more easy mentainability.Please help.

We are using:

IBM Information Server-Server Job
Windows 2003 R2
Oracle 10g R2

ray.wurlod · Post by **ray.wurlod** » Mon Feb 18, 2008 11:27 pm

Please be more specific about what you mean by "config" files.

For example you can have files (or tables) that describe order of execution, dependencies, parameter values, and lots of other things too.

Riku · Post by **Riku** » Tue Feb 19, 2008 12:38 am

ray.wurlod wrote:Please be more specific about what you mean by "config" files.

For example you can have files (or tables) that describe order of execution, dependencies, parameter values, and lots of other things ...

Config file contains info like:
File name
db user name
db password ...etc

ray.wurlod · Post by **ray.wurlod** » Tue Feb 19, 2008 1:43 am

So it's basically a list of job parameter values. How is each to be reconciled to a particular job parameter?

Do you have any in-house standards for parameter names in jobs, following the "one thing, one name" principle? Now is a good time to start. Think about other components that it would be wise to name in a conventional manner.

deanwalker · Post by **deanwalker** » Tue Feb 19, 2008 5:23 am

Release 8 ? Please take a look at the documentation on Parameter Sets.