Use the Database Service editor to create a SQL statement operation while working with the database directly. You can also create a statement and bind it to the database at a later time if you modify the parameters or result sets manually.
To add SQL statement operations:
Click the Interface tab of the database service to display the Interface perspective.
If you have not already associated a database with the database service that you created, from the Enterprise Explorer, drag your JDBC profile to the Interface page to create the endpoint for your operation.
If you drag your profile after you make an association, you are asked you if you want to replace the existing endpoints.
Right-click the Interface perspective or click the checkmark in the lower right corner to invoke the context menu.
Select Add SQL Statement Operation|Request-Response to add a default operation to the interface.
To enter a SQL statement operation manually, select the Allow Manual Editing check box.
See Adding a SQL Statement Operation Manually for instructions.
To import a pre-existing query file, click Import.
See Adding a SQL Statement Operation by Importing Query Files for instructions.
To add a SQL statement operation using the SQL Dialog, click New in SQL Dialog. See Adding a SQL Statement Operation Using SQL Dialog for instructions.
Click OK to create a SQL statement operation for the service.
Send your feedback on this help topic to Sybase Tech Pubs: pubs@sybase.com