Irving, Texas - May 9th, 2007 -- Four Js Development tools announced today the general availability of its Genero db 3.61 maintenance release that provides compatibility enhancements and bug fixes.

The major new features in this release are:

Genero db 3.61

• The server compatibility mode, controlled by the COMPATIBILITY_MODE parameter, determines whether the CONVERT() function uses truncation or rounding when converting to integer data types. If COMPATIBILITY_MODE = SYBASE or SQLSERVER, the CONVERT() function truncates floating-point values when converting to integer types; otherwise it rounds floating-point values when converting to integer types.
• Treat “=NULL” as equivalent to “IS NULL” when COMPATIBILITY_MODE=SYBASE and OVERRIDE_ANSI_NULL = FALSE.
• Ignore trailing spaces in a LIKE pattern or in the matching string when COMPATIBILITY_MODE = SYBASE.
• Support for Sybase-style single-quoted string literals as column aliases in the target list of SELECT statements, using the syntax “SELECT 'single-quoted literal' = expression FROM ...”
• If COMPATIBILITY_MODE = SYBASE, Genero db allows a SQL-T stored procedure to be executed without error, even with parameters that are not specified in the procedure definition.
• ALTER TABLE can now specify an Oracle-style sequence as the default for a column.

For a complete listing of bug fixes download the release notes in the sidebar.