Adding a SQL Statement Operation Using the Properties Panel

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

To add a SQL statement operation:

Open the database service you want to add a SQL statement to.
Select the Interface tab of the database service editor.
Connect to your database connection profile in the Enterprise Explorer.
Note
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.
If you insert a SQL statement operation without specifying a database, you must modify any generated parameters or result sets, and/or provide parameters or result sets by entering them manually in the parameters dialog at deploy time.
Right-click the Interface object and select Add SQL Statement Operation|Add Request Response Operation to add a default operation to the interface.
Add a SQL statement. Do the following:
1. Select the operation in the service editor.
2. Open the Properties Panel and select the Source tab.
  Note
  If you had 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.
3. Select the Allow Manual Editing check box.
4. 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.
Save the service file. Click File|Save.