DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
pongal
Participant



Joined: 04 Mar 2004
Posts: 77

Points: 962

Post Posted: Wed Sep 07, 2005 3:34 am Reply with quote    Back to top    

DataStage® Release: 7x
Job Type: Parallel
OS: Windows
Hi,
i have read some posts regarding $Projdef project specific env variable.
i am not still understanding the use of $Projdef env variable.
how to use exactly this variable ?
i have created some env variables at dsadmin like
$Par_SrcFilePath
$Par_TrgFilePath
$Par_remoteUserID
$SRC_DBNAME etc where some of the env variables have values that does not change in all the environments (DEV,INT,PROD)
where can i define all the static env variables using $Projdef ?
tusharzade
Participant



Joined: 15 Dec 2004
Posts: 13

Points: 90

Post Posted: Wed Sep 07, 2005 3:50 am Reply with quote    Back to top    

Hi Pongal,

$PROJDEF is a default value assigned in the job parameter of any Datastage job. Now consider the scenario where administrator wants to keep some password which should not be accessed by the developer. Then in this scenario administrator can set the password for Suppose DB login in a administraor for user defined varialble. Then You can use the same variable in your job but with the default value as $PROJDEF. So that whenever you administrator wants to change the password he do not need to inform you. Your job will take the value which is defined in the administrator.

Regards,
Tushar
Rate this response:  
Not yet rated
PhilHibbs



Group memberships:
Premium Members

Joined: 29 Sep 2004
Posts: 1042
Location: Nottingham, UK
Points: 12362

Post Posted: Wed Sep 07, 2005 5:32 am Reply with quote    Back to top    

Which version of DS are you using? $Projdef doesn't work on 7.0.1.

_________________
Phil Hibbs | Capgemini
Technical Consultant
Google+ Data Tools Page
Rate this response:  
Not yet rated
pongal
Participant



Joined: 04 Mar 2004
Posts: 77

Points: 962

Post Posted: Wed Sep 07, 2005 6:08 am Reply with quote    Back to top    

i am using DataStage v 7.5.1a.
i have another doubt that using $Projdef, can we define any number of user defined env variables ?
how could we define the below user defined env variables having default values using $Projdef?
$Par_SrcFilePath
$Par_TrgFilePath
$Par_remoteUserID
$SRC_DBNAME
Rate this response:  
Not yet rated
trokosz



Group memberships:
Premium Members

Joined: 16 Sep 2004
Posts: 188

Points: 1132

Post Posted: Wed Sep 07, 2005 4:21 pm Reply with quote    Back to top    

You define the user defined environment variables in Administrator. Now give them the values you want. Then when you create your Job in Designer you select those environment variables relevant that you defined....and for the value you say $PROJDEF or it gets the value entered in Administrator.

Now this comes to a big topic on how to change environment variables without entering dataStage....or creating a *.ini or *.config file that is inherited by DataStage.....but thats not what you asked but consider it.....

There is a known bug with $PROJDEF and that is if you use this technique and use the DRS Stage.....then then View data on the DRS Stage fails.....

Good luck
Rate this response:  
Not yet rated
vmcburney

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup

Joined: 23 Jan 2003
Posts: 3527
Location: Australia, Melbourne
Points: 27331

Post Posted: Wed Sep 07, 2005 5:49 pm Reply with quote    Back to top    

There is a FAQ on this topic. You can read it at:
http://www.dsxchange.com/viewtopic.php?t=92038

Or you can view the modifiable version at:
http://wiki.ittoolbox.com/index.php/HOWTO:DataStage:_Setup_and_use_project_specific_environment_variables

_________________
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn: Vincent McBurney LinkedIn
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours