/****** Object:  Stored Procedure dbo.JMO_HSTU_Upd    Script Date: 12/1/2005 11:49:17 PM ******/

CREATE proc JMO_HSTU_Upd (
   @hst_scdn         char(65),
   @hst_name         char(65),
   @hst_jno          char(5),
   @k_hst_scdn       char(65),
   @k_hst_name       char(65),
   @k_hst_jno        char(5)   
)
as
begin
   Update jmo_hstu
   Set
      hst_scdn         = @hst_scdn,
      hst_name         = @hst_name,
      hst_jno          = @hst_jno      
   From  jmo_hstu WITH (index=1)
   Where
      hst_scdn         = @k_hst_scdn    and
      hst_name         = @k_hst_name    and
      hst_jno          = @k_hst_jno      
end
GO
GRANT EXECUTE ON  [dbo].[JMO_HSTU_Upd] TO [emadmin]
GRANT EXECUTE ON  [dbo].[JMO_HSTU_Upd] TO [jmoadmin]
GRANT EXECUTE ON  [dbo].[JMO_HSTU_Upd] TO [uniadmin]
GO