Page 2 of 2
Posted: Mon Jul 26, 2010 4:37 am
by Sainath.Srinivasan
Did you check the function KBAGetParameterArray ?
Posted: Mon Jul 26, 2010 5:30 am
by karthi_gana
Sainath.Srinivasan wrote:Did you check the function KBAGetParameterArray ?
I got it...i just changed the path of the ini file from
\bis_data\msg\mfr\offshore\parameters\Parameter_offshore_funds.ini
to
/bis_data/msg/mfr/offshore/parameters/Parameter_offshore_funds.ini
i.e Backward slash to forward slash
I am able to load the parameter values now...But the job is not reading the .CSV file.
BATCH_MJC_ZFD..JobControl (KBAJobControl): Unable to open /bisdata/msg/mfr/offshore/log/BATCH_MJC_ZFD.csv
Posted: Mon Jul 26, 2010 5:48 am
by karthi_gana
I fixed this one too..
he..he...it is my mistake
\bisdata\
\bis_data\
Posted: Mon Jul 26, 2010 5:49 am
by karthi_gana
karthi_gana wrote:I fixed this one too..
he..he...it is my mistake
\bisdata\
\bis_data\
But...the jobs were not initialized properly from the .csv file.
Looking it now...
Posted: Mon Jul 26, 2010 2:24 pm
by vivekgadwal
karthi_gana wrote:karthi_gana wrote:I fixed this one too..
he..he...it is my mistake
\bisdata\
\bis_data\
But...the jobs were not initialized properly from the .csv file.
Looking it now...
karthi_gana - Just a friendly advice (not to be misconstrued...)
We understand that you are doing several iterations. However, you do not need to post here every few minutes you did a change on your end (kind of like Twitter). Post an entry or may be two with all your observations/questions. :D
Good luck...
Posted: Mon Jul 26, 2010 3:25 pm
by creatingfusion
the ini file is not a feature of DataStage. You are probably running the DS Job from Unix command laine and passing the parameter as the name of the ini file.
All you need to take care is that you add/overwrite the new parameters you want in the .ini file and then further when you run the datastage job use the updated ini file .
A parameter set being different concept which is inbuilt feature in datastage and you group several parameters into a set and give it a particular name. When you develop the DS Job you add the parameter set name in it and while execution it shows all the parameters in the parameter set. You can modify the values of any parameter when you run the job else it takes the default values defined in it.
Abhijit.