Recent content by Mags1972

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

If we use a PDS/E file for maps, we can specify the following in JCL: //MAPLIB DD DSN=MAPLIB. PDS And specify run maps as RUN ("MAPLIB(MEMBER)", .....), To call MAP "A" then "B" RUN ("MAPLIB(A)",....) RUN ("MAPLIB(B)",....) So a change in JCL will not be needed with addition of new maps.

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

Will it always be mapped across to 2 decimal places? or will it sometimes be 3 or even none??

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

its amazing what 10 minutes in the fresh air does!!! Sorted =Texttodate(Left(datetotext(CURRENTDATETIME( )),4) + datetotext(In1)) Thanks anyway.

am just simply dragging and dropping. The help option states that Mercator should insert the year automatically.. I think I'm going mad!!

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

Janhes Yes I agree setting the burst should control (not limit) the number of transactions. I have not yet used the VALID/FAIL around the main map, but do you think this would make a difference then?? Because the controlled (error)tests I am doing are on the inserts only (i.e output cards)...

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

Janhes. The input command/SQL works fine and the variables are passed and used successfully. It is only on the outbound that I have this trouble. How do I define an "(insert) -UPDATE OFF" command in my output without typing it all on the command line in the card??? If an .MDQ can be used...

Right, I have solved this, but am not sure if this is the ideal way or not. Like I say I am running the map on the MVS environment (under CICS), but I also test the map on the PC by connecting via ODBC. When I run the map through ODBC it recongises the DB2 error iimediately and finishes...