IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Syncsort ? to use E15 & E35 Exit Routines together in a


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Swami-gs

New User


Joined: 27 Apr 2007
Posts: 20
Location: Chennai

PostPosted: Fri Dec 05, 2008 11:10 am
Reply with quote

Hello,

I have a requirement wherein I have to run two exit routines inside a single SYNCSORT step.

I have some omit conditions in my syncsort. I need to display the input controls and output controls of that step separately in the SYSOUT.

But technically If I use E35, then it does not include all the Input records.

If i use E15, it is not giving me exact output records.

Is there any way we can do this?

Thanks
Swami
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2481
Location: @my desk

PostPosted: Fri Dec 05, 2008 11:12 am
Reply with quote

Swami,

Syncsort questions are discussed in JCL forum and not in DFSORT forum. Can you explain with examples what exactly you are trying to do?
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Fri Dec 05, 2008 11:15 am
Reply with quote

Hello,

If you post some sample input, the desired output from that input, and the rules to be applied, someone may have a suggestion.

Why do you believe you need either or both exits?
Back to top
View user's profile Send private message
Swami-gs

New User


Joined: 27 Apr 2007
Posts: 20
Location: Chennai

PostPosted: Fri Dec 05, 2008 1:13 pm
Reply with quote

Hello,

Example:

Input Records have 100 records.

Using some OMIT condition in my Sort, I am removing 10 records.

So my output file will have 90 records.

But, basically I need to print Input controls and Output Controls as below in the SYSOUTS.

Input controls:
Record counts :100
Dollars amts: 550000


Output controls:
Record counts :90
Dollars amts: 400000

If I use E35, I can calculate only for 90 records.
If I use E15, I can calculate for all the 100 records.

Thanks
Swami
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Fri Dec 05, 2008 2:17 pm
Reply with quote

Hello,

If you are willing to write 2 cobol modules for the exits, i'd suggest simply writing the requirement entirely in cobol with an internal sort using the input procedure/outpur procedure approach.

This gives only 1 piece of "code" to maintain rather than 3.
Back to top
View user's profile Send private message
Swami-gs

New User


Joined: 27 Apr 2007
Posts: 20
Location: Chennai

PostPosted: Fri Dec 05, 2008 2:30 pm
Reply with quote

Thats a good idea. but the program which I am going to change is existing program used in various part of the system.

So, its a common program used across. Each and every place we have different Omit/Include condition been given.

Practically I cannot combine them.

It is fine with me, if I write two programs and execute it separately.

Thanks
Swami
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2481
Location: @my desk

PostPosted: Fri Dec 05, 2008 3:44 pm
Reply with quote

Swami,
Quote:
But, basically I need to print Input controls and Output Controls as below in the SYSOUT.

I m trying to understand this statement. Can you please explain this a bit more.
Back to top
View user's profile Send private message
Swami-gs

New User


Joined: 27 Apr 2007
Posts: 20
Location: Chennai

PostPosted: Fri Dec 05, 2008 4:13 pm
Reply with quote

Arun,

But, basically I need to print Input controls and Output Controls as below in the SYSOUTS.

I have one syncsort step.
ex: sort fields=copy
OMIT=(10,2,CH,C'23')
MODS E35=(Z1234BIG,100,MODLIB,N)

Input record counts: 100

Omitted records : 10

Output records : 90

So, with this condition, If i use E35, then it would pass the records after satisfying the sort conditions. in our case only 90 records will be passed. So over here inside the Z1234BIG, I will not be knowing the no. of input records coming in.

So, if i use E15, it passes the records first to Exit routine and then to Syncsort.

In order to print Input record counts and Output record counts. I need to run separate programs and that is possible thru E15 and E35.

I am not sure about the syntax of giving E15 and E35 in a single syncsort parm.

Thanks
Swami
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Fri Dec 05, 2008 8:49 pm
Reply with quote

Hello,

Quote:
I am not sure about the syntax of giving E15 and E35 in a single syncsort parm.
You can have both in the same execution however - they operate at different times (before/after) in the sort.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Use of Perform Thru Exit COBOL Programming 6
No new posts user exit in IBM Infosphere Optim DB2 8
No new posts ACS exit routine JCL & VSAM 0
No new posts Research regarding csqcapx exit CICS 0
Search our Forums:

Back to Top