CREATE proc JMO_TRG_Ins (
@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 )
)
as
begin
Insert into jmo_trg (
trg_trev,
trg_trid,
trg_apc7,
trg_desc,
trg_jnam,
trg_usid,
trg_stan,
trg_faill,
trg_failh,
trg_file,
trg_ustat,
trg_skip,
trg_jobn,
trg_scdn,
trg_estar,
trg_efend,
trg_qnam,
trg_bklog,
trg_cal,
trg_auto,
trg_recs1,
trg_ccal,
trg_cri,
trg_hact,
trg_nwact,
trg_cadj
)
Values (
@trg_trev,
@trg_trid,
@trg_apc7,
@trg_desc,
@trg_jnam,
@trg_usid,
@trg_stan,
@trg_faill,
@trg_failh,
@trg_file,
@trg_ustat,
@trg_skip,
@trg_jobn,
@trg_scdn,
@trg_estar,
@trg_efend,
@trg_qnam,
@trg_bklog,
@trg_cal,
@trg_auto,
@trg_recs1,
@trg_ccal,
@trg_cri,
@trg_hact,
@trg_nwact,
@trg_cadj
)
end
GO
GRANT EXECUTE ON [dbo].[JMO_TRG_Ins] TO [emadmin]
GRANT EXECUTE ON [dbo].[JMO_TRG_Ins] TO [jmoadmin]
GRANT EXECUTE ON [dbo].[JMO_TRG_Ins] TO [uniadmin]
GO
[dbo].[JMO_TRG_Ins]