Procedure documentationChanging the Value of a Single Database Parameter Locate this document in the navigation structure

 

You can change the value of a single database parameter. The Database Manager implicitly opens and then closes the required parameter session when it executes the DBM command.

Prerequisites

You can find the prerequisites under Database Manager CLI, param_put

Procedure

Call Database Manager CLI, log on as operator OLEG with password MONDAY, connect to the database DEMODB, and change the parameter value DATE_TIME_FORMAT to EUR. You want the change to take effect immediately, but to only be valid for the current database session:

>dbmcli -u OLEG,MONDAY -d DEMODB param_put –running DATE_TIME_FORMAT EUR

OK

Result

The database parameter has been changed for the running database session. However, when you end the database session and/or Database Manager, this change is discarded and the original value is again valid.