Comma seperated parameters to pass to a database stage
Posted: Thu Jan 19, 2006 8:42 am
Our business has many international sites, each site has multiple facilities. My requirement is to run a job for each site after midnight at each site to deliver a static picture of data at approximately midnight for each site. Because the logic for each site is the same, I was hoping to be able to create one job and use parameters to differentiate the connection and facilities. The connection information works fine, but I am struggling with the facilities.
I have created a parameter called facility. In my oracle stage I have user-defined sql that user the facility parameter like this:
where facility_dwid in (select facility_dwid from facility where facility_id in ('#FACILITY#')
This works fine if I use one facility, but I was hoping to be able to pass in a list that looked like this 'FACILITY 1','FACILITY 2','FACILITY 3'
That should make the sql physically translate to where facility_dwid in (select facility_dwid from facility where facility_id in ('FACILITY 1','FACILITY 2','FACILITY 3').
Thanks in advance,
I have created a parameter called facility. In my oracle stage I have user-defined sql that user the facility parameter like this:
where facility_dwid in (select facility_dwid from facility where facility_id in ('#FACILITY#')
This works fine if I use one facility, but I was hoping to be able to pass in a list that looked like this 'FACILITY 1','FACILITY 2','FACILITY 3'
That should make the sql physically translate to where facility_dwid in (select facility_dwid from facility where facility_id in ('FACILITY 1','FACILITY 2','FACILITY 3').
Thanks in advance,