Supporting Reserved Words and Characters

When you perform MicroStrategy configuration tasks through the Linux operating system console, you must make sure reserved words and characters are not mistakenly included in your commands.

Linux operating system consoles use reserved words and characters to perform various actions. For example, the $ character may perform an action when included as part of a command executed through the operating system console. If this character is included in a command to configure, it can cause the command to fail.

For example, you use the following command to create a DSN to an Oracle database:

mstrconnectwiz ORCLW $MyOracleDSN 12.34.56.78 orcl 1521 -u:OracleUser -p:OracleUserPasword

Notice that the name of the DSN begins with the $ character. If this is a reserved character, the command fails to execute properly.

To avoid this problem, you can place single quotes ('') around any character strings that may include reserved words or characters. This prevents the operating system console from interpreting the characters as an operating system action, and instead includes them as part of the character string. For example, the same command as above to create a DSN can be rewritten as follows:

mstrconnectwiz ORCLW '$MyOracleDSN' 12.34.56.78 orcl 1521 -u:OracleUser -p:OracleUserPasword

This time, the name of the DSN $MyOracleDSN is enclosed by single quotes, which allows all of the characters to be interpreted as a string of characters.