SEETING UP PROJECT DEFAULTS
Moderators: chulett, rschirm, roy
SEETING UP PROJECT DEFAULTS
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
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.)
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.)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 1044
- Joined: Wed Sep 29, 2004 3:30 am
- Location: Nottingham, UK
- Contact:
Re: SEETING 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.waitnsee wrote:Can anyone tell me how to set up project defaults.
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.
Phil Hibbs | Capgemini
Technical Consultant
Technical Consultant
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
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.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
Best not to rush to conclusions.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
-
- Premium Member
- Posts: 1255
- Joined: Wed Feb 02, 2005 11:54 am
- Location: United States of America
Posted: Thu Apr 07, 2005 12:23 amkumar_s wrote:Good to see a doubt got clarified after 3 years.
Posted: Mon Jan 08, 2007 4:11 pm
Isn't it more like a year and a half?
Anything that won't sell, I don't want to invent. Its sale is proof of utility, and utility is success.
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: