Other changes

New Features and Upgrading Guide
CHAPTER 4. Behavior Changes

Other changes

This section gathers together other behavior changes, which do not belong in previous sections.

File name changes Many files have changed names, including executable files.
% comments %-style comments are now a deprecated feature.

The new Percent_as_comment option controls the meaning of %. The default setting is ON (that is, % is treated as a comment indicator) for compatibility.

Procedures, triggers and views created with %-style comments are converted to double-dash comments when stored in the catalog.

Existing procedures must be recreated before changing option
Any existing procedures containing %-style comments must be recreated before changing the option setting; otherwise, the procedures will fail to load. An unload/reload of your database accomplishes this.

Ignored options Some database options duplicated the functionality of command-line switches. These options are now ignored, and only the command-line switches are acted on. The options include:
- THREAD_COUNT
- THREAD_STACK
Default NEAREST_CENTURY option The default setting for the NEAREST_CENTURY option has been changed from 0 to 50. This change does not affect existing databases: it takes effect only on databases created with Version 6.
LOAD TABLE and UNLOAD TABLE The FORMAT clause of these statements now takes a keyword (ASCII) as opposed to a string. The string 'ascii' is accepted for compatibility.
Agent connection parameter The value of engine for this connection parameter is now ignored.
sqlpp -l option SQLPP -l userid, password allowed you to provide a userid and password to be used for checking permissions on static embedded SQL statements. This feature has been removed in 6.0. Static SQL statements will use the userid and password provided on the CONNECT.
date format changes The DATE_FORMAT option takes a string argument built up from a set of predefined characters (MM for months, and so on). The f argument providing French month names is now deprecated. The month and day names are now provided according to the language version of the software.
Temporary table changes Global temp tables cannot be altered or dropped unless all users except the one making the change that have referenced the temporary table have disconnected.