If a password includes lowercase letters or special characters, it must be placed inside of quotation marks (for example, "Jones"), unless the MCP security option CaseSensitivePW is set. If a password is not enclosed in quotation marks and the CaseSensitivePW security option is not set, Query Processor capitalizes the password.
When the Query Processor server is initiated, it reads the MCP security option CaseSensitivePW and saves the value in memory. When the option CaseSensitivePW is set, the Query Processor server does not capitalize any entered passwords, and it is not necessary to enclose in quotation marks a password that contains lowercase letters or special characters. However, you can enclose the password in quotation marks.
If the MCP security option CaseSensitivePW is changed while the Query Processor server is active, the change is not reflected until after the server is stopped and restarted.
-
To stop the Query Processor server, wait until all server users have finished. Then, enter the following system command:
NA MCPSQL QUIT NOW
-
To restart the Query Processor server, enter the following system command:
NA MCPSQL +

