Warehouse Release 3.01.1200
06/21/2005
The features in the 3.01.1200
release
. Native support for HP-UX PA RISC 2.0 and Itanium systems has been added.
The OS identifier
(last character) in the version number of
Warehouse indicates one of the following:
F - Hewlett-Packard
HP-UX PA RISC 2.0 (Oracle dynamically linked)
G - Hewlett-Packard
HP-UX Itanium (Oracle dynamically linked)
H - Hewlett-Packard
HP-UX PA RISC 1.1 (Oracle statically linked)
I - Silicon
Graphics IRIX Operating system
L - Red
Hat Linux
M - Hewlett-Packard
3000 MPE/iX operating system.
R - IBM
RS6000 system running AIX
S - Sun
Microsystems system running SunOS/Solaris
W - Microsoft Windows/Windows NT operating system
. A new function called HASH has been added that returns a "random" 32-bit integer from the parameters.
The syntax is:
number
= HASH(parm1 [, parm2 [, parm3 ...] ] )
Any number of parameters to HASH may be
supplied. HASH returns a value created
from the parameters by using a 32-bit cyclic redundancy check (CRC)
algorithm. The purpose of HASH to create a key value
that can quickly be accessed using an indexed table. This can
create dramatic performance improvements over
searching for a number of values individually. HASH returns a value
from -2147483648 to 2147483647. Examples:
Expression Result
HASH(0)
-148897096
HASH(0,
0) -538414411
HASH(0, 0,
0) 1309568012
HASH(0,
1) -618041598
HASH(1,
0)
59107330
HASH("One")
-982575239
HASH("One
") -1632807640
HASH("One",
1) -1743613981
HASH($null)
79764919
. A problem has been fixed with the ISNUMERIC and NUMERIC
functions where imbedded C's and D's did not get
detected as an error. A leading or
trailing C or D is still permitted. e.g.
NUMERIC("123D") returns -123, but NUMERIC("12D34")
now returns an error.
. A divide by zero operation could cause an abort because
the result was not properly initialized.
This has been fixed. Also, a divide by
zero with a preprocessor statement has been fixed.
. A problem with the PAD function accessing variables that
allow null values has been fixed.
. A problem with the STR
function that prevented access of the last character
of a double-byte string variable (NSTRING, ODBC NCHAR, etc.) has been fixed.
Release 3.01.1200 is available now on all supported platforms.