List of environment variables

ippie02 · Post by **ippie02** » Tue Oct 25, 2005 8:31 am

Looking for a list of all the buit-in environment variables to which I can have access.

Did not find in in the regular documentation. Using Datastage 7.1

thanks in advance

kcbland · Post by **kcbland** » Tue Oct 25, 2005 8:37 am

What are you trying to do? What do you think you will find? Write a simply Sequence job with a command stage to execute "env" and you'll see the environment a job.

ippie02 · Post by **ippie02** » Tue Oct 25, 2005 10:51 am

I'm looking for variables like

Vuser
DSJobName

and so forth.

is there a reference document with all of those variables listed?

kcbland · Post by **kcbland** » Tue Oct 25, 2005 11:32 am

I don't know where vuser applies to DS Server, is this a variable that applies to one of the other tools? As for DSJobName, I wasn't aware that was being pushed into the environment of a job.

Anyone else want to pick this one up because I'm at a loss.

ArndW · Post by **ArndW** » Tue Oct 25, 2005 12:54 pm

vUser and DSJobName are not DataStage environment variables.

ray.wurlod · Post by **ray.wurlod** » Tue Oct 25, 2005 1:53 pm

They (DataStage environment variables) are visible in the Administrator client.

Therefore, they are mentioned in the Administration manual.

However, no list can be "complete" that is customizable.

DSJobName is a DataStage macro, not an environment variable. There are also system variables (having names beginning with "@"). For example the login ID is @LOGNAME. These are listed in the DataStage BASIC manual. Some, though not all, are listed in on-line help - then again, you don't need them all.

kcbland · Post by **kcbland** » Tue Oct 25, 2005 2:01 pm

ray.wurlod wrote:They are visible in the Administrator client.

Now, my eyes are tired, but are they that tired that they didn't see:

Vuser
DSJobName

listed under the environment tab? The post is for Server, but even checking in the Parallel tab didn't yield results. Help out these tired eyes....

ray.wurlod · Post by **ray.wurlod** » Tue Oct 25, 2005 2:11 pm

IF you create them under the User Defined area you will be able to see them!

kcbland · Post by **kcbland** » Tue Oct 25, 2005 2:15 pm

Ahhhh, somehow I feel I walked into that one.

So the posters answer is that the listed variables are something they dreamed up. However, the vanilla variables that come with the product are available in Administrator. There are also the environment variables available for the DS Engine under the dsenv. Lastly, there's the custom ones that you can stick in dsenv or the Administrator client.

ippie02 · Post by **ippie02** » Wed Oct 26, 2005 1:11 pm

thank you. this helped me out.

I could not find a better word than "environment variables" for what I needed.
System variables or macros are indeed so much clearer. thank you all.

kcbland · Post by **kcbland** » Wed Oct 26, 2005 2:59 pm

Do you still have a question?

ray.wurlod · Post by **ray.wurlod** » Wed Oct 26, 2005 5:29 pm

Being new, I suspect that the problem for the OP was simply one of not having the appropriate terminology ready to mind. I believe the question (uncertainty) has been resolved.

vmcburney · Post by **vmcburney** » Wed Oct 26, 2005 7:51 pm

New DataStage users could also benefit from opening up a Transformer and looking at everything available on the right mouse click menu. There are some things on there that even experienced DataStage coders are unaware of.

ray.wurlod · Post by **ray.wurlod** » Wed Oct 26, 2005 9:20 pm

One of the pieces of advice I always give when running the DataStage Essentials class is "right click everywhere!".

There just isn't enough screen real estate to make the whole of the functionality visible. For example who knew that every Director view has a filter? Or that you can view data in Designer without opening the stage properties editor? (These are rhetorical questions and, as such, do not require answers.)