The following are the required programming constructs for a Sybase procedure file:
:r LeasePak_syb_use
go
if exists
(select * from sysobjects where name = 'up_procedure-name')
drop procedure up_procedure-name
go
create procedure up_procedure-name
body of procedure
go