Catering for requirements of mixed case in JSM commands

Date:	3 July 2007
Product/Release:	LANSA Integrator
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.