New Features and Upgrading Guide
CHAPTER 4. Behavior Changes
In addition to the support for SQL statements that carry out database administration tasks (see Database file manipulation statements), there are several changes to the behavior of the administration utilities.
The new behavior is documented in Database Administration Utilities. This section describes behavior changes from previous versions of the software.
ISQL name change The ISQL utility file name has been renamed to dbisql.exe. This removes the name conflict with the Adaptive Server Enterprise isql utility. Throughout the manual, ISQL is now referred to by its full name of Interactive SQL to avoid confusion with the Adaptive Server Enterprise utility.
DBWATCH replaced The dbwatch server monitoring facility has been replaced by a Console utility named dbconsol. The Console utility can monitor the personal server as well as the network server.
dbinfo options The dbinfo utility uses a connection string to locate the database, rather than a database file name.
dbo user in utilities The -g command-line switch for the dbinit, dbupgrad, dbunload, and dbxtract utilities has been dropped. This switch was used to specify a different user name for the Adaptive Server Enterprise database owner user ID dbo.
Interactive SQL DBTOOL statement The Interactive SQL DBTOOL statement has been dropped. This statement was provided to allow database administration tasks to be executed from Interactive SQL.
Sybase Central now provides the database administration interface for interactive use, and the addition of SQL statements for administration purposes, such as CREATE DATABASE, allows scripting from other applications.
If you have existing Interactive SQL scripts that you wish to run, you can do so by running your scripts using your Version 5 ISQL utility. Alternatively, you can edit your scripts to use the new statements.
For information on using Version 5 ISQL with Version 6 software, see Using the version 5 utilities with Adaptive Server Anywhere 6.0.
Interactive SQL database tools window The Interactive SQL database tools window has been dropped. This window was provided to allow database administration tasks to be executed from Interactive SQL.
Sybase Central now provides the database administration interface for interactive use, and the addition of SQL statements for administration purposes, such as CREATE DATABASE, allows scripting from other applications.
dbunload changes To supply a list of tables to unload for the dbunload utility, you now use the -t command-line switch.
Custom collation files Previously, the value of -z could be a collation name (for an internal collation) or a file name (for a custom collation). Now, only a collation name can be specified. The corresponding collation must be defined in either collseqs.sql or custom.sql in the scripts subdirectory.
The procedure for building a database with a custom collation file is now as follows:
Create a custom collation file.
Edit the custom collation file.
Convert the file to a SQL script using the dbcollat command-line utility. This step was not required in previous releases.
Add the custom collation to the custom.sql script. This step was not required in previous releases.
Create the new database using the Initialization utility, specifying the name of the custom collation. In previous releases, you would have specified the collation file name.
For a more detailed description, see Creating databases with custom collations.
RTSQL dropped The runtime SQL processor is no longer provided. You can use Interactive SQL with -q to perform any tasks previously performed by RTSQL. From the command line, the syntax is as follows:
dbisql -q isql-command