Parameter values for the ImbESQLManager component

mqsichangeproperties broker_name -e integrationServer_name -o ImbESQLManager -n propertyName -v propertyValue

castWithAccurateZoneOffsets

Set ESQL to use the time zones that are stored with Time, Timestamp, and Date data types when you cast to and from GMTTime and GMTTimestamp data types.

• Value type - boolean
• Initial value - no

Note: When a time value is stored as a String data type and then cast to a GMTTIMESTAMP, the time zone offset is applied and the time is converted to GMT by subtracting the local time zone offset. However, when a time value is stored with a TimeStamp data type and then cast to a GMTTIMESTAMP, the time zone offset is not applied before the time is converted to GMT by subtracting the local time zone offset. You can control whether time zone offsets are processed for an integration server by using the mqsichangeproperties command with the castWithAccurateZoneOffsets parameter. For example, the following command sets the time zone offsets to be processed:

mqsichangeproperties broker_name -e integrationServer_name -o ImbESQLManager -n castWithAccurateZoneOffsets -v yes

alwaysCastToLocal

Set ESQL to convert the specified time into the local time zone of the integration node when a String is cast to a Time or TimeStamp with a Format.

• Value type - boolean
• Initial value - yes

Note: When you cast a String to a Time or TimeStamp with a Format, you can prevent the time from being converted to the local time zone of the integration server by running the following command:

mqsichangeproperties broker_name -e integrationServer_name -o ImbESQLManager -n alwaysCastToLocal -v no

useICUStringManipulation

Set ESQL to provide full support for UTF-16 surrogate pairs.

• Value type - boolean
• Initial value - no

Note: ESQL supports a mode where ICU string functions are used to provide full support for UTF-16 surrogate pairs. The mode is disabled by default, but can be enabled by running the following command:

mqsichangeproperties broker_name -e integrationServer_name -o ImbESQLManager -n useICUStringManipulation -v yes

allowPropagateWithSharedLockHeld

Set ESQL to propagate the message even if a lock is held on a shared variable.

• Value type - boolean
• Initial value - no

Note: The option is disabled by default, but can be enabled by running the following command:

mqsichangeproperties broker_name -e integrationServer_name -o ImbESQLManager -n allowPropagateWithSharedLockHeld -v yes