Commands

Adaptive Server 15.7 ESD #2 contains new and changed commands.

New commands
Command	Description
create {precomputed result set \| materialized view }	Defines precomputed result sets.
alter {precomputed result set \| materialized view }	Alters the properties or policies of a precomputed result set.
refresh {precomputed result set \| materialized view }	Refreshes the specified precomputed result set.
drop {precomputed result set \| materialized view }	Drops a precomputed result set.
truncate {precomputed result set \| materialized view }	Truncates the data in a precomputed result set.
dump configuration	Creates a backup of the Adaptive Server configuration files into a specified dump directory. The copy is created by the Adaptive Server, not the Backup Server.

Changed Commands
Command	Change
alter database	noasync_init – Indicates that you are extending a database, and that Adaptive Server initializes the extended space asynchronously
alter table	with immediate_allocation – creates regular, nondeferred tables. split partition – redistributes data to two or more partitions. merge partition – combines the data from two or more merge-compatible partitions into a single partition. move partition – moves a partition (and its index) to a specified segment. drop column – drops columns from a table without performing a data copy. noasync_init – indicates the database is initialized synchronously.
create database	noasync_init – indicates the database is initialized synchronously.
create index	Allows you to issue a parallel form of create index that uses the query execution engine to more efficiently execute the command.
create table	with deferred_allocation – creates deferred tables. with immediate_allocation – creates regular, nondeferred tables.
dump database	Dumps a database according to the settings in the dump configuration file.
grant	as `pred_name` – the name of the predicate grantby `grantor` – indicates the grantor who grants permission to the user or role.
grant role	where `pred_expression` – The SQL condition that must be satisfied when the named role is activated.
load database	New parameters: listonly=load_sql – generates a sequence of load database and load transaction SQL statements to restore a database to a specified point in time. until_time – the database is restored up to this date and time. listonly=create_sql – generates a sequence of create database and alter database SQL statements.
load transaction	listonly=create_sql – generates a sequence of create database and alter database SQL statements.
merge	merge target tables may include triggers.
reorg rebuild	with online – allows you to reorganize your data without taking it offline
set	materialized_view_optimization – determines which precomputed result sets are considered during query optimization mon_stateful_history – when disabled, queries to the historical monitoring tables return all rows in the table buffer. When enabled, queries to the historical monitoring tables return only rows that were added to the tables since mon_stateful_history was disabled. show_transformed_sql – displays the SQL text for statements during the Adaptive Server preprocessing phase
update statistics	no_hashing – (the default) uses the sort-hashing algorithm from versions of Adaptive Server earlier than 15.7 ESD #2. partial_hashing – Adaptive Server uses hashing for low unique count domains.

update index statistics, update statistics, and update all statistics include the print_progress parameter, which allows these commands to display progress messages.

See the Reference Manual: Commands.