Search results for query: *

How would you calculate an age. I want to decide logic based on whether someone is 65 or older. This is not working. IF(DATETONUMBER( CURRENTDATE( ) ) - DATETONUMBER( TEXTTODATE( birthdate) ) >= DATETONUMBER( TEXTTODATE( "19300101" ) ), "Y", "N" ) ) ))) Please advise. Thanks.

I am working on a map that reads from over 30 different DB2 database tables that have large volume of records. An existing map (made by someone else) uses separate DBLOOKUP calls to read from each table. These are done in a series of functional maps. The map has had performance issues and is...

A brief google search revealed that Oracle has tools to convert XML files directly into the Oracle Database. Does this make WTX/Mercator obsolete? Would Oracle do this faster than WTX/Mercator? Has anyone tried this? This thread shows "How can I load XML content into the DB?"...

The map uses dblookup to call a stored procedure. The .dbl file shows the correct number of parameters in the correct format but it also contains, "Returned status: (-1091) An_output_date_was_of_an_incorrect_format" The procedure works. It runs from Toad correctly. It has one output...

I have a simple map that puts a file into a subdirectory depending on a value of an item. The map blows up every time I run it. I have renamed the map, created a new map, deleted the map and renamed the .bak file, added an extra output card, changed the output from sink to file, etc. and the...

Does WTX 8.1.0.2 provide a type tree that describes the audit logs? Does WTX 8.1.0.2 provide an XML schema that describes the audit logs?

Has anyone created a way to automatically deploy maps, systems, resource registry files to a production environment? I am not talking about opening a MSD file and deploying. I am talking about runing a script or using a tool that will do the compile and deploy from a list of systems/maps.

The map runs in 7.5(119). It calls a stored procedure. The system gets an OPEN AUDIT ERROR and the launcher is bounced. The DB process is still locking the database so when the event server comes up the new instance of the map runs untill a DBA kills the lingering DB process. Is there a way...

Has anyone seen a DSTX map that can unzip a compressed file that contains multiples files with unique date time stamps. In this case one would not know the names of the files.

I have a system in Mercator 6.5. It validates a file that may contain characters á, é, í, ó, ú and other european characters. The individual fields that are text have UTF-8. The delimiter between fields is literally a comma, western-native. In one field the map cannot handle the ó and misses...

My map truncates 3.40 to 3.4. I don't want this to happen. If the number comes in as 5.1 then I don't want to add an additional 0 at the end to make it 5.10. The data should look exactly how it initialy came. I am using DSTX 7.5(119). The type trees are created from an initial type tree...

I am trying to create a type tree that describes a very difficult format. Has anyone dealt with this format before? The format uses comma field delimiters and forward slash segment terminations. There is a text field that may contain commas and forward slashes. No release character has been...