Adding a SQL Statement Operation Using the Properties Section

Manually enter a SQL statement operation using the service editor. You can also edit SQL statements using this method.

1. Open the database service you want to add a SQL statement to.
2. Select the Interface tab of 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.

   If you insert a SQL statement operation without specifying a database, modify the generated parameters or result sets, and/or provide parameters or result sets by entering them manually in the parameters dialog during deployment.

4. Right-click the Interface object and select Add SQL Statement Operation > Add Request Response Operation to add a default operation to the interface.
5. To add a SQL statement, select the operation in the editor.
6. Expand the Properties section and select the Source tab.
   Note: If you selected genericTypes as your schema type in the Properties panel before adding your SQL statement, a warning appears concerning result sets. Ignore the warning and continue with the process.
7. Select the Allow Manual Editing check box.
8. Type a SQL statement in the edit box.
   Note: To use Content Assist while typing the SQL statement, press Ctrl-Space and double-click an item in the list to enter it in the statement.
9. 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.