job parameter using escape character

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
ArunaDas_Maharana
Participant
Posts: 42
Joined: Thu Dec 11, 2008 11:07 am

job parameter using escape character

Post by ArunaDas_Maharana »

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
ArunaDas_Maharana
Participant
Posts: 42
Joined: Thu Dec 11, 2008 11:07 am

Post by ArunaDas_Maharana »

i got it working by separating all the key words as job parameters as ds can't read spaces between keywords like "between startdate and enddate"
Post Reply