Warehouse Release 3.02.6300

2009/04/24

The features in the 3.02.6030 release are:

. Internal changes to OPEN statement for CSV files.

. Fix showinfo display for 64-bit windows to show "MS Windows64" instead of "MS Windows".

. Added show statistics for DIRECT INSERT, UPDATE and DELETE statements.

. Added REPLACE as a preprocessor function.

REPLACE has been a script function, but has now been added as a preprocessor function too. The syntax is:

string = REPLACE(source-string, search-string, replacement-string)

Example:

If on Windows, you have a Warehouse script that begins:

#IF NOT DEFINED(INPUT_FILE)

#PRINT "Variable INPUT_FILE must be defined before running."

#EXIT 1

#ENDIF

OPEN INF CSV "${INPUT_FILE}" FIELDNAMES

#SETVAR INPUT_FILE_NAME = REPLACE(INPUT_FILE, "\\", "\\\\")

PRINT "Using CSV file ${INPUT_FILE_NAME}"

It may be called using the commands:

C:\>SET INPUT_FILE=C:\Program Files\Taurus\Wh Scripts\Fact File.csv

C:\>Warehouse -START "C:\Program Files\Taurus\Wh Scripts\My Script.wh"

The output will then be:

Using CSV file C:\Program Files\Taurus\Wh Scripts\Fact File.csv

.

Release 3.02.6300 is available now on all supported platforms.

ÿ