Oracle® Application Server Integration Adapter for IMS/DB Installation and User's Guide 10g (9.0.4) Part Number B10505-01 |
|
The Oracle Application Server Integration Adapter for IMS/DB provides basic support for standard ANSI '92 SQL along with a number of enhancements, all of which can be used when specifying adapter interactions. This appendix contains the following sections:
The Oracle Application Server Integration Adapter for IMS/DB provides full support for SELECT
, DELETE
, INSERT
, and UPDATE
statements, when specified in interactions.
The Oracle Application Server Integration Adapter for IMS/DB enables the use of the following operators in SQL statements:
Table C-1 Arithmetic Operators
Operator |
---|
+ |
- |
* |
/ |
Operator |
---|
= |
> |
< |
>= |
<= |
<>, !=, ^= |
IS NOT NULL |
IS NULL |
The Oracle Application Server Integration Adapter for IMS/DB enables the use of the following functions in SQL statements:
You can incorporate the following SQL enhancements into the adapter interactions to handle hierarchical data in IMS/DB.
A hierarchical query nests a SELECT
statement as one of the columns of the rowset retrieved by a nested SELECT
statement.
Use braces ({}) to delimit the nesting.
Data stored hierarchically in a IMS/DB data source can be referenced by using a hyphen followed by a right arrow (->) to denote the parent child relationship in the source:
FROM ... parent_name->child1->child2... [alias]
Or, using an alias for the parent table:
FROM ... parent_alias->child1->child2... [alias]
You can produce a flattened view of hierarchical data by embedding a SELECT
statement inside the list of columns to be retrieved by another SELECT
statement. You use parentheses to delimit the nesting. The nested SELECT
statement can reference a child rowset (using the parent->child syntax) only in its FROM
clause.
To list the hierarchical data with the parent data only, you must use an alias for the child data.
|
![]() Copyright © 2003 Oracle Corporation. All Rights Reserved. |
|