Warehouse Release 3.02.8100

02/28/2012

The fixes in the 3.02.8100 release are:

• Fixed problem accessing a CSV file on a 32-bit server from a 64-bit client. Case 22015

• Changes were made to improve the job control features, allowing failed jobs to be rerun using DataBridger Studio. Case 22015

• Improved range of memory on Windows 64.

• Added multi row access to SQL Server database access. The COMMITRATE now determines the number of rows per access as well as rate of commits on SQL Server. For example, setting the COMMITRATE to 1000 causes Warehouse to read and write 1000 SQL Server rows at once. Previously, access was one row at a time. This feature may greatly improve performance of SQL Server scripts.

• Added associative arrays. Arrays may now be declared using the syntax:

        DEFINE   : ARRAY [INTEGER] OF 

            or

        DEFINE   : ARRAY [STRING] OF 

   An INTEGER indexed associative array must have an index from
   -2,147,483,648 to +2,147,483,647.

   A STRING indexed associative array must have an index length no longer
   than 255 characters.

   Accessing an array element with a valid index creates the element.

   Associative array index values may be enumerated with the READ statement.

   Here is an example script showing associative arrays:

            DEFINE GREEKS : ARRAY [STRING] OF ODBC INTEGER

            SETVAR GREEKS["alpha"]      = 1
            SETVAR GREEKS["beta"]       = GREEKS["alpha"]   + 1
            SETVAR GREEKS["gamma"]      = GREEKS["beta"]    + 1
            SETVAR GREEKS["delta"]      = GREEKS["gamma"]   + 1

            READ GL = GREEKS ORDER BY INDEX DESC
                PRINT INDEX : 5, GREEKS[INDEX]
            ENDREAD

        The script output is:

            gamma           3
            delta           4
            beta            2
            alpha           1
        

Release 3.02.8100 is available now on all supported platforms.