Corporation Video Gaming Accessories User Manual

Modeling Interactions for OracleAS Adapter for IMS/DB
Installing and Configuring the OracleAS Adapter for IMS/DB 2-45
f.
Click Finish to generate the interaction, including the record schema required
to support the interaction input and output.
Modifying Existing Interactions
You can modify the interaction definitions to the exact requirements of the application,
in the Design perspective Metadata tab.
The following example uses the DELETE interaction, generated in the previous task, to
describe how the interactions can be modified:
1. In the Metadata tab, right-click the interaction to modify and select Open.
The adapter metadata editor opens, displaying the General tab.
The General tab displays general information about the way the interaction is
executed. You can add a description of the interaction and define the mode of
operation for the interaction. The following modes are available:
■ sync-send-receive: The interaction sends a request and expects to receive a
response.
■ sync-send: The interaction sends a request and does not expect to receive a
response.
■ sync-receive: The interaction expects to receive a response.
The information for a request is passed in the input record. The information for the
response from the IMS/DB data source is passed in the output record.
For more information, see "Adapter Metadata General Properties".
2. Click the Advanced tab to display specific information about the interaction.
As required, change the SQL and the parameters associated with the SQL.
Parameters are specified in a SET clause or in a WHERE clause with the following
format:
:parameter_name
For more information, see "Interaction Advanced Tab"
Nullable The nullable value (true or false).
Default The default value for the parameter.
Context
Field
This field is not applicable.
Bind to Sqls This field is not applicable.
See Also: "Adapter Metadata" on page A-13 for details about the
data source metadata.
Note: The interaction modification procedure is the same for all
types of SQL statements (INSERT and UPDATE) as described, using
a DELETE SQL statement.
Table 2–17 (Cont.) Interaction Parameters
Parameter Description