Chapter 4: New Features in Adaptive Server Version 12.5.1

New and changed Transact-SQL commands

This section describes the new and changed Transact-SQL commands in version 12.5.1.

Table 4-4 summarizes the new Transact-SQL commands.

**Table 4-4: New commands**
Command	Function
mount	Use the mount command to add information for devices and other attributes for the database to the destination or secondary Adaptive Server. The mount command decodes the information in the manifest file and makes the set of databases available online.
unmount	The unmount command shuts down the database and drops it from the Adaptive Server. The devices are also deactivated and dropped.

Table 4-5 summarizes the changes to existing Transact-SQL commands:

**Table 4-5: Changed commands**
Command	Change
select	A SQL-derived table can be used in the from clause of a select statement. This includes a select statement that appears in an insert or create view statement. For more information, see the Adaptive Server Enterprise Reference Manual.
checkpoint	Enhancements: Allows specification of an optional list of target databases or the keyword all. Performs an automatic checkpoint for sp_dboption, which requires checkpoint to continue. Permission to execute checkpoint is granted to the oper_role.