Adding Parameters

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Mon Jul 26, 2010 4:37 am

Did you check the function KBAGetParameterArray ?

karthi_gana · Post by **karthi_gana** » Mon Jul 26, 2010 5:30 am

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

karthi_gana · Post by **karthi_gana** » Mon Jul 26, 2010 5:48 am

I fixed this one too..

he..he...it is my mistake

\bisdata\

\bis_data\

karthi_gana · Post by **karthi_gana** » Mon Jul 26, 2010 5:49 am

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...

vivekgadwal · Post by **vivekgadwal** » Mon Jul 26, 2010 2:24 pm

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...

creatingfusion · Post by **creatingfusion** » Mon Jul 26, 2010 3:25 pm

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.