Catering for requirements of mixed case in JSM commands
|Date:||3 July 2007|
|Abstract:||Username and Password parameters specified are automatically converted to Upper Case|
|Submitted By:||LANSA Technical Support|
When building JSM commands, there may be instances where it is a requirement (from the Server) to build the command (a command is built up of arguments and keywords) in mixed case, i.e. not default to uppercase.
For example, there are applications that require to have the Username and Password passed to be in mixed case format. That is, the validation is Case Sensitive.
If a JSM Command is built as such:
CHANGE FIELD(#JSMCMD) TO('CONNECT DRIVER(DB2) DATABASE(JSMJDBC) USER(UserName) PASSWORD(Password)')
Then it will default to uppercase.
Therefore in order for the command to not convert the JSM command to uppercase, then it is suggested that the command is enclosed with triple single quote as per
CHANGE FIELD(#JSMCMD) TO('''CONNECT DRIVER(DB2) DATABASE(JSMJDBC) USER(UserName) PASSWORD(Password)''')
This ensures that the command is executed as typed without conversion.