Commands

New and changed commands for Adaptive Server 15.5

New commands
Command Description
transfer table

Initiates an incremental table transfer.

A new grant with grant option supports transfer table. It grants a specified user permission to transfer a specified table.

grant transfer table on table_name 
to user with grant option

Changed commands
Command Change
alter database Syntax added to support changing the durability of a database, the level of DML logging, a database’s template.
alter table

Syntax added to support changing a table’s logging mode for insert, update, and delete (DML) operations.

Syntax added to support transfer table:

set transfer table [on | off]
create database

Syntax added to create in-memory and relaxed-durability databases with durability set to full, no_recovery, or at_shutdown.

Syntax added to specify DML logging level and template database, if any.

create table

Syntax added to specify DML logging level for tables in in-memory databases.

Syntax added to support transfer table:

with transfer table [on | off]
disk init Syntax added to create in-memory data devices for in-memory databases.
dump database

Syntax added to support the Tivoli Storage Manager (TSM). The keyword syb_tsm invokes the Sybase interface with the TSM API (libsyb_tsm).

database_name to "syb_tsm::object_name"
dump database ... compression= Syntax added to support faster, less CPU-intensive compression levels 100 and 101.
dump transaction

Syntax added to support TSM. The keyword syb_tsm invokes the Sybase interface with the TSM API (libsyb_tsm).

database_name to "syb_tsm::object_name"
dump transaction ... compression= Syntax added to support faster, less CPU-intensive compression levels 100 and 101.
load database

Syntax added to support TSM. The keyword syb_tsm invokes the Sybase interface with the TSM API (libsyb_tsm).

database_name from "syb_tsm::
[[-S source_server_name]
[-D source_database_name]::]object_name" 
load transaction

Syntax added to support TSM. The keyword syb_tsm invokes the Sybase interface with the TSM API (libsyb_tsm).

database_name from "syb_tsm::
[[-S source_server_name]
[-D source_database_name]::]object_name" 
select into Syntax added to specify the DML logging level for tables created by selecting into in-memory or relaxed-durability databases.
set Adds:
  • dml_logging parameter for specifying the amount of logging for a session.
  • deferred_name_resolution for activating deferred name resolution at the connection level.
  • builtin_date_strings number
    Values are:
    • 0 - if a string is given as an argument to a chronological system function, the server interprets it as a datetime value regardless of its apparent precision. This is the default.
    • 1 - makes the server interpret the argument string as bigdatetime. This affects the result of chronological system functions.
.

See the Reference Manual: Commands.