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

    Calculating age

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

    Source not available

    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?
  3. kashush

    XML Validation error

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

    Mercator System not starting with eventserver.sh

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

    WTX8.2 XML/DTD - failures..

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

    Database Performance

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

    xml-type tree issue

    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/
  8. kashush

    XML to Oracle DB

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

    DBLookup to Stored Procedure Returns Confusing error

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

    DBLookup to Stored Procedure Returns Confusing error

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

    Map Blows Up

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

    Map Blows Up

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

    mapping a floating NTE segment

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

    Reporting Syntax Errors

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

    8.1.0.2 Type Tree that Describes Audit Log

    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?
  16. kashush

    XML Error

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

    Return Code: 12 - Source not available

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

    Automated deployment to production

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

    Automated deployment to production

    What is "ant"?
  20. kashush

    Automated deployment to production

    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.

Part and Inventory Search

Back
Top