Databases Reference
In-Depth Information
Set commands
In MaxL, you can also use the
set
commands. Some of the most widely used
set
commands are
retrieve_buffer_size,
data_cache_size,
index_cache_size,
currency_conversion minimum permission, compression,
lock_timeout,
implicit_commit_after n blocks,
and many more.
Some syntax and code samples are listed below for the
set
commands.
Syntax:
alter database <Db-name> set <SET-COMMAND>;
Code Sample:
alter database 'ESSCAR'.'ESSCAR' set data_cache_size 4096;
alter database 'ESSCAR'.'ESSCAR' set retrieve_buffer_size 15360;
alter database 'ESSCAR'.'ESSCAR' set currency_database
'ESSCAR'.'ESSCURR'; /
* This links a Standard database to its
currency database */
alter database 'ESSCAR'.'ESSCAR' set compression zlib;
alter database 'ESSCAR'.'ESSCAR' set note 'DATA IS UPATED on
02/08/2009';
Reset database
In MaxL, you can clear the data, LRO objects, and the entire outline in one single
statement. Use extreme caution while using this command as there is no undo
function to save you.
Syntax:
alter database <Db-Name> reset <all | data>;
Code Sample:
alter database 'ESSCAR'.'ESSCAR' reset all;
alter database 'ESSCAR'.'ESSCAR' reset data;
Rename database
Using the alter statement, you can also rename the database to a new name.
Syntax:
alter database <Db-name> rename to <new Db-name>;
