Commands

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

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]

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.

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

Syntax added to support transfer table:

with transfer table [on | off]

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"

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"

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" 

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" 

• 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.