Create select, insert, update, and delete statements for a database service using the Visual SQL Dialog. You can also manually edit the SQL statements in a database service at any time using this method.
To add a SQL statement using Visual SQL:
Open the database service you want to add a SQL statement to.
Select the Service Interface tab in the database service editor.
Connect to your database connection profile in the Enterprise Explorer.
If you have not yet created your connection profile, right-click Databases and select New to create a new connection profile. See Creating Additional JDBC Connection Profiles for instructions.
Add a SQL statement to the service interface. Choose from the following:
Select the Service Interface page in the editor. Right-click the Interface box and select Add SQL Statement Operation|Add Request-Response Operation from the context menu.
Open the Tool palette. Drag the SQL Statement - Request Response icon from the palette onto the interface.
A default operation is added to the interface.
Add a SQL statement. Do the following:
Select the operation in the interface, select the Source tab and click New in Visual SQL in the Properties Panel.
The Select a Statement Type dialog appears.
Select a SQL statement type and click OK.
The SQL Dialog Select Tables dialog appears.
Select tables and click Open.
The SQL dialog appears.
Select, insert, update, or delete column values, then click OK.
Save the service file. Click File|Save.
Send your feedback on this help topic to Sybase Tech Pubs: pubs@sybase.com