Search results for query: *

Hi, I am writing a map which transforms a file as well as reports any rejections if present. For that i have done the settings so that map does not fail when it gets any syntax failures. Rather it writes it in the Reject output card and continues with the next record. I am using IFERROR() to...

We are migrating from version 6.7 to version 8.1 For certain maps, if the FIND option is Turned OFF for a variable separator, 8.1 fails where as 6.7 allows the map to pass for the same input data. Is anyone aware of any more potential issues while migrating from 6.7 to 8.1?

I am calling one map from another map using Run command. While running it on MVS Batch, if i dont provide a DDName for the called map in JCL, i get an error saying no DDname found for the called map. I want to dynamically decide which map is to be called and thats why i wont know the name of...

We are running WSTX on the mainframe, and will be receiving and processing large payment files. We simply need to just map the whole of these files and pass them into a COBOL program. The map and the COBOL program will be sitting on the same "box" Would anyone recommended using Batch MQ as...

Hi Does anyone out there use this functionallity? If so how do you find the performance? I am currently setting this up and find that it isnt as quick as I thought it would be, and the Temp files required for simple mapping are having to be defined and massive massive files!! Any Tips or...

This hopefully should be a very simple one, but my mind has just gone blank!!! I have 2 dates (input is DDMM , output is CCYY-MM-DD), just mapping one to the other produces a "one or more outputs in invalid" - due to the ##'s being inserted. What am I doing wrong? Thanks

This is probably a very simple question, but I want to check and act on certain SQLCODES obtained after a DBLOOKUP statement. i.e DBLOOKUP(blah blah blah)....IF SQLCODE = +100 , "record isnt there" , IF SQLCODE = -803 , "Record already exists" etc etc etc... Any Ideas??? Thanks in advance

Hopefully this should be an easy one. I have a very simple map that RUNs aother map. What I need is the first map to put out some descriptive text upon failure. i.e (if called map fails "it worked" , "it failed"). what do I need to do with the below rule to achieve this?? =RUN(MAP_NAME...

In addition to my earlier problem I am finding it difficult in telling the map which DB2 system to work on. In the input it is quite straight forward whereas I pass the DB2 details as paramters and have defined those in my query on the MDQ file.. ie select * from #db2system#.table_name The...

Hope someone can help me with this. I am running a very simple map on the MVS(CICS) environment and this map is being called by another. the map simply selects records from the DB2 database and inserts them on another. however, If Mercator encounters an SQL error (i.e duplicate insert or...

This is probably a very simple one (so apolgies in advance) but I am trying to call a Functional map with the results from the WORD function. =F_MAP(WORD(In1, "/", 1)) The functional map wizard does not like this. I know I can get round this by using another output card to call a map with the...

Probably an easy one! but its got me stuck!!! I have data coming in and would like to sort it, but only by using the FIRST 3 chars of the input. i.e Input ===== D01:zzzzzzzz D05:dddddddd D02:eeeeeeee D01:aaaaaaaa I would like the output to read D01:zzzzzzzz D01:aaaaaaaa D02:eeeeeeee...

Is there anyone else out there who uses Mercator under a CICs environment? If so, how do you find the performance? and do you find it easy to maintain the map source on the Mainframe?

Has anyone written a map to highlight bad data within either a SWIFT or EDI message? Our users would like to know (without looking through a trace) what is wrong with their data. And I am currently struggling Thanks