CREATE proc JMO_JTR1_Selp (
@k_jtr_scdn char(65),
@k_jtr_name char(65),
@k_jtr_jno char(5),
@k_jtr_qual char(5)
)
as
begin
Select
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
From jmo_jtr1
Where
jtr_scdn >= @k_jtr_scdn and
jtr_name >= @k_jtr_name and
jtr_jno >= @k_jtr_jno and
jtr_qual >= @k_jtr_qual
Order by
jtr_scdn,
jtr_name,
jtr_jno,
jtr_qual
For Browse
end
GO
GRANT EXECUTE ON [dbo].[JMO_JTR1_Selp] TO [emadmin]
GRANT EXECUTE ON [dbo].[JMO_JTR1_Selp] TO [emuser]
GRANT EXECUTE ON [dbo].[JMO_JTR1_Selp] TO [jmoadmin]
GRANT EXECUTE ON [dbo].[JMO_JTR1_Selp] TO [jmouser]
GRANT EXECUTE ON [dbo].[JMO_JTR1_Selp] TO [uniadmin]
GRANT EXECUTE ON [dbo].[JMO_JTR1_Selp] TO [uniuser]
GO
[dbo].[JMO_JTR1_Selp]