CREATE proc JMO_JTR1_Ins (
@jtr_scdn char(65),
@jtr_name char(65),
@jtr_jno char(5),
@jtr_qual char(5),
@jtr_ows varchar(21),
@jtr_ws varchar(21),
@jtr_subu varchar(33),
@jtr_subfile varchar(255),
@jtr_abscd varchar(65),
@jtr_avgtb int,
@jtr_any binary(1),
@jtr_uxjno int,
@jtr_erly int,
@jtr_must int,
@jtr_dedln int,
@jtr_mxtim int,
@jtr_avgt int,
@jtr_flg1 binary(1),
@jtr_bklog binary(1),
@jtr_sutyp binary(1),
@jtr_wstyp char(1),
@jtr_desc varchar(255),
@jtr_newpr char(2) ,
@jtr_histc smallint,
@jtr_fordate int,
@jtr_erdt int,
@jtr_mudt int,
@jtr_dedt int,
@jtr_mxdt int,
@jtr_adate int,
@jtr_vdate int,
@jtr_sdate int,
@jtr_edate int,
@jtr_pdate int,
@jtr_atime int,
@jtr_vtime int,
@jtr_stime int,
@jtr_etime int,
@jtr_ptime int,
@jtr_dprty int,
@jtr_comp int,
@jtr_cput int,
@jtr_pid int,
@jtr_cc varchar(9),
@jtr_hstat binary(1),
@jtr_rstat binary(1),
@jtr_flg3 binary(1),
@jtr_flg4 binary(1),
@jtr_flg5 binary(1),
@jtr_cmrun varchar(33),
@jtr_cmhld varchar(33),
@jtr_cmrls varchar(33),
@jtr_cmcnc varchar(33),
@jtr_cmfrc varchar(33),
@jtr_cmstr varchar(33),
@jtr_cmcmp varchar(33),
@jtr_luser varchar(33),
@jtr_cal varchar(9),
@jtr_cmsub varchar(16),
@jtr_abcnt int,
@jtr_alias varchar(65),
@jtr_nodea varchar(65),
@jtr_emsg char(4),
@jtr_faill int,
@jtr_failh int,
@jtr_subp varchar(15),
@jtr_domain varchar(16),
@jtr_cycle varchar(1),
@jtr_freq int,
@jtr_count int,
@jtr_qname char(1),
@jtr_can char(1)
)
as
begin
Insert into jmo_jtr1 (
jtr_scdn,
jtr_name,
jtr_jno,
jtr_qual,
jtr_ows,
jtr_ws,
jtr_subu,
jtr_subfile,
jtr_abscd,
jtr_avgtb,
jtr_any,
jtr_uxjno,
jtr_erly,
jtr_must,
jtr_dedln,
jtr_mxtim,
jtr_avgt,
jtr_flg1,
jtr_bklog,
jtr_sutyp,
jtr_wstyp,
jtr_desc,
jtr_newpr,
jtr_histc,
jtr_fordate,
jtr_erdt,
jtr_mudt,
jtr_dedt,
jtr_mxdt,
jtr_adate,
jtr_vdate,
jtr_sdate,
jtr_edate,
jtr_pdate,
jtr_atime,
jtr_vtime,
jtr_stime,
jtr_etime,
jtr_ptime,
jtr_dprty,
jtr_comp,
jtr_cput,
jtr_pid,
jtr_cc,
jtr_hstat,
jtr_rstat,
jtr_flg3,
jtr_flg4,
jtr_flg5,
jtr_cmrun,
jtr_cmhld,
jtr_cmrls,
jtr_cmcnc,
jtr_cmfrc,
jtr_cmstr,
jtr_cmcmp,
jtr_luser,
jtr_cal,
jtr_cmsub,
jtr_abcnt,
jtr_alias,
jtr_nodea,
jtr_emsg,
jtr_faill,
jtr_failh,
jtr_subp,
jtr_domain,
jtr_cycle,
jtr_freq,
jtr_count,
jtr_qname,
jtr_can
)
Values (
@jtr_scdn,
@jtr_name,
@jtr_jno,
@jtr_qual,
@jtr_ows,
@jtr_ws,
@jtr_subu,
@jtr_subfile,
@jtr_abscd,
@jtr_avgtb,
@jtr_any,
@jtr_uxjno,
@jtr_erly,
@jtr_must,
@jtr_dedln,
@jtr_mxtim,
@jtr_avgt,
@jtr_flg1,
@jtr_bklog,
@jtr_sutyp,
@jtr_wstyp,
@jtr_desc,
@jtr_newpr,
@jtr_histc,
@jtr_fordate,
@jtr_erdt,
@jtr_mudt,
@jtr_dedt,
@jtr_mxdt,
@jtr_adate,
@jtr_vdate,
@jtr_sdate,
@jtr_edate,
@jtr_pdate,
@jtr_atime,
@jtr_vtime,
@jtr_stime,
@jtr_etime,
@jtr_ptime,
@jtr_dprty,
@jtr_comp,
@jtr_cput,
@jtr_pid,
@jtr_cc,
@jtr_hstat,
@jtr_rstat,
@jtr_flg3,
@jtr_flg4,
@jtr_flg5,
@jtr_cmrun,
@jtr_cmhld,
@jtr_cmrls,
@jtr_cmcnc,
@jtr_cmfrc,
@jtr_cmstr,
@jtr_cmcmp,
@jtr_luser,
@jtr_cal,
@jtr_cmsub,
@jtr_abcnt,
@jtr_alias,
@jtr_nodea,
@jtr_emsg,
@jtr_faill,
@jtr_failh,
@jtr_subp,
@jtr_domain,
@jtr_cycle,
@jtr_freq,
@jtr_count,
@jtr_qname,
@jtr_can
)
end
GO
GRANT EXECUTE ON [dbo].[JMO_JTR1_Ins] TO [emadmin]
GRANT EXECUTE ON [dbo].[JMO_JTR1_Ins] TO [jmoadmin]
GRANT EXECUTE ON [dbo].[JMO_JTR1_Ins] TO [uniadmin]
GO
[dbo].[JMO_JTR1_Ins]