1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
| with liste (job, cmd, frq, scddate, scdday, scdtime, text)
as ( values
('JOB1','wrksplf','*weekly','*none','*mon *tue','20:00', 'description du job 1'),
('JOB2','wrksplf','*weekly','*none','*thu *fri','20:00', 'description du job'' 2')
)
select
replace(replace(replace(replace(replace(replace(replace(
'addjobscde job(&job) cmd(&cmd) frq(&frq) scddate(&scddate) scdday(&scdday) scdtime(''&scdtime'') text(''&text'')'
, '&job', job)
, '&cmd', cmd)
, '&frq', frq)
, '&scddate', scddate)
, '&scdday', scdday)
, '&scdtime', scdtime)
, '&text', replace(text, '''', ''''''))
from liste |
Partager