Warehouse Release 3.01.1300

08/16/2005

The features in the 3.01.1300 release 

 . The database type DB2 is now supported in Warehouse connection testing (run Warehouse with -c or -connect parameter)

  DB2 database connections can now be tested.

 

. Reading DB2 databases using the == operator is now supported.

Due to an issue with DB2, the == operator generated an error with DB2.

 

For Oracle and ODBC databases, the statement: READ R=DBTAG.TBL FOR COL == VAL generates the following SQL statement to perform the read:

SELECT * FROM TBL WHERE ((COL) = (?) OR ((COL) IS NULL AND (? IS NULL))

 

Due to an idiosyncrasy of DB2, this statement does not work. For DB2 databases, the following SQL is now generated for the == operator in a READ:

SELECT * FROM TBL WHERE (NULLIF(COL,?) IS NULL AND NULLIF(?,COL) IS NULL)

 

. Archive files 

A problem has been fixed when reading archive files where the first table in the archive archive file does not contain any records.

 

. Job Control Database (MPE)

A problem creating a job control database schema for MPE has been fixed. On the previous release, attempting to create a job control database schema for MPE caused a program abort.

 

 . XML Output

A problem writing a double quote (") to an XML file has been fixed. A double quote written to an XML file is now written as """. In previous releases a double quote was written incorrectly as "&??;"

 

. Support of Function Preview

A couple of minor changes have been made to support reference function preview in DataBridger Studio.

 

Release 3.01.1300 is available now on all supported platforms.