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