Search results for query: *

I have a multi-threaded map (Max Concurrent Map Instance 0, mercator.ini MaxThreads=20) that uses a DBQUERY to insert a record into an Oracle database table. It is triggered by an MQ message arriving on a queue, and checks for the presence of a set of records in a source table. If the records...

In your map create the rule: =F_GetEachMessage(CLONE("DUMMY", 20000)) where 20000 is the maximum queue depth The Functional map contains the rule: =GET("MQS","-QN QUEUENAME -QTY 1") I have put a post on the www.eaiusergroup.com Mercator forum and attached a sample map in a zip file. This site...

I am using the Resource Registry to store runtime variables. At the moment the only way that I can tell that it is not configured correctly is the error message "Unknown error - maybe memory" at the end of the when I start the eventserver. This means that I have to go through all the...

If you are using a functional map, you can get duplicates if more that one of the input arguments has a range of more than 1:1. So, in the case of functional map F_Map(Headers, Details) If there are multiple instances of both the "Headers" and "Details" arguments you will...

Thanks for the responses. Paul Brett suggested this to me and I'm currently playing around with this mercator.ini setting, along with IdleMQS=30 HLimMQS=20 I will let you know how I get on.

I'm using Mercator 6.5.2 with IBM Websphere MQ on an AIX 4.3 box. I have an input card source command reads: -QN H.QUEUE.H.01 -EQN H.ERROR.H.01 "H.QUEUE.H.01" being the source queue, and "H.ERROR.H.01" the error queue. I have the Rollback option set, so that when a...

As it turns out it was both: my Sybase DBA is using it as an escape character, and my middleware was too and was putting too many in.Thanks for the reply.

I'm not sure I undersand completely, but if it's only one record you want you could use LOOKUP(). If you want more, use EXTRACT().

I am using Mercator to insert records into an Adaptive Server Anywhere Enterprise table and am losing exclamation marks. Specifically: when I try to insert !SPZ3 into a varchar column I get the following results: Input Sybase !SPZ3 SPZ3 '!SPZ3' 'SPZ3' '!SPZ3 'SPZ3' "!SPZ3&quot...

I have actually just found the answer to my question: in the SUBSTITUTE function you can have multiple pairs, e.g. SUBSTITUTE("boat", "b", "c", "a", "o", "c", "b") = "boot". First the "b" is changed to...

The documentation tells me that the SUBSTITUTE function has been extended to include multiple pairs. Anybody know how many multiple pairs I can have? I'm using Mercator Map Designer 6.5(211)