Want to make changes at the parameterset through the unix
Moderators: chulett, rschirm, roy
Want to make changes at the parameterset through the unix
Hi All,
I have a query , I want to make the changes at the parametset of the datastage through unix .
Is it possible to achieve the same through the unix.
I have a query , I want to make the changes at the parametset of the datastage through unix .
Is it possible to achieve the same through the unix.
Irfan.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Changing the "(As pre-defined)" values is not possible through operating system commands.
However, you can change values defined in values files belonging to the Parameter Set. Values files are text files that reside in the ParameterSets sub-directory in the project. Within that there is a sub-directory for each Parameter Set, and each values file may be found in that directory.
For example, if you have a parameter set called psQualifiers with four values files DEV, SIT, UAT and PRD, then the following structure will exist.
However, you can change values defined in values files belonging to the Parameter Set. Values files are text files that reside in the ParameterSets sub-directory in the project. Within that there is a sub-directory for each Parameter Set, and each values file may be found in that directory.
For example, if you have a parameter set called psQualifiers with four values files DEV, SIT, UAT and PRD, then the following structure will exist.
Code: Select all
<ProjectDirectory>
|
|
--+--
|
|
psQualifiers
|
|
+------+---+--+------+
| | | |
DEV SIT UAT PRD
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.
Hi Ray,
I tried with the parameter value file, However I'm running the job by default it is showing (As-predefined) , everytime I have to select the value file name,
Is there any way I can make that value file default.
Or
How I can achieve the same through the Shell script.
Please reply with your valuable suggestion.
I tried with the parameter value file, However I'm running the job by default it is showing (As-predefined) , everytime I have to select the value file name,
Is there any way I can make that value file default.
Or
How I can achieve the same through the Shell script.
Please reply with your valuable suggestion.
Irfan.
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
Hi,
You can set the particulat value in job sequence.Lets say if have parameter set called "SourceDB" and it has four Values
Sourcedb_DEV
Sourcedb_SIT
Sourcedb_UAT
Sourcedb_PRD
If you are in dev env,you can set like below in sequence job:-
SourceDB="Sourcedb_DEV"
You can set the particulat value in job sequence.Lets say if have parameter set called "SourceDB" and it has four Values
Sourcedb_DEV
Sourcedb_SIT
Sourcedb_UAT
Sourcedb_PRD
If you are in dev env,you can set like below in sequence job:-
SourceDB="Sourcedb_DEV"
Thanks
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
The method Ray mentioned (updating value files) is the proper and best way to accomplish this task when using parameter sets to pass your parameter values. You can certainly use whatever method you desire to create or modify a value file dynamically (shell script/awk/sed/perl/etc.), then pass that value file to the job.
Regards,
Regards,
- james wiles
All generalizations are false, including this one - Mark Twain.
All generalizations are false, including this one - Mark Twain.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Code: Select all
dsjob ... -param psQualifiers=DEV ...
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: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
Hi,
You can probably encrypt the password and store the encrypted value in file.
If you are encrypting the job parameter values,you can store the encrypted value in job parameter file by copying the output and pasting the value in parameter file.
Encrypt the information by running the encrypt command:-
You can probably encrypt the password and store the encrypted value in file.
If you are encrypting the job parameter values,you can store the encrypted value in job parameter file by copying the output and pasting the value in parameter file.
Encrypt the information by running the encrypt command:-
Code: Select all
/opt/IBM/InformationServer/ASBNode/bin/encrypt.sh myPa$$w0rd
{iisenc}PvqKLr7z3QOLJCQ4QhbrrA==
Thanks
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
Hi,
You can try and test with your own userid but i think you need dsadm user to run this script.
You can try and test with your own userid but i think you need dsadm user to run this script.
Thanks
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: