Thursday, April 30, 2009, El Cerrito, CA -- FFE Software, Inc. announced immediate availability of FirstSQL/J Enterprise Edition, Version 3.20 and FirstSQL/J Professional Edition, Version 3.20. The Enterprise and Professional Editions are full featured Object/Relational Database Management Systems (ORDBMSs). Both products are available through our Download Page.

FFE hailed the new release as a major step in the continuing improvement of the product. Version 3.20 offers JME compatibility, significant advancements in SQL92 compliance, Unicode and boolean data types, access to external data in SQL, soundex and regular expression functions and other features.

Lee Fesperman, CEO of FFE Software, stated, "3.20 is feature-rich and builds towards the revolutionary capabilities of the next major release, code named - Diamond."

3.20 Details
The new Version 3.20 includes the following enhancements:

• Full Compatibility with JME (CDC),
• SQL92 Compliance,
  • JOIN Construct - CROSS JOIN, INNER JOIN, FULL OUTER JOIN and NATURAL and USING clauses
  • INTERSECT, EXCEPT Set Operations and CORRESPONDING clause,
• New Data Types,
  • NCHAR, NVARCHAR -- Unicode support and N'...' literals
  • BOOLEAN -- True/False scalar values,
• Access to External Data in SQL -- a special plugin capability that allows user defined Java methods returning a rowset to be used in the FROM clause in place of a table reference,
• New Builtin Functions,
  • soundex -- generates standard 4 character soundex value for a character string
  • regex -- uses regular expression patterns to match and capture information in a character string,
• General Performance Improvements, and more.