Recent content by nelfel

Hi everyone, I figured out the problem. The problem is that the card in question had an adapter command of "-UPDATE ONLY" and the key fields defined in the database query (.mdq) file weren't matching up. Hence, when the keys didn't match, since no insert was allowed, the card didn't...

svrrp, Is the input file indexed (as in SQL Server)? If so, you can do this with a SQL statement in the Query of the .mdq file or a stored procedure. Let me know. nelfel

venkaiah, I forgot to mention that type tree designer isn't used that much, in the sense that type trees are now created using the Database Interface Designer. But... it is useful in changing an existing type tree. This is especially useful when you want to group certain records together by...

venkaiah, Your last request depends on what you are trying to use the Mercator software for. For instance, if you're using the Mercator product for EDI, then some of the steps I've included should be altered to better suit your usage. On the other hand, if you are trying to use this to...

venkaiah, I found the best way to start off programming with Mercator is to use there online library (provided with their software). Especially helpful is the Design Studio Introduction and the Design Studio Tutorial. You have a choice of printing them off and writing notes in them as you...

janhes, Yes. The trace file shows no errors. In fact, I even checked the SQL trace (through the ODBC feature) and it contains no errors.

Hi Everyone, I have a straight-forward map that runs (as a timed event) under the Event Server (version 6.5.2) and targets a table in a SQL 2000 server. Once updated, the map then proceeds to "flag" the transferred record in the source file, located on the AS/400. The map is set to...