CREATE proc JMO_TRG_Upd (
@trg_trev char ( 9 ) ,
@trg_trid char ( 65 ) ,
@trg_apc7 varchar ( 9 ) ,
@trg_desc varchar (255 ) ,
@trg_jnam varchar ( 65 ) ,
@trg_usid varchar ( 33 ) ,
@trg_stan varchar ( 21 ) ,
@trg_faill int ,
@trg_failh int ,
@trg_file varchar (255 ) ,
@trg_ustat char ( 2 ) ,
@trg_skip varchar ( 5 ) ,
@trg_jobn varchar ( 5 ) ,
@trg_scdn varchar ( 65 ) ,
@trg_estar varchar ( 8 ) ,
@trg_efend varchar ( 8 ) ,
@trg_qnam char ( 2 ) ,
@trg_bklog char ( 2 ) ,
@trg_cal varchar ( 9 ) ,
@trg_auto varchar ( 2 ) ,
@trg_recs1 varchar ( 2 ) ,
@trg_ccal varchar ( 9 ) ,
@trg_cri varchar (255) ,
@trg_hact char ( 2 ) ,
@trg_nwact char ( 2 ) ,
@trg_cadj varchar ( 5 ) ,
@k_trg_trev char(9),
@k_trg_trid char(65)
)
as
begin
Update jmo_trg
Set
trg_trev = @trg_trev,
trg_trid = @trg_trid,
trg_apc7 = @trg_apc7,
trg_desc = @trg_desc,
trg_jnam = @trg_jnam,
trg_usid = @trg_usid,
trg_stan = @trg_stan,
trg_faill = @trg_faill,
trg_failh = @trg_failh,
trg_file = @trg_file,
trg_ustat = @trg_ustat,
trg_skip = @trg_skip,
trg_jobn = @trg_jobn,
trg_scdn = @trg_scdn,
trg_estar = @trg_estar,
trg_efend = @trg_efend,
trg_qnam = @trg_qnam,
trg_bklog = @trg_bklog,
trg_cal = @trg_cal,
trg_auto = @trg_auto,
trg_recs1 = @trg_recs1,
trg_ccal = @trg_ccal,
trg_cri = @trg_cri,
trg_hact = @trg_hact,
trg_nwact = @trg_nwact,
trg_cadj = @trg_cadj
From jmo_trg WITH (index=1)
Where
trg_trev = @k_trg_trev and
trg_trid = @k_trg_trid
end
GO
GRANT EXECUTE ON [dbo].[JMO_TRG_Upd] TO [emadmin]
GRANT EXECUTE ON [dbo].[JMO_TRG_Upd] TO [jmoadmin]
GRANT EXECUTE ON [dbo].[JMO_TRG_Upd] TO [uniadmin]
GO
[dbo].[JMO_TRG_Upd]