Editing a Procedural Object

Edit a procedural object in its associated editor.

You can edit a procedural object to modify or add more SQL statements. You may have created the skeleton for the object, and then added the body of the procedural object either manually or by using one of the editing tools, Visual SQL or Content Assist, to aid you in creating SQL constructs. Additionally, you may want to edit existing procedural objects in a similar way.

Double-click the procedural object.
The procedural object opens in its associated editor.

Click the Source tab to edit the procedural object.

To	Do this
Edit manually	Start typing.
Use Visual SQL	Create a new SQL select, insert, update or delete statement at the current cursor location. To access Visual SQL, right-click and select any of the SQL commands menu choices.
Use Content Assist	In the source code, press Ctrl-Space to bring up a list of syntax options available to you at the cursor point in your SQL code. Select the appropriate syntax to enter into the code by double-clicking it or by pressing Enter. Alternatively, an auto-invocation feature displays appropriate syntax lists when you pause after typing in certain characters, for example, '.', ',', '@'. These lists are more specific to the context and allow you to view, for example, a list of all table names in a database.
Display line numbers	Right-click in the left margin, and choose Show Line Numbers from the context menu.

Save the procedural object.
You can save the procedural object definition as a SQL file or to a database selecting Save As or Save to Database, respectively, from the context menu.

Send your feedback on this help topic to Sybase Technical Publications: pubs@sybase.com

Your comments will be sent to the technical publications staff at Sybase, Inc. For product-related issues or technical support, contact Sybase Technical Support at 1-800-8SYBASE.