Was this helpful?
Implementation Differences
This section describes differences in implementation between Ingres and the other Enterprise Access databases related to the following listed items. Most differences described in this section apply to all non-Ingres databases. Exceptions are noted.
OpenSQL statements
SQL statements
Tables
Create View statement
Copy Table support
Collation sequence
Table and column ID length
Dynamic parameters
Locking strategies
Multi-statement transactions
UNION ALL ordering
UNION – Derived result column name
UNION of Select First N
NULL literal
Last modified date: 02/16/2024