Data Type Support
The "Language Elements" chapter of the Language Reference Guide details the relationship between Ingres DBMS intrinsic data types and OpenROAD intrinsic data types. It also denotes built-in system classes for data types and built-in scalar objects where available.
OpenROAD 6.0 provides full support for the following data types:
• nchar
• nvarchar
The following new data types are supported with a loss of precision:
• timestamp
• timestamp with time zone
• timestamp without time zone
The integer8 data type is supported partially. Within 4GL code, you may pass integer8 values to and return integer8 values from 4GL frames, 4GL procedures, and userclass methods. You also may pass integer8 values to 3GL procedures and return integer8 values from them.
Integer8 appears in the OpenROAD Workbench 6.0 return value data type selection frame. Integer8 values, however, cannot be properly passed as 8-byte integer values to and from OpenROAD system class methods, and cannot be used in 4GL code as array indexes.
Integer8 data cannot be marshaled either to or from an application running within an OpenROAD Server using the COM, JNI, .NET, or OpenROAD RemoteServer class. Passing integer8 data to and from an ActiveX control is not supported.