CREATE proc JMO_SHR_Upd (
@shr_name char(65),
@shr_key char(12),
@shr_avelp int,
@shr_avcpu int,
@shr_hcnt smallint,
@shr_erdt int,
@shr_msdt int,
@shr_deddt int,
@shr_adate int,
@shr_vdate int,
@shr_sdate int,
@shr_edate int,
@shr_ertm int,
@shr_mstm int,
@shr_dedtm int,
@shr_atime int,
@shr_vtime int,
@shr_stime int,
@shr_etime int,
@shr_relpt int,
@shr_rcput int,
@shr_qual char(5),
@shr_cc varchar(9),
@shr_ws varchar(21),
@shr_stat binary(1),
@shr_late char(1),
@shr_cmrun varchar(33),
@shr_cmhld varchar(33),
@shr_cmrls varchar(33),
@shr_cmcnc varchar(33),
@shr_cmfrc varchar(33),
@shr_avgtb int,
@shr_qname char(1),
@k_shr_name char(65),
@k_shr_key char(12)
)
as
begin
Update jmo_shr
Set
shr_name = @shr_name,
shr_key = @shr_key,
shr_avelp = @shr_avelp,
shr_avcpu = @shr_avcpu,
shr_hcnt = @shr_hcnt,
shr_erdt = @shr_erdt,
shr_msdt = @shr_msdt,
shr_deddt = @shr_deddt,
shr_adate = @shr_adate,
shr_vdate = @shr_vdate,
shr_sdate = @shr_sdate,
shr_edate = @shr_edate,
shr_ertm = @shr_ertm,
shr_mstm = @shr_mstm,
shr_dedtm = @shr_dedtm,
shr_atime = @shr_atime,
shr_vtime = @shr_vtime,
shr_stime = @shr_stime,
shr_etime = @shr_etime,
shr_relpt = @shr_relpt,
shr_rcput = @shr_rcput,
shr_qual = @shr_qual,
shr_cc = @shr_cc,
shr_ws = @shr_ws,
shr_stat = @shr_stat,
shr_late = @shr_late,
shr_cmrun = @shr_cmrun,
shr_cmhld = @shr_cmhld,
shr_cmrls = @shr_cmrls,
shr_cmcnc = @shr_cmcnc,
shr_cmfrc = @shr_cmfrc,
shr_avgtb = @shr_avgtb,
shr_qname = @shr_qname
From jmo_shr WITH (index=1)
Where
shr_name = @k_shr_name and
shr_key = @k_shr_key
end
GO
GRANT EXECUTE ON [dbo].[JMO_SHR_Upd] TO [emadmin]
GRANT EXECUTE ON [dbo].[JMO_SHR_Upd] TO [jmoadmin]
GRANT EXECUTE ON [dbo].[JMO_SHR_Upd] TO [uniadmin]
GO
[dbo].[JMO_SHR_Upd]