Adding a SQL Statement Operation Using Visual SQL

You can create select, insert, update, and delete statements in a database service.

1. Open the database service you want to add a SQL statement to.
2. Select the Service Interface tab in the editor.
3. Connect to your database connection profile in the Enterprise Explorer.
   Note: If you have not created a connection profile, right-click Databases and select New to create a new connection profile.
4. To add a SQL statement to the service interface, do one of the following:
   
   • On the Service Interface page, right-click the Interface box and select Add SQL Statement Operation > Add Request-Response Operation.
   • Open the Tool Palette, drag SQL Statement - Request Response from the palette, and drop it onto the interface.

   A default operation is added to the interface.

5. To add a SQL statement:
   1. Expand the Properties section.
   2. Select the operation in the interface, select the Source tab and click New in Visual SQL in Properties.

      The Select a Statement Type dialog opens.

   3. Select a SQL statement type and click OK.

      The SQL Dialog Select Tables dialog opens.

   4. Select tables and click Open.

      The SQL dialog opens.

   5. Select, insert, update, or delete column values, then click OK.
6. Select File > Save.

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.