Based on the following link, we should be able to alter a stored procedure in Sybase.
http://manuals.sybase.com/onlinebooks/group-pbarc/conn5/sqlug/@Generic__BookTextView/39270;pt=48909
However, I got errors in both ASE 12.5 and 15.x client tools.
Any input will be greatly appreciated.