Use the RESET command to restore the value of a runtime parameter to its default value. The RESET command is an alternate form for the SET VARIABLE TO DEFAULT command.
RESET <variable>
| Input | Description |
|---|---|
| <variable> | The name of a runtime parameter. |
| Output | Description |
|---|---|
| ERROR: "xy" Is not a valid option name. | The system did not recognize the variable that you specify. |
You must be the admin user or must have the privilege that corresponds to the runtime parameter that is being reset.
MYDB.SCH1(USER)=> RESET DateStyle;
MYDB.SCH1(USER)=> RESET geqo;