Commands

New and changed commands in Adaptive Server 15.0

New commands

Command

Function

create service

For creating a user-defined Web service.

drop service

For creating a user-defined Web service.

update table statistics

Updatex systabstats statistics for a table or a partition.

New set command options

set Option

Description

set delayed_commit

Allows you to determine when log records are written to disk. With the delayed_commit parameter set to true, the log records are asynchronously written to the disk and control is returned to the client without waiting for the IO to complete

set plan optgoal

Sets the optimization goals at the session level.

set plan opttimeoutlimit

Sets the limit the time taken by long-running and complex queries at the session level.

set metrics_capture on/off

Activates QP metrics at the session level.

Changed commands

Command

Change

alter table

Syntax added to support computed and materialized or non-materialized columns. Adds support for paritions.

create index

Enhanced to allow computed columns to be used as index keys, in the same way as regular columns, and to create function-based indexes. Adds support for paritions.

create table

Syntax added to support computed and materialized or non-materialized columns. Adds support for paritions.

dbcc

Adds support for partitions.

declare cursor

Syntax added for scrollable cursors. Syntax added to support semi_sensitive, insensitive, and scrollable cursors.

delete statistics

Adds support for partitions.

disk init

The size parameter can be specified in terabytes.

Adds the directio parameter, which allows you to configure Adaptive Server to transfer data directly to disk, bypassing the operating system buffer cache

disk reinit

Adds the directio parameter, which allows you to configure Adaptive Server to transfer data directly to disk, bypassing the operating system buffer cache

fetch

fetch_orientation options added to support scrollable cursors: next, prior, first, last, absolute, and relative.

reorg

Adds support for partitions.

select

for xml clauses added to support XML services. Adds support for partitions.

truncate table

Adds support for partitions.

update all statistics

Adds support for partitions.

update statistics

Adds support for partitions.

update partition statistics

Made obsolete.