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
job parameter using escape character
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 42
- Joined: Thu Dec 11, 2008 11:07 am
-
- Participant
- Posts: 42
- Joined: Thu Dec 11, 2008 11:07 am