User's Manual

Modeling Interactions for OracleAS Adapter for IMS/DB
2-44 Oracle Application Server Adapters for IMS/DB User's Guide
c.
Click Next. The Define Interaction screen is displayed enabling you to build
the query.
d. Click Next. The Interaction Properties screen is displayed, enabling you to
define the interaction parameters. You can set the following interaction
prameters:
e. Click Next. The Interaction Parameters screen is displayed, where you specify
input parameters for the interaction. The following parameters are specified:
Note: The option to use a previously saved query is not
applicable.
Note: If the database query option was selected in step a, then the
Define Interaction screen is displayed, enabling you to build a
SELECT statement only, as indicated in the Query type field. If the
database modification option was selected, then this field enables
you to select the required SQL modification statement from a list
(INSERT, UPDATE, or DELETE).
Table 2–16 Interaction Definition Parameters
Parameter Description
passThrough Defines whether the query is passed directly to the
back-end database for processing or processed by the
Query Processor.
Reuse compiled
query
Defines whether the query is saved in cache for reuse.
Encoding Sets the encoding method used to return binary data in
text format. You can select between the base 64 and the
hexadecimal encoding methods.
Event Defines whether the interaction mode is sync-send or
sync-receive.
Fail on no rows
return
Defines whether an error is returned in case no data is
returned
Root element Defines the root element name for records returned by the
query, using the <root> \ <record> format.
Record element Defines the record element name for records returned by
the query, using the <root> \ <record> format.
Max. records Sets the maximum number of record returned by the
query.
Null string Sets the string returned in place of a null value. If not
specified, the column is skipped.
Table 2–17 Interaction Parameters
Parameter Description
Name The name of the parameter.
Type The type of parameter (such as string, number, binary).