Before you can open and begin editing a procedural object, you must have a database connection profile to connect to the database server or database where the object is located. See Creating an ASA Connection Profile or Creating an ASE Connection Profile for further information.
To open a stored procedure or user-defined function for editing:
Expand the ASA, ASIQ or ASE connection profile in Database Explorer.
Expand the Procedures & Functions folder.
Select the procedure or function you want to edit.
Double-click or right-click the selected object and choose Edit Procedure or Edit Function (ASA/ASIQ only) as appropriate.
The SQL code appears in SQL Editor.
To open a trigger for editing:
Expand the ASA or ASE connection profile in Database Explorer.
Expand the Tables folder.
Expand the table where the trigger you want to edit is located.
Expand the Triggers folder and select the trigger you want to edit.
Double click or right-click on the selected trigger and choose Edit Trigger.
The SQL code appears in SQL Editor.
To open an ASA event for editing:
Expand the ASA or ASIQ connection profile in Database Explorer.
Expand the Events folder and select the event that you want to edit.
Double-click or right-click the selected event and choose Edit Event.
The SQL code appears in SQL Editor.
You are now ready to edit the code using Content Assist or Visual SQL.
Send your feedback on this help topic to Sybase Tech Pubs: pubs@sybase.com