DSXchange

Can anyone tell me how to set up project defaults.
Say I have a database, userid and password how do I set it to default values in the job parameters.
(ie) How do I define them as environment variable and set it to $PROJDEF in Datastage jobs.

Thanks
WNS

Set them up using the Administrator client. There is a command button for the project properties with Environment Variables as its caption. This is where you need to be to set up user-defined environment variables.

When creating job parameters in server jobs, you can use the environment variable directly. There is a command button in the Job Parameters page for doing so. (You can actually link back to the window where you create the environment variables from here, too.)

Ray,

Adding environment variable works both from administrator as well as designer. but as far as assigning default value, we can only assign in administrator. In designer it only prompt for parameter name & prompt.

waitnsee wrote:Can anyone tell me how to set up project defaults.

Others have answered the main question, my tip is to make a backup of the DSParams file in the project directory .../Ascential/DataStage/Projects/ProjectName as this is where they are stored. You can copy this file from one project to another, I don't think there is anything in it that causes problems when this is done. It makes creating new projects a lot easier.

We have separate projects for development, QA, and production, and use Manager's export and import functionality to promote code. Backing up and copying the DSParams has saved my sanity more than once.

Can somebody tell me how to associate values to those environment variables ? Is it by editing the DSParams file ? Is there any other simpler way to do the same?

Thanks in advance

There is a FAQ now on how to set and use project specific environment variables. You can change them by modifying the DSParams file directly or by using the DataStage Administrator tool and finding the Environment Variables button. If you want an encrypted parameter your only option is to set it through a DataStage product such as Administrator or Director, it is difficult to set it directly in a file.

That resolves my doubt. Thanks vmcburney

Good to see a doubt got clarified after 3 years.

Best not to rush to conclusions.

kumar_s wrote:Good to see a doubt got clarified after 3 years.

Posted: Thu Apr 07, 2005 12:23 am
Posted: Mon Jan 08, 2007 4:11 pm

Isn't it more like a year and a half?

Seems like three years!

<sings>Tried for three years, seems like thirty...</sings>
(Jesus Christ Superstar - Tim Rice and Andrew Lloyd Webber)