Migration Guide : D. Features Introduced in OpenROAD 6.0 : New Features : Expanded Ingres Functionality
 
Share this page                  
Expanded Ingres Functionality
Previous versions of OpenROAD used database technology based on Ingres 2.0. OpenROAD 6.0 is based on Ingres 9.2, enabling OpenROAD to utilize more Ingres functionality.
The "Language Elements" chapter of the Language Reference Guide is enhanced to provide details of the new data types, functions, and SQL statements now supported. For more information, see Documentation Updates.
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.
Function Support
OpenROAD also provides new function support for:
Data type conversion functions
Numeric functions
String functions
Date functions
Hash functions
Random number functions
Aggregate functions
Data Type Conversion Functions
New support is available for the following conversion functions:
SMALLINT(expr)
NCHAR(expr)
NVARCHAR(expr)
Numeric Functions
OpenROAD 6.0 now supports the following numeric functions:
ACOS(n)
ASIN(n)
ATAN2(n)
CEIL(n)
CEILING(n)
FLOOR(n)
LN(n)
PI()
ROUND(n,i)
SIGN(n)
TAN(n)
String Functions
Support is now available for the following string functions:
ASCII(v1)
CHARACTER_LENGTH(c1)
CHR(n)
LOWER(c1)
LTRIM (expr)
OCTET_LENGTH(c1)
RTRIM(expr)
SOUNDEX(c1)
UPPER(c1)
Date Functions
OpenROAD now supports the following date functions:
GMT_TIMESTAMP(s)
ISDST(date)
DATE4(s)
WEEK_ISO()
MICROSECOND()
NANOSECOND()
Hash Functions
OpenROAD now supports the hash function HASH(n).
Random Number Functions
OpenROAD now supports these random number functions:
RANDOM()
RANDOMF()
RANDOM(l,h)
RANDOMF(l,h)
Aggregate Functions
OpenROAD now supports these unary aggregate functions:
ANY
STDDEV_POP
STDDEV_SAMP
VAR_POP
VAR_SAMP
Support is also available for these binary aggregate functions:
REGR_COUNT
COVAR_POP
COVAR_SAMP
CORR
REGR_R2
REGR_SLOPE
REGR_INTERCEPT
REGR_SXX
REGR_SYY
REGR_SXY
REGR_AVGX
REGR_AVGY
Additional Statement Support
Many new SQL statements are now supported. See the Language Elements chapter of the Language Reference Guide for more information about statements that OpenROAD supports.