MVSFORUMS.com

bprasanna · Posted: Fri Jun 25, 2004 2:29 pm Post subject: E35 Routines?

Hi,
I need a little bit of information about the user exit routines?Where can I get the info regrding these routines?Are these routines work for SYNC SORT ?

I need this info for the below purpose.

Once I use the sort to get the data from the files,I need to pass one of the field to a table and I need to get the corresponding value of that field?

Ex:

After sorting of the data as per my requirement I will get a flat file like below.

emp lname fname citycode
123 ABC KGH 12
124 ABQ KGH 13
125 ABW KGH 14
126 ABZ KGH 15

We have a table where the city name has been mentioned along with the above city code.
I have a cobol program which reads the city code and returns the
city name.
Can I use that program to return the city name with SORT as exit routine?

Once the sort step completes I need to get the o/p as below.

emp lname fname city
123 ABC KGH Newyork
124 ABC KGH Chicago
125 ABC KGH Dallas
126 ABC KGH Texas

Thanks in advance..
Bprasanna

kolusu · Posted: Fri Jun 25, 2004 2:44 pm Post subject:

Bprasanna,

you can code an exit to populate the city name in sort. Syncsort manuals are not available online. If you have a manual then you can check it out which has some examples.

But IMHO I think this can be solved withhout coding an exit. If your city code , city name combination is relatively small then we can do it in sort itself

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

bprasanna · Posted: Fri Jun 25, 2004 3:14 pm Post subject:

Hi Kolusu,
Thank you very much for your quick reply.We are having the sync sort ,,but I didn't find much info in QW of syncsort(In MF) .I am not sure of getting the Examples of sync sort.Actually I tried with CHANGE option and it worked fine.But the list is so big,I can't code each and every state code along with state name.

Do u have any simple example of these routines,,so that I can give a try ?

And one more thing ,are these routines differ for DFSORT and SYNCSORT?

coolman · Posted: Fri Jun 25, 2004 3:32 pm Post subject:

bprasanna,

Do you have easytrieve at your shop?

Cheers,
Coolman
________
Ford GT70

superk · Advanced Joined: 19 Dec 2002 Posts: 684 Topics: 5

Even though we don't have SYNCSORT, my site's MVS/Quickref 6.0 has quite a bit of information about SYNCSORT. I would presume that, regardless of the product, a sort exit is a rather generic routine that would work for either product.

bprasanna · Posted: Wed Jun 30, 2004 12:32 pm Post subject:

Hi All,
Can anybody provide me small piece of code for this problem and the mods statement ?

haatvedt · Posted: Thu Jul 01, 2004 10:06 pm Post subject:

Hi Bprasanna,

I think that the linkage / calling conventions for SyncSort and DFSORT are the same. I have take E15 or E35 sort exits and moved them between the sort products without incident.

That being said, there are plenty of examples in the IBM sort manuals which are available online. Mr. Green

chuck haatvedt
_________________
Chuck Haatvedt

email --> clastnameatcharterdotnet

(replace lastname, at, dot with appropriate
characters)