Oracle Application Software 10.1.3.4 Manuale Utente Scaricare il pdf (Pagina 135)

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

1 2 ... 130 131 132 133 134 135 136 137 138 139 140 ... 169 170

Nessun commento

Oracle Application Software 10.1.3.4 Manuale Utente Pagina 135