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.