V9 Update Guide

FairCom DB SQL Enhancements

Introduction

FairCom DB 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 FairCom DB 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, FairCom DB SQL is a superset of the FairCom DB ISAM Server. Thus all of the enhancements made to the FairCom DB ISAM Server are also available with FairCom DB SQL Be sure to review the FairCom DB 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 FairCom DB 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 FairCom DB 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 FairCom DB SQL Java Configuration Reserved Keywords With Microsoft Excel and ODBC Additional ORDER BY Clause Usage Copy a Database with the FairCom DB SQL Maintenance Utility PREIMAGE Tables in FairCom DB SQL FairCom Security Handshake Now Available in all FairCom DB SQL Products Updated FairCom DB SQL Reserved Words