Configuring DeleteSQL Services
A DeleteSQL service deletes rows from a table and includes a mapping for an output field that stores the number of affected rows. You configure
Adapter for JDBC services using
Designer. For more information about adapter services, see
Using Adapter Services.
Be sure to review the section
Before Configuring or Managing Adapter
Services before you configure adapter services.
To configure a DeleteSQL service
1. In Designer, right-click the package in which the service should be contained and select New > Adapter Service.
2. Select the parent namespace, type a name for the adapter service, and click Next.
3. Select Adapter for JDBC as the adapter type and click Next.
4. Select the appropriate Adapter Connection Name and click Next.
5. From the list of available templates, select the DeleteSQL template and click Finish.
The adapter service editor for the adapter service appears. You can select the Adapter Settings tab at any time to confirm adapter service properties such as the Adapter Name, Adapter Connection Name, and Adapter Service Template, as necessary.
6. Select the Table tab to configure the database table to be updated and set the fields as follows:
Field | Description/Action |
Table Name | Select a table name. The default for the associated catalog name is current catalog. The default for the associated schema name is current schema. The table name must not contain a period. If the table name does contain a period, Designer will throw an error. Note:
Informix databases do not allow you to specify a catalog and database name because you can only access the current catalog. |
Type | The table type displays automatically based on the table you select. |
7. Use the WHERE tab to specify the conditions for selecting information:
a. Select the 
icon to define new WHERE clause fields. b. Select a logical operator from the AND/OR field, an Operator, and separators (the left and right parentheses) as needed.
Use the following fields:
Field | Description/Action |
AND/OR | The logical operator. |
Column | The name of the column you want to use in the WHERE clause. |
Operator | The operator used with the Column and Input Field. |
Input Field | The default value is ?, which acts as a placeholder for the variable so that you can set the input variable for that column at run time, or get input external to this adapter service. You can also type a fixed value in this field now or at run time. If you type a fixed value, be sure that it is valid, or an exception will be generated at run time. |
The adapter automatically generates values for the following fields:
Field | Description |
Parameter | The number of the inserted row. |
Column (second occurrence of this field) | The name of the column you want to use in the WHERE clause. |
JDBC Type | The JDBC type of the corresponding Input Field. |
Input Field Type | |
Input Field (second occurrence of this field) | The name of the input field. By default the name combines the values of the Parameter and Column fields. However, you can also choose to specify any custom value. |
Note:
For Oracle users, if you use a CHAR(n) data type and enter a value in the Input Field, Adapter for JDBC automatically sets the ORACLEFIXED_CHAR data type as the JDBC data type.
Note:
The WHERE clause does not support the java.sql.Array data type.
8. Use the Result tab's Result Field and Result Field Type to specify the output field name and corresponding field types for the resulting number of rows that have been inserted.
9. To verify input or output information for this service, use the Input/Output tab as needed.
10. From the File menu, select Save.