Datastage userid as parameter
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 43
- Joined: Mon Jan 15, 2007 10:53 pm
Datastage userid as parameter
Hi.
Could anyone of you tell me how I can get the value of the userid that I use to log into Datastage Designer as a parameter to be used in processing?
Could anyone of you tell me how I can get the value of the userid that I use to log into Datastage Designer as a parameter to be used in processing?
Regards,
Vivek D. Reddy
__________________________________________
If knowledge can create problems, it is not through ignorance that we can solve them. - Isaac Asimov
Vivek D. Reddy
__________________________________________
If knowledge can create problems, it is not through ignorance that we can solve them. - Isaac Asimov
-
- Premium Member
- Posts: 301
- Joined: Thu Jul 14, 2005 10:27 am
- Location: Melbourne, Australia
- Contact:
Hi vivekreddy ,
I'm on Unix so can't check this for you at the moment but I believe under Windows you should be able to use the environment variables NAME, USER, or USERNAME.
(For the record it's 'LOGNAME' under Unix)
HTH,
John.
I'm on Unix so can't check this for you at the moment but I believe under Windows you should be able to use the environment variables NAME, USER, or USERNAME.
(For the record it's 'LOGNAME' under Unix)
HTH,
John.
<b>John McKeever</b>
Data Migrators
<b><a href="https://www.mettleci.com">MettleCI</a> - DevOps for DataStage</b>
<a href="http://www.datamigrators.com/"><img src="https://www.datamigrators.com/assets/im ... l.png"></a>
Data Migrators
<b><a href="https://www.mettleci.com">MettleCI</a> - DevOps for DataStage</b>
<a href="http://www.datamigrators.com/"><img src="https://www.datamigrators.com/assets/im ... l.png"></a>
-
- Participant
- Posts: 43
- Joined: Mon Jan 15, 2007 10:53 pm
-
- Participant
- Posts: 43
- Joined: Mon Jan 15, 2007 10:53 pm
-
- Premium Member
- Posts: 301
- Joined: Thu Jul 14, 2005 10:27 am
- Location: Melbourne, Australia
- Contact:
vivekreddy,
Where are you looking for the environment variables? Try this:
- In Job Properties Parameters tab click "Add Environment Variable"
- Click 'New' (at the top) and create the variable USER, then select it from the list to add it to your job
- In your job give the USER parameter the default value $ENV
Let us know how this goes.
HTH,
John.
Where are you looking for the environment variables? Try this:
- In Job Properties Parameters tab click "Add Environment Variable"
- Click 'New' (at the top) and create the variable USER, then select it from the list to add it to your job
- In your job give the USER parameter the default value $ENV
Let us know how this goes.
HTH,
John.
<b>John McKeever</b>
Data Migrators
<b><a href="https://www.mettleci.com">MettleCI</a> - DevOps for DataStage</b>
<a href="http://www.datamigrators.com/"><img src="https://www.datamigrators.com/assets/im ... l.png"></a>
Data Migrators
<b><a href="https://www.mettleci.com">MettleCI</a> - DevOps for DataStage</b>
<a href="http://www.datamigrators.com/"><img src="https://www.datamigrators.com/assets/im ... l.png"></a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If it's in a job sequence you can use the system variable @LOGNAME in an expression, or use an Execute Command activity to retrieve the value of the environment variable that contains your user ID. Since you're in the parallel forum, I'm guessing you are on 7.5x2, and can therefore retrieve it from the MKS Toolkit shell with echo $USERNAME
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.
-
- Participant
- Posts: 43
- Joined: Mon Jan 15, 2007 10:53 pm
Hi.
Sorry, but I can't read the premium content part.
Is there some way you could explain it to me without that part disappearing behind the premium content curtain?
Sorry, but I can't read the premium content part.
Is there some way you could explain it to me without that part disappearing behind the premium content curtain?
Regards,
Vivek D. Reddy
__________________________________________
If knowledge can create problems, it is not through ignorance that we can solve them. - Isaac Asimov
Vivek D. Reddy
__________________________________________
If knowledge can create problems, it is not through ignorance that we can solve them. - Isaac Asimov
-
- Premium Member
- Posts: 301
- Joined: Thu Jul 14, 2005 10:27 am
- Location: Melbourne, Australia
- Contact:
<b>John McKeever</b>
Data Migrators
<b><a href="https://www.mettleci.com">MettleCI</a> - DevOps for DataStage</b>
<a href="http://www.datamigrators.com/"><img src="https://www.datamigrators.com/assets/im ... l.png"></a>
Data Migrators
<b><a href="https://www.mettleci.com">MettleCI</a> - DevOps for DataStage</b>
<a href="http://www.datamigrators.com/"><img src="https://www.datamigrators.com/assets/im ... l.png"></a>
-
- Participant
- Posts: 43
- Joined: Mon Jan 15, 2007 10:53 pm
Hi.
I am not looking at Environment Variables per se, as they would require some sort of default value et al either at the Job level or the project level.
Is there some way of either creating a DSMacro or a DSRoutine to achieve the same, and to retrieve the value at runtime?
I am not looking at Environment Variables per se, as they would require some sort of default value et al either at the Job level or the project level.
Is there some way of either creating a DSMacro or a DSRoutine to achieve the same, and to retrieve the value at runtime?
Regards,
Vivek D. Reddy
__________________________________________
If knowledge can create problems, it is not through ignorance that we can solve them. - Isaac Asimov
Vivek D. Reddy
__________________________________________
If knowledge can create problems, it is not through ignorance that we can solve them. - Isaac Asimov
Why dont you ask your organization to go in for Corporate membership? That way they can help themselves. And you can see the premium content too.Hi.
Sorry, but I can't read the premium content part.
Is there some way you could explain it to me without that part disappearing behind the premium content curtain?
_________________
Regards,
Vivek D. Reddy
-
- Participant
- Posts: 43
- Joined: Mon Jan 15, 2007 10:53 pm