Sybase Central has facilities for creating, viewing, and altering procedures.
Translating a stored procedure using Sybase Central
Connect to a database using Sybase Central, either as owner of the procedure you wish to change, or as a DBA user.
Double-click the Procedures folder to see a list of the stored procedures in the database.
Using the right mouse button, click the procedure you wish to translate, and choose the target dialect from the popup menu: either Watcom-SQL or Transact-SQL.
The procedure appears in the selected dialect. If the selected dialect is not the one in which the procedure is stored, the server translates it to that dialect. Any untranslated lines appear as comments.
Rewrite any untranslated lines as needed, and click the Execute Script button to save the translated version to the database. You can also export the text to a file for editing outside Sybase Central.
