Warehouse Release 3.00.1600

02/20/2004

The features in the 3.00.1600 release are:

ARRAYIFY : SQL (Oracle and ODBC) table layouts may now be interpreted to contain arrays. To enable this feature for a database, use the SET ARRAYIFY statement.

The syntax is: SET db-tag ARRAYIFY ON

OPEN SRCDB ORACLE ...
SET SRCDB ARRAYIFY ON

When SET ARRAYIFY ON is performed on a database, consecutively named columns are interpreted by Warehouse as belonging to an array. For example, if a table format is:

COMPANY_ID : ODBC CHAR(10)
COMPANY_NAME : OCBC CHAR(60)
QTR_1 : OCBC DECIMAL(16,2)
QTR_2 : OCBC DECIMAL(16,2)
QTR_3 : OCBC DECIMAL(16,2)
QTR_4 : OCBC DECIMAL(16,2)
YEAR_TOT : ODBC DECIMAL(16,2)

If ARRAYIFY is ON, the table will be interpreted by Warehouse as:

COMPANY_ID : ODBC CHAR(10)
COMPANY_NAME : OCBC CHAR(60)
QTR_ : ARRAY [1..4] OF OCBC DECIMAL(16,2)
YEAR_TOT : ODBC DECIMAL(16,2)

QTR was identified as an array because of adjacent and consecutively numbered columns of the same type. The purpose of SET ARRAYIFY ON is allow WHILE loops to access columns as though they were arrays. Unless a WHILE loop is necessary to access consecutively columns, this feature should not be used.

SET ARRAYIFY must be issued after the OPEN but *BEFORE* any other statements access the database.

NOTE: This feature subject to change in the future.

Release 3.00.1600 is available now on all supported platforms.