Originally posted by: SystemAdmin

Hi,

Im currently working on mercator 6.7. The issue im facing is,

The input file has 3 records, and we will have to manipulate it and generate an output file. We have done all the manipulations successfully. But, the output file is returning only one record. It is not looping the other records. We have used a searchup and lookup function to search a field in the input file and create an output file. Even in the search we find that the pointer is running through all the 3 records for the key field. But not looping again to search for the second record's key field.

I know this is a very small thing, but im just a beginner in Mercator and i literally dont have any help from my side. It would be really helpful, if anyone could help me clear this looping problem.

Many Thanks.
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

It sounds like it should be a simple map. Both input and output type tree should have a file defined with 0:s records. In the map executable level on the output card at the record level, you would call a functional map with an input record as the parameter. Use Functional Map Wizard to create your functional map, then put your field manipulations in the functional map field rules.

=f_Output( Input Record:Input File )
Hope this helps.
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: paul.brett

It sounds like you are the target audience for the IBM WebSphere Technical Exchange entitled "IBM WebSphere Transformation Extender for the Absolute Beginner"

For further details, see this thread.

The examples in this presentation will give you a headstart on your first mapping efforts.

Thank-you.
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: repanzer

Also, 6.7 ships with a tutorial included.

It is HIGHLY recommended you use it, and more then once. I've done it 3 times so far.

Not only does it give you a solid understanding of the fundamentals of mapping, it also serves as a reference tool for common, repeating situations that require a quick look at the documentation to recall how to complete correctly.
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: SystemAdmin

> We have used a searchup and lookup function to search a field in >the input file and create an output file.

then you have two places to look:

SearchUp will fail if the object is not sorted on that key.

Since you must be using a functional map, that map won't execute if one of its parameters is NONE (eg if either the SEARCHUP or LOOKUP returns NONE and that expression is one of the parameters to the functional map, the functional map does not execute.

You need to look at the output trace to see how many times you actually enter the functional map.

I have an EXIT function I use which can log each entry to a map; the EXIT itself always returns NONE so you can use EITHER() with it to get 'normal' mapping along with the log (or on-screen) display.

This EXIT function is part of library I offer for FREE, but only to those who ask for it.

Regards,
Michael Mattias
Tal Systems Inc
Racine WI
http://www.talsystems.com
mmattias@talsystems.com
Go to my website at http://www.talsystems.com
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange