Oracle Application Server 10.1.3.4, User Manual

Page: 135 / 170

Adapter Metadata
Advanced Tuning of the Metadata A-17
Figure A–9 Interaction Advanced Tab
This tab has three sections.
The SQL Statement section lets you build any valid SQL statement. Use the tabs to
select the tables and statement types and build a statement. When you select Enable
manual query editing , you can manually enter a valid SQL statement at the bottom of
the screen.
The Interaction Properties section lets you select any of the following:
■
Pass Through : Select this to pass a query directly to the IMS/DB data.
■
Reuse compiled query : Select this to save query objects created in the previous
execution to the cache. This allows the objects to be reused.
■
Fail on no rows returned : Select this if you want to the system to return an error if
no rows are selected.
■
Encoding : Select one of the following from the list:
– base64 : Select this for base 64 encoding