You can edit SQL files with the same tools you have available to you when editing procedural objects. These include Visual SQL for creating SQL statements and Content Assist for help with SQL syntax as you enter code.
To edit a SQL file:
Open a SQL file from WorkSpace Navigator by double-clicking it or by right-clicking it and selecting Open.The SQL file will be loaded in the SQL Editor, and a connection state, ‘connected’ or ‘not connected’, will be displayed in the status bar at the lower left edge of the workbench. For instance, ‘Database type: Adaptive Server Anywhere_9.x, Current profile: myASA, not connected’.
If the SQL file is not yet connected to a database, you can right-click in the file to open SQL Editor context menu and choose Attach Connection Profile to connect, to use the full capabilities of content assist, and be able to execute the SQL file or selected statements.
Edit the SQL file using content assist or Visual SQL, or by entering edits manually.
To remove all edits since your last save, choose File|Revert.
Save the file to its Sybase WorkSpace project.
Creating an ASA Connection Profile
Creating an ASE Connection Profile
Send your feedback on this help topic to Sybase Tech Pubs: pubs@sybase.com