Inside This Issue:

Welcome to this special focused edition of the FairCom e-Newsletter! This volume is exclusively devoted to the powerful c-treeSQL Server. Discover new features and answers to many common questions. Call your nearest FairCom office when you're ready to make the switch to c-tree Plus and c-treeSQL!

Strengthen Your Application With c-treeSQL

If you haven't taken the opportunity to try the c-treeSQL Server, or even read much about this technology, then this article is for you! In spite of our efforts (including direct mail, press coverage, our Web site, and 14 pounds of documentation dropped on desks worldwide with recent releases of c-tree), we STILL find customers who "forget" that the power of SQL is within their grasp. Read on for how it can benefit YOU...

Let Your Existing ISAM Applications Co-Exist With c-treeSQL!

A recurring constraint frequently placed upon developers is maintaining backward compatibility when updating applications. c-tree Plus has been architected with this issue in mind. A common question is how to migrate existing traditional ISAM applications to take advantage of the powerful reporting capabilities of c-treeSQL. With just a few simple considerations, all of your data can be accessible with c-treeSQL!

What is Your Type?

c-tree SQL offers a full range of data types to handle nearly any data storage requirement. A frequently asked question is, "What types do I use to describe my data?" And relatedly, "What data types are available with c-treeSQL?"

New c-treeSQL User Defined Functions

The Version 8.14 c-treeSQL Server Java Edition introduces new User Defined Functions, in addition to our stored procedures and triggers support. Utilize the power of the Java programming language to write your own scalar functions. You now have nearly limitless abilities to operate on data the way your application demands. See how you can put this great new feature to work for you today.

Differences With c-treeSQL Date Types

The following query on a table containing a Date field returned unexpected rows:

SELECT * FROM myTable 
WHERE myDate >= '0001-01-01' AND myDate <= '9999-01-01'

However, this query works:

SELECT * FROM myTable 
WHERE myDate >= '1700-03-01' AND myDate <= '9999-01-01'

Why the difference?

Leverage the Power of Java in your c-treeSQL Server Environment

With Version 8.14, the c-treeSQL Server supports Java JDBC access out of the box. The c-treeSQL Server Java Edition provides additional features beyond those available with the c-treeSQL Server, thereby delivering enhanced productivity for developers and performance for c-treeSQL applications. Using the powerful Java language and utility classes, you can add server-side functionality to increase performance, enforce business logic, and maintain data integrity. Configure your c-treeSQL environment to take advantage of your existing Java programming skills today.

Use JDBC With any c-treeSQL Server

With the Version 8.14 of c-treeSQL, the c-treeSQL JDBC driver connects with both the c-treeSQL Server and the c-treeSQL Server Java Edition, eliminating the necessity of a specific c-treeSQL Server for JDBC access as required with previous version of c-treeSQL. Communicate with the c-treeSQL Server, or use the flexible stored procedures and triggers available with our c-treeSQL Server Java Edition. One driver connects to both!

Quotable Tip for c-treeSQL Reserved Words

Many times a c-treeSQL application developer chooses a logically apt column name, however, this name just happens to collide with a c-treeSQL reserved word. What should you do?

c-tree HUGE file Support with c-treeSQL

As of c-tree Plus Version 8.14, HUGE file support is enabled for all c-tree models. c-tree HUGE files can be HUGE! Eight-byte file addresses combined with segmented file support will allow files on the order of 10^19 bytes. That's 18,000,000 terabytes! This support is extended to the c-treeSQL Server.

Maximize your Options with c-treeSQL Utilities

The c-treeSQL Server is a powerful tool to manage your data and access your existing c-tree data for reporting. To ease the transition to the c-treeSQL Server a variety of tools are included, allowing you to import and export schemas and data, create new databases, and perform maintenance on existing tables.

Do I Need to Call UPDATE STATISTICS?

The c-treeSQL Server keeps track of much internal information pertaining to performance. Typically, this data is dynamically updated as necessary to maintain peak performance. Occasionally, however, it is possible for performance to degrade over time. A call to UPDATE STATISTICS can sometimes improve performance in these cases. A frequently asked question is when and if to execute this statement.

SELECT * FROM SQL History

The SQL standard has a long (and some would say sordid) history. Who was Edgar "Ted" Codd and how did his contributions change relational database history forever?

c-tree Deployment Notification

Just finished the next great killer c-tree application? Congratulation from the FairCom team! We enjoyed working with you as you attain your goals and understand the hard work and effort it takes to bring your project to the finish line. There is only one final detail to attend to. Let us know about it!

FairCom US
Phone: 573.445.6833
FAX: 573.445.9698

FairCom Europe
Sales: +39.035.721321
FAX: +39.035.721314

FairCom Japan
Sales: +81.59.229.7504
FAX: +81.59.224.9723

FairCom Brasil
Sales: +55.11.3872.9802
FAX: +55.11.3875.1309