CREATE proc JMO_SBR_Upd (
@sbr_name char(65),
@sbr_effdt int,
@sbr_expdt int,
@sbr_sprty char(2),
@sbr_stype char(1),
@sbr_any binary(1),
@sbr_ws varchar(21),
@sbr_cal varchar(9),
@sbr_erly int,
@sbr_must int,
@sbr_dedln int,
@sbr_mxtim int,
@sbr_avg int,
@sbr_flg1 binary(1),
@sbr_bklog binary(1),
@sbr_recs1 char(1),
@sbr_histc smallint,
@sbr_creus varchar(33),
@sbr_credt int,
@sbr_cretm int,
@sbr_lusdt int,
@sbr_lustm int,
@sbr_skip int,
@sbr_user varchar(33),
@sbr_desc varchar(255),
@sbr_faill int,
@sbr_failh int,
@sbr_subu varchar(33),
@sbr_subp varchar(15),
@sbr_domain varchar(16),
@sbr_ccal varchar(9),
@sbr_cri varchar(255),
@sbr_hact char(2),
@sbr_nwact char(2),
@sbr_cadj varchar(5),
@sbr_sutyp binary(1),
@sbr_qname char(1),
@k_sbr_name char(65)
)
as
begin
Update jmo_sbr
Set
sbr_name = @sbr_name,
sbr_effdt = @sbr_effdt,
sbr_expdt = @sbr_expdt,
sbr_sprty = @sbr_sprty,
sbr_stype = @sbr_stype,
sbr_any = @sbr_any,
sbr_ws = @sbr_ws,
sbr_cal = @sbr_cal,
sbr_erly = @sbr_erly,
sbr_must = @sbr_must,
sbr_dedln = @sbr_dedln,
sbr_mxtim = @sbr_mxtim,
sbr_avg = @sbr_avg,
sbr_flg1 = @sbr_flg1,
sbr_bklog = @sbr_bklog,
sbr_recs1 = @sbr_recs1,
sbr_histc = @sbr_histc,
sbr_creus = @sbr_creus,
sbr_credt = @sbr_credt,
sbr_cretm = @sbr_cretm,
sbr_lusdt = @sbr_lusdt,
sbr_lustm = @sbr_lustm,
sbr_skip = @sbr_skip,
sbr_user = @sbr_user,
sbr_desc = @sbr_desc,
sbr_faill = @sbr_faill,
sbr_failh = @sbr_failh,
sbr_subu = @sbr_subu,
sbr_subp = @sbr_subp,
sbr_domain = @sbr_domain,
sbr_ccal = @sbr_ccal,
sbr_cri = @sbr_cri,
sbr_hact = @sbr_hact,
sbr_nwact = @sbr_nwact,
sbr_cadj = @sbr_cadj,
sbr_sutyp = @sbr_sutyp,
sbr_qname = @sbr_qname
From jmo_sbr WITH (index=1)
Where
sbr_name = @k_sbr_name
end
GO
GRANT EXECUTE ON [dbo].[JMO_SBR_Upd] TO [emadmin]
GRANT EXECUTE ON [dbo].[JMO_SBR_Upd] TO [jmoadmin]
GRANT EXECUTE ON [dbo].[JMO_SBR_Upd] TO [uniadmin]
GO
[dbo].[JMO_SBR_Upd]