Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. umbogo

    Oracle Primary Key Violations

    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...
  2. umbogo

    How to get all Messages From MQ Queue on Time Event !

    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...
  3. umbogo

    Debugging the resource registry

    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...
  4. umbogo

    Simple Way Of Mapping

    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...
  5. umbogo

    Error queue operation could not complete

    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.
  6. umbogo

    Error queue operation could not complete

    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...
  7. umbogo

    Exclamation Marks

    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.
  8. umbogo

    Simple Way Of Mapping

    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().
  9. umbogo

    Exclamation Marks

    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...
  10. umbogo

    SUBSTITUTE Function

    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...
  11. umbogo

    SUBSTITUTE Function

    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)

Part and Inventory Search

Back
Top