Corporation Video Gaming Accessories User Manual

Supported SQL Syntax and SQL Enhancements D-1
D
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
=