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.

Can you include the audit log? Is there more that one input card in the map? Could it be that the map is supposed to delete the input but the user doesn't have write access?

I found this reply on IBM's developerWorks: Removing the entry <!DOCTYPE xs:schema PUBLIC "-//W3C//DTD XMLSCHEMA 200102//EN" "XMLSchema.dtd"> from the xml.xsd fixed the issue. Not sure, why that was causing issue. XML spy is saying, well formatted, but xml importer was throwing warning. Anyway...

Could this be your problem? "9 Target not available An incorrect file name or path for a target may be specified." That error could apply to an output file or a trace or log file.

In 8.1 the DTD is used to validate the input. One possible error is "-11 URL of the DTD against which the input instance is validated, is malformed". This is also true for XML schemas. The schema must be in the same location as the .mmc file. I have not worked in 8.2 yet.

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

The XML schema must be in the same directory as the executable map (.mmc file). Try validating the XML file against the schema outside of Mercator. One option is to use this website: http://tools.decisionsoft.com/schemaValidate/

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?"...

OK, I found that I made the stored procedure input parameter a text field instead of a date field. Then I passed the date as CCYYMMDD. Inside the parameter I used the SQL function TO_DATE(PARM1, 'RRRRMMDD') to convert the text to date. I didn't want to spend a huge amount of time figuring...

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

The problem was solved by replacing this code: TRIMLEFT( GETFILENAME( X12_Interchange ), GETDIRECTORY( X12_Interchange ) ) with this: SUBSTITUTE( GETFILENAME( X12_Interchange ), GETDIRECTORY( X12_Interchange ), "")

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

I assume this is X12? In that case use a type tree that comes with Mercator. Otherwise make the Group Subglass Unordered or set the range from (0-1) and put instances of the NTE segments where they might show up.

If the input is so off that the map does not recognize it as being an input type, then the map will fail with input invalid. You might want to label an item as an identifier For example, a header record always begins with "HDR". Let's make the first item a tag that can only contain the value...

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?

Try opening your input XML file via Internet Explorer. Does the file open or does Explorer detect an error.

Where are your databaser parameters? Are you using an MDQ file or specifying all the parms on the command line? This looks wrong: Input 1: Database: -T Show us the audit log instead of the launcher log.

Some systems run on Wintel and others run on unix, both sun and aix. We do not store souce files on the unix machines. Mercwiz, I would be interested in checking out the script, if you please. Thanks.

What is "ant"?

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.