Sybase Adaptive Server Anywhere - Page 989

Chapter 14 System Procedures and Functions
971
DBA authority required
Causes a checkpoint to occur after the value has been updated.
The next value generated for a row inserted into the table will be
new_identity_value + 1.
No checking occurs on the new_identity_value to ensure that it does not
conflict with existing rows in the table. An invalid value could cause
subsequent inserts to fail.
The procedure accepts three arguments:
table_name identifies the table you want to set the identity value for.
owner identifies the the owner of the table you want to set the identity
value for.
new_identity_value identifies the number from which you want to start
the value counting.
The following statement resets the identity value to 101:
CALL sa_reset_identity (’employee’, ’dba’, 100)
sa_server_option system procedure
Overrides a database server command-line option while the database server
is running.
sa_server_option ( option_name , option_value )
DBA authority required.
None
Database administrators can use this procedure to override some database
server command-line options without restarting the database server.
The options that can be reset are as follows:
Option name Values
disable_connections ON or OFF
liveness_timeout integer, in seconds
quitting_time valid date and time
request_level_log_file
filename
request_level_logging ALL, SQL, NONE
Permissions
Side effects
Description
Parameters
Example
Function
Syntax
Permissions
Side effects
Description