26 lines
480 B
SQL
26 lines
480 B
SQL
spool /mnpapp/log/script/SM_2239.log;
|
|
|
|
update MNP_IMPORTI_SLA_OPERATORE
|
|
set importo=10
|
|
where id_operatore='NOVE'
|
|
and SLA in ('SLA0','SLA3','SLAX','SLAY','SLAZ');
|
|
|
|
update MNP_IMPORTI_SLA_OPERATORE
|
|
set importo=30
|
|
where id_operatore='NOVE'
|
|
and SLA in ('SLA1','SLA2');
|
|
|
|
update MNP_IMPORTI_SLA_OPERATORE
|
|
set importo=3
|
|
where id_operatore='NOVA'
|
|
and SLA in ('SLA2');
|
|
|
|
update MNP_IMPORTI_SLA_OPERATORE
|
|
set importo=1
|
|
where id_operatore='NOVA'
|
|
and SLA in ('SLA3');
|
|
|
|
commit;
|
|
|
|
spool off;
|
|
exit |