job parameter using escape character
Posted: Mon Mar 08, 2010 7:43 am
hi,
my scenario is Oracle enterprise>>> seq file
this needs to be run in 2 modes daily & history, my plan to reuse the code with multiple instance and passing parameter from parameter set
query used is select datecol1, col2
from table
where datecol1=psDate.jpDate
Daily mode
Date=/=/'$1/' $1 is dynamic value passed from scheduler
History
Date= Between /'$1/' And '$2/' $1,$2 is dynamic value passed from scheduler
i echoed the value before calling sequencer command dsjob -run it was fine but while mapping -param psDate.jpDate=${Date} the value is not getting mapped properly i am reckonng bcoz of escape '/' characters used .
please suggest any pointers
my scenario is Oracle enterprise>>> seq file
this needs to be run in 2 modes daily & history, my plan to reuse the code with multiple instance and passing parameter from parameter set
query used is select datecol1, col2
from table
where datecol1=psDate.jpDate
Daily mode
Date=/=/'$1/' $1 is dynamic value passed from scheduler
History
Date= Between /'$1/' And '$2/' $1,$2 is dynamic value passed from scheduler
i echoed the value before calling sequencer command dsjob -run it was fine but while mapping -param psDate.jpDate=${Date} the value is not getting mapped properly i am reckonng bcoz of escape '/' characters used .
please suggest any pointers