Data Transformation Engine What's New Reference Guide
Chapter 7 – Version 6.0  Operational Monitoring & Management 
What's New Reference Guide 
38 
SUBSTITUTE ("ABBA" , "B", "A", "A", "B") 
First all occurrences “B” are replaced with “A” in “ABBA” resulting in “AAAA”; 
then all occurrences of “
A” are replaced with “B” in “AAAA” resulting in 
“
BBBB”. “BBBB” is the final result.  
WORD Extended to Search Backwards 
The third argument for the WORD function can now be a negative number. This 
extends the 
WORD function to be able to search word lists from the back end 
forward. 
To find the file name in 
F = C:\mercator\NightFire\dsl.mtt 
Instead of using the following expression: 
REVERSEBYTE( WORD (REVERSEBYTE(F), “\”, 1) ) 
The new simplified rule to use would be: 
WORD(F, “\”, -1) 
Operational Monitoring & Management 
Extensive new features have been added in Version 6.0 to provide real-time 
visibility for Mercator systems. Management services for execution time now 
provide: 
♦  A new Management Console that provides detailed monitoring information as 
well as dynamic configuration features for Mercator systems under control of 
the Event Server. 
♦  The ability through SNMP to provide the same detailed monitoring information 
to third party management software. 
♦  A new Resource Registry that provides a resource abstraction that can be 
resolved at run-time for faster and more maintainable deployment strategies. 
♦  Connectivity to external transaction managers for map resources that allow 
these resources to participate in a global transaction. 
Management Console 
The Management Console, a new cross-platform application, provides in-depth 
real-time and historical monitoring information about system performance, errors, 










