Changing the Value of a Single Database Parameter 

Use

You change the value of a single database parameter. The parameter session required for this is implicitly opened by the Database Manager during execution of the database statement and then closed.

To read the prerequisites, see Database Manager CLI, param_put

Procedure

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

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

OK