DSXchange

How to change the Environmental variable in Parallel job

If it is pointing to a certain folder then how do we change it to point to another folder

where should we change....and what should we change?

thanks
aschand

You can change Environmental variable value in many ways:

DataStage Administrator (Where? : Change the value column)
Using C/C++ API (the DataStage development kit) you can build a self-contained program that can run anywhere on your system, provided that it can connect to a DataStage server across the network.

How to change the Environmental variable in Parallel job ?

Using the above specified API in a parallel routine (Make sure you don't call this routine simultaneously to change the same Environmental variable).

Sorry But I could not understand much out of what you said...

if we go to job parameters in job properties.... we have an add environmental variable button where in we have all the general, customised, parallel, user defined one.... so which one of those environmental varialbles i should be changing inorder to change the input directory.

Can you please help me with some description it will have in general where we point the input directory

thanks
aschand

Search for "DSParams" or "Environment vairable" to know more about this. Not sure which input directory you are talking about.

I am not sure what exactly you want to change ..but if you want to change some variable in user_defined category then .... go to datastage administrator...in that select the project tab...in that go to properties button.......then to environment .....and to then look into the User Defined category....
If you want to change the category of some variable then this link might help you:
viewtopic.php?t=115178

If you want to change the value when you request a job run, add the environment variable to the job as a job parameter. Set the default value of the job parameter to be $PROJDEF or $ENV. The first will pick up the value from whatever has been set in Administrator, the second will pick up the value from the executing user's operating system shell.

To change the value, simply provide a value when submitting the job run request. This will cause DataStage not to pick up the default value.

the environmental varialble is pointing to a directory where the source is data file is placed

now the source data file is in another directory.... so which environmental variable shoould i be changing inorder to make that change

this Environmental varaible is only for a this particular job

thanks
aschand

How can you not know what variable to change? How can you expect us to know?

Just change the value associated with it in the Administrator... it is defined there, is it not?

Are you talking about the fold where Datasets are landing?

If yes than you need to change your node configuration file to point the "resource disk" to the correct folder.

aschand wrote: this Environmental varaible is only for a this particular job

Are you sure its an environment variable and not a simple job parameter?

gateleys wrote:

aschand wrote: this Environmental varaible is only for a this particular job

Are you sure its an environment variable and not a simple job parameter?

Follow These 2 steps :

Step 1:

1) Login DataStage Administration
2) Select your project and click on Properties button.
Note:- You will get your project properties screen.
3) In the General Tab, click on the Environment Button.
Note:- you will get Environment Variables screen.
4) Go to Categories-->Select User Defined -->Modify the value of variable , which you are looking.
5)click on OK button
Note:- You will back to your project properties screen.
6)click on OK button
Note:- You will go back to the Project selection screen.
7) Click on Close button.
Note:-DataStage Administration screen will be closed.

Step 2 :

1) Login into you DataStage Designer .
2) Select your looking Job
3) Select Job Properties.
4) Go to Parameters Tab
5) check the Parameter name has default value as $PROJDEF, if not select.
Note:- Even you can give the full path as a Default Value.
6) click on OK.
7) Compile and Run the job.

Thank you so much.

Can you help me with another doubt.

the post name is "columns not propagating"

Are you involving your support provider in all these "doubts"? It is important for your support provider to be aware of the problems at your site if proper support is to be provided.