I have created a routine that basically read a config file and find the value of a parameter . Value of parameter is a Srcfile path
Routine Structure
FUNCTION ReadParameter(ParameterName, DefaultValue,ConfigFile)
(
--
--
Return(paramval)
)
In the job that parameter value basically treated as a source file.
My job structure is
SrcFile-------> Transformer ----------> TgtFile
Where i should call the routine and what will be the code.
Parameter File
Moderators: chulett, rschirm, roy
Re: Parameter File
sorry for my previous post
Last edited by sachin1 on Thu May 15, 2008 4:28 am, edited 1 time in total.
From my understanding you can try with the sequence job..
1. define a parameter for source file path
2. use the execute routine stage to call your routine.
3. in the job activity stage, link your job and assign the source file path parameter value to the return value from the execute routine stage.
Thanks,
Birendra
1. define a parameter for source file path
2. use the execute routine stage to call your routine.
3. in the job activity stage, link your job and assign the source file path parameter value to the return value from the execute routine stage.
Thanks,
Birendra
Birendra
how to set Parameter file at Project Level when O.S is windw
Please let me know how to set Parameter file at Project Level when O.S is windows.?bkumar103 wrote:From my understanding you can try with the sequence job..
1. define a parameter for source file path
2. use the execute routine stage to call your routine.
3. in the job activity stage, link your job and assign the source file path parameter value to the return value from the execute routine stage.
Thanks,Hi
Birendra
-
- Participant
- Posts: 59
- Joined: Thu Mar 20, 2008 12:11 am
Re: how to set Parameter file at Project Level when O.S is w
Thank You,sunnyk wrote:Please let me know how to set Parameter file at Project Level when O.S is windows.?bkumar103 wrote:From my understanding you can try with the sequence job..
1. define a parameter for source file path
2. use the execute routine stage to call your routine.
3. in the job activity stage, link your job and assign the source file path parameter value to the return value from the execute routine stage.
Thanks,Hi
Birendra
Now i am able to design the seq.
My job taking the value of the parameter from a paramter file.
Say my parameter file contain only the path ex "spath=d:\sourcepath"
so if i use #spath# then it does not locate the actual file
anyhow i have to concate the file with #spath#.
Please tell me the process.
nsd