This is the decode that we use in our Universe:
rtrim(decode(sign(instr(DS_PENDING_JOB.JOB_SCRIPT, ‘1’)), 1, 'Refresh, ', null) ||
decode(sign(instr(DS_PENDING_JOB.JOB_SCRIPT, ‘2,’)), 1, 'Print (default printer), ', null) ||
decode(sign(instr(DS_PENDING_JOB.JOB_SCRIPT, ‘2[’)), 1, 'Print , ', null) ||
decode(sign(instr(DS_PENDING_JOB.JOB_SCRIPT, ‘3,’)), 1, 'Webserver, ', null) ||
decode(sign(instr(DS_PENDING_JOB.JOB_SCRIPT, ‘4[’)), 1, 'Webserver using custom macro, ', null) ||
decode(sign(instr(DS_PENDING_JOB.JOB_SCRIPT, ‘5,’)), 1, 'Condition, ', null) ||
decode(sign(instr(DS_PENDING_JOB.JOB_SCRIPT, ‘6,’)), 1, 'Channel, ', null) ||
decode(sign(instr(DS_PENDING_JOB.JOB_SCRIPT, ‘7[’)), 1, 'Save as RTF, ', null) ||
decode(sign(instr(DS_PENDING_JOB.JOB_SCRIPT, ‘7,’)), 1, 'Save as RTF, ', null) ||
decode(sign(instr(DS_PENDING_JOB.JOB_SCRIPT, ‘8[’)), 1, 'Save as text, ', null) ||
decode(sign(instr(DS_PENDING_JOB.JOB_SCRIPT, ‘8,’)), 1, 'Save as text, ', null) ||
decode(sign(instr(DS_PENDING_JOB.JOB_SCRIPT, ‘9[’)), 1, 'Save as PDF, ', null) ||
decode(sign(instr(DS_PENDING_JOB.JOB_SCRIPT, ‘9,’)), 1, 'Save as PDF, ', null), ', ')
I didn’t write it, so can’t guarantee that it’s correct; but it should point you in the right direction.[/code]
anorak
(BOB member since 2002-09-13)