Previous Topic

Next Topic

c-treeACE SQL Enhancements

Generic Chapter Banner

Introduction

c-treeACE SQL is faster than ever. The query optimizer has undergone extensive analysis and revision to enhance performance. The SQL syntax has enjoyed numerous additions. Many additional scalar functions have been added for even more flexibility in your SQL database design. A major enhancement has been the merging of the previously separate c-treeSQL Servers into a single engine: the c-treeSQL Server and the c-treeSQL Server Java Edition. The result is c-treeACE SQL with dynamic support for Java stored procedures, triggers and user defined functions deployable in a small easy to package footprint. One engine -- one solution.

And don’t forget, c-treeACE SQL is a superset of the c-treeACE ISAM Server. Thus all of the enhancements made to the c-treeACE ISAM Server are also available with c-treeACE SQL Be sure to review the c-treeACE ISAM Server chapter and discover all of the latest benefits available for you.

In This Chapter

Improved Query Optimizer Performance

Stored Procedures, Triggers, and User Defined Functions Now Standard Features

Advanced Encryption for c-treeACE SQL Tables

Default HUGE Files for Tables

Quickly TRUNCATE Tables

Maximum Field Lengths for Non LONGVAR Fields Raised to 8K

Additional Scalar Functions Available

Advanced Searching with CONTAINS Clause and LVARCHAR Fields

Support for SQL Transaction Isolation Levels 1 and 2

Additional Search Options for c-treeACE SQL LONG Field Types

Query Timeout Options

Complete RIGHT OUTER JOIN Syntax

DEFAULT Clause with ALTER TABLE

ODBC and JDBC Driver Socket SEND/RECV Timeout

ODBC Driver Login Timeout

Improved c-treeACE SQL Java Configuration

Reserved Keywords With Microsoft Excel and ODBC

Additional ORDER BY Clause Usage

Copy a Database with the c-treeACE SQL Maintenance Utility

PREIMAGE Tables in c-treeACE SQL

FairCom Security Handshake Now Available in all c-treeACE SQL Products

Updated c-treeACE SQL Reserved Words