CREATE proc JMO_JTR_Upd (
@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(33),
@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),
@k_jtr_scdn char(65),
@k_jtr_name char(65),
@k_jtr_jno char(5),
@k_jtr_qual char(5)
)
as
begin
Update jmo_jtr
Set
jtr_scdn = @jtr_scdn,
jtr_name = @jtr_name,
jtr_jno = @jtr_jno,
jtr_qual = @jtr_qual,
jtr_ows = @jtr_ows,
jtr_ws = @jtr_ws,
jtr_subu = @jtr_subu,
jtr_subfile = @jtr_subfile,
jtr_abscd = @jtr_abscd,
jtr_avgtb = @jtr_avgtb,
jtr_any = @jtr_any,
jtr_uxjno = @jtr_uxjno,
jtr_erly = @jtr_erly,
jtr_must = @jtr_must,
jtr_dedln = @jtr_dedln,
jtr_mxtim = @jtr_mxtim,
jtr_avgt = @jtr_avgt,
jtr_flg1 = @jtr_flg1,
jtr_bklog = @jtr_bklog,
jtr_sutyp = @jtr_sutyp,
jtr_wstyp = @jtr_wstyp,
jtr_desc = @jtr_desc,
jtr_newpr = @jtr_newpr,
jtr_histc = @jtr_histc,
jtr_fordate = @jtr_fordate,
jtr_erdt = @jtr_erdt,
jtr_mudt = @jtr_mudt,
jtr_dedt = @jtr_dedt,
jtr_mxdt = @jtr_mxdt,
jtr_adate = @jtr_adate,
jtr_vdate = @jtr_vdate,
jtr_sdate = @jtr_sdate,
jtr_edate = @jtr_edate,
jtr_pdate = @jtr_pdate,
jtr_atime = @jtr_atime,
jtr_vtime = @jtr_vtime,
jtr_stime = @jtr_stime,
jtr_etime = @jtr_etime,
jtr_ptime = @jtr_ptime,
jtr_dprty = @jtr_dprty,
jtr_comp = @jtr_comp,
jtr_cput = @jtr_cput,
jtr_pid = @jtr_pid,
jtr_cc = @jtr_cc,
jtr_hstat = @jtr_hstat,
jtr_rstat = @jtr_rstat,
jtr_flg3 = @jtr_flg3,
jtr_flg4 = @jtr_flg4,
jtr_flg5 = @jtr_flg5,
jtr_cmrun = @jtr_cmrun,
jtr_cmhld = @jtr_cmhld,
jtr_cmrls = @jtr_cmrls,
jtr_cmcnc = @jtr_cmcnc,
jtr_cmfrc = @jtr_cmfrc,
jtr_cmstr = @jtr_cmstr,
jtr_cmcmp = @jtr_cmcmp,
jtr_luser = @jtr_luser,
jtr_cal = @jtr_cal,
jtr_cmsub = @jtr_cmsub,
jtr_abcnt = @jtr_abcnt,
jtr_alias = @jtr_alias,
jtr_nodea = @jtr_nodea,
jtr_emsg = @jtr_emsg,
jtr_faill = @jtr_faill,
jtr_failh = @jtr_failh,
jtr_subp = @jtr_subp,
jtr_domain = @jtr_domain,
jtr_cycle = @jtr_cycle,
jtr_freq = @jtr_freq,
jtr_count = @jtr_count,
jtr_qname = @jtr_qname,
jtr_can = @jtr_can
From jmo_jtr WITH (index=1)
Where
jtr_scdn = @k_jtr_scdn and
jtr_name = @k_jtr_name and
jtr_jno = @k_jtr_jno and
jtr_qual = @k_jtr_qual
end
GO
GRANT EXECUTE ON [dbo].[JMO_JTR_Upd] TO [emadmin]
GRANT EXECUTE ON [dbo].[JMO_JTR_Upd] TO [jmoadmin]
GRANT EXECUTE ON [dbo].[JMO_JTR_Upd] TO [uniadmin]
GO
[dbo].[JMO_JTR_Upd]