DBMaker Version 4.0

DBMaker 4.0 is a completely revised version of the software that makes DBMaker SQL 99 compliant, simplifies administration, improves performance, and enhances compatibility. New features are summarized below.

ANSI SQL99 Compliant functions and other SQL enhancements:

• Supports cross, inner, and right join syntax
• Supports CASE, COALESCE, and NULLIF syntax
• Supports the Type Cast function
• Supports Order by Expression
• Sets default identifier name to case insensitive
• Allows an Insert value with an expression
• Allows the Select Statement without the From Clause
• Enhances Create Table and Alter Table functions
• Allows to set max row and offset of a result set
• Adds more SQL99 functions and data types
• Supports SQL99 Date, Time, and Timestamp literal syntax
• Allows connection string settings in the SQLConnect API

Database administration enhancement:

• Processes database statistics automatically by daemon
• Refines database backup and restore management
• Supports database diagnose and repair functions
• Supports more database management wizards in administration tools
• Supports file object backup solution
• Supports hierarchical file object directories
• Allows file object directory to be changed on line
• Supports more run-time information and statistics
• Supports database monitors for a historical view of system statistical information
• Allows Create Index on a specified Tablespace

XML and data transfer solution:

• Supports Stored Procedures to transfer data between a database and XML files
  
• Supports Data Transfer Tool to import and export data from TEXT files, XML files, and ODBC data sources

System limitation enhancements:

• Enlarges identifier name length to 32
• Enlarges maximum connections to 1200
• Enlarges decimal precision to 38

Performance improvements:

• Refines the network communication mechanism
• Refines the query execution algorithm
• Refines temporary memory table management
• Supports group commit functions
• Enlarges internal temporary file size to larger than 2G
• Refines ODBC catalog Describe function performance

DCI (DBMaker - COBOL Interface) function enhancement:

• Supports XFD definition rebinding
• Supports Simple (single table) updateable view
• Allows a NULL value to be used in an Insertion