Commands

SAP ASE version 16.0 introduces changes to commands.

• alter database for Full Database Encryption
  In SAP ASE version 16.0, you can use the alter database command to encrypt and decrypt databases.
• alter index
  Change the compression state of future index inserts or updates using the index_compression clause.
• alter table for Index Compression
  Change the compression state of future index inserts or updates using the index_compression clause.
• alter table for Multiple Triggers
  If there are multiple triggers on a table, the table owner can disable any or all of the multiple triggers defined on that table.
• alter table for Residual Data Removal
  The alter table command supports the ability to remove residual data from deletions in SAP ASE.
• create archive database for Full Database Encryption
  The create archive database command supports the full database encryption feature.
• create database for Full Database Encryption
  You can use the create database command to create a fully encrypted database.
• create default
  The or replace clause allows you to replace a default's definition using create default.
• create encryption key
  The create encryption key command supports the full database encryption feature.
• create function
  The or replace clause allows you to replace a user-defined function's definition using create function.
• create function (SQLJ)
  The or replace clause allows you to replace a user-defined SQLJ function's definitions using create function.
• create index
  An index or index partition can be compressed with the index_compression clause.
• create procedure
  The or replace clause allows you to replace a procedure's definition using create procedure.
• create procedure (SQLJ)
  The or replace clause allows you to replace a SQLJ procedure definitions using create procedure.
• create rule
  The or replace clause allows you to replace a rule's definition using create rule.
• create table for Index Compression
  Indexes on a specified table can be compressed with the index_compression clause.
• create table for Residual Data Removal
  The create table command supports the ability to remove residual data from deletions in SAP ASE.
• create trigger for Multiple Triggers
  Create multiple triggers using the create trigger command, and specify the order that the triggers fire with the new order parameter.
• create trigger for or replace
  The or replace clause allows you to replace a trigger's definition using create trigger.
• create view
  The or replace clause allows you to replace a view's definition using create view.
• drop encryption key
  Deletes the database encryption key from the sysencryptkeys table in the master database.
• drop trigger
  You can use drop trigger to remove or replace an existing trigger, or multiple triggers.
• dump database
  dump database adds a cyclic redundancy check for accidental changes to raw data for database or transaction dumps created with compression to check and for verification that the compression blocks can be correctly read and decompressed
• kill
  The kill command adds the with force parameter.
• load database
  load database adds a cyclic redundancy check for accidental changes to raw data for compressed database or transaction dumps.
• select
  Issuing select statements that reference only @variables, @@global variables, and constants on SAP ASE version 16.0 and later in chained mode do not start new transactions.
• select into
  The select into syntax has been extended to create an index compressed table by selecting from an existing table.
• set
  SAP ASE version 16.0 introduces changes to the set command.