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.