You can add/delete parameters or change parameter values by manually editing the system parameter configuration file (cubrid.conf) in the $CUBRID/conf directory.
The following parameter syntax rules are applied when configuring parameters in the configuration file:
You can configure a parameter value by using SQL statements in the CSQL Interpreter or CUBRID Manager's Query Editor. Note that you cannot change every parameter. For updatable parameters, see cubrid.conf Configuration File and Default Parameters.
SET SYSTEM PARAMETERS 'parameter_name=value [{; name=value}...]'
parameter_name is the name of a client parameter whose value is editable. In this syntax, value is the value of the given parameter. You can change multiple parameter values by separating them with semicolons (;). You must take caution when you apply changes of parameter values.
The following example shows how to retrieve the result of an index scan in OID order and configure the number of queries to be stored in the history of the CSQL Interpreter to 70.
SET SYSTEM PARAMETERS 'index_scan_in_oid_order=1; csql_history_num=70'
You can configure system parameter values by using session commands (;SEt) in the CSQL Interpreter. Note that you cannot change every parameter. For updatable parameters, see cubrid.conf Configuration File and Default Parameters.
The following example shows how to configure the block_ddl_statement parameter to 1 so that execution of DDL statements is not allowed.
csql> ;se block_ddl_statement=1
=== Set Param Input ===
block_ddl_statement=1