Date Data Type
OpenSQL supports date data types for sessions connected to:
• The Ingres DBMS
• An Enterprise Access product to a host DBMS that supports date data types (for example, DB2 UDB, Oracle, or Rdb)
If the host DBMS supports date data types, the iidbcapabilities standard catalog table includes a row where cap_capability is set to OPEN_SQL_DATES, and cap_value is set to LEVEL 1.
Tables created in OpenSQL with date columns are mapped to the date format of the host DBMS. For example, OpenSQL date would map to Rdb date and to IBM timestamp.
On input, date constants in queries must be specified using the OpenSQL date() function.
OpenSQL supports the following operations on date data:
• Ordering on date columns
• Comparing two date columns
• Comparing a date column to a date constant