Oracle Application Software 10.1.3.4 Bedienungsanleitung PDF herunterladen (Seite 159)

Supported SQL Syntax and SQL Enhancements D-1

Supported SQL Syntax and SQL

Enhancements

OracleAS 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:

■ Supported SQL Statements

■ Supported Operators

■ Supported Functions

■ SQL Enhancements

Supported SQL Statements

OracleAS Adapter for IMS/DB supports SELECT, DELETE, INSERT, and UPDATE

statements, when specified in interactions.

Supported Operators

OracleAS Adapter for IMS/DB enables the use of the following operators in SQL

statements:

■ Arithmetic Operators

■ Comparison Operators

Table D–1 Arithmetic Operators

Operator

Table D–2 Comparison Operators

Operator

1 2 ... 154 155 156 157 158 159 160 161 162 163 164 ... 169 170

Keine Kommentare

Oracle Application Software 10.1.3.4 Bedienungsanleitung Seite 159