Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Need to delete two records with common key in EZ Program

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CA Products
View previous topic :: :: View next topic  
Author Message
anumalar

New User


Joined: 20 Oct 2006
Posts: 3
Location: singapore

PostPosted: Fri Oct 20, 2006 6:52 am    Post subject: Need to delete two records with common key in EZ Program
Reply with quote

i have one seq file with few records . Among these i need to delete two records with common key . After matching , how to remove both records from seq file . Pls advise. I need very simple step using ez program.
Back to top
View user's profile Send private message

IQofaGerbil

Active User


Joined: 05 May 2006
Posts: 183
Location: Scotland

PostPosted: Fri Oct 20, 2006 9:33 pm    Post subject: Re: Need to delete two records with common key in EZ Program
Reply with quote

Your request suggests that there is only one possible match of two records in you file , is this definitely the case?
or
could there be more than one pair of matching records?
or
more than two records with same key?

program logic differs depending on specification.

Would you consider using a SORT utility which could do this for you in one simple step?
Back to top
View user's profile Send private message
anumalar

New User


Joined: 20 Oct 2006
Posts: 3
Location: singapore

PostPosted: Mon Oct 23, 2006 3:44 pm    Post subject: Re: Need to delete two records with common key in EZ Program
Reply with quote

Reply :

Your request suggests that there is only one possible match of two records in you file , is this definitely the case?

reply : one possible match only

or
could there be more than one pair of matching records?
more than one pair of matching records

or
more than two records with same key?

reply : two records with same key . But only one pair .
Every pair have diff common keys .


program logic differs depending on specification.
Back to top
View user's profile Send private message
IQofaGerbil

Active User


Joined: 05 May 2006
Posts: 183
Location: Scotland

PostPosted: Tue Oct 24, 2006 4:42 pm    Post subject: Re: Need to delete two records with common key in EZ Program
Reply with quote

still confused!
Give inputs and expected outputs.
Back to top
View user's profile Send private message
anumalar

New User


Joined: 20 Oct 2006
Posts: 3
Location: singapore

PostPosted: Thu Oct 26, 2006 7:37 pm    Post subject: Re: Need to delete two records with common key in EZ Program
Reply with quote

Thks for yr reply .

I got the answer from other forum replies .

using dfsort


//S1 EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//IN DD DSN=... input file
//OUT DD DSN=... output file
//TOOLIN DD *
SELECT FROM(IN) TO(OUT) ON(1,3,CH) NODUPS
/*

It will remove duplicate records from seq file .
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CA Products All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts ISSUE IN copying Sequential file reco... thesumitk JCL & VSAM 2 Wed Dec 13, 2017 3:07 pm
No new posts The same REXX program doesnt work for... jackzhang75 CLIST & REXX 5 Wed Dec 06, 2017 2:51 am
No new posts Merging 2 records at multiple rows wi... Bijesh DFSORT/ICETOOL 2 Wed Dec 06, 2017 1:50 am
No new posts Calling IKJEFT01 program from Rexx upendrasri CLIST & REXX 8 Wed Nov 15, 2017 4:27 pm
No new posts Increment number for every group of r... srajendran2 DFSORT/ICETOOL 7 Thu Nov 09, 2017 10:31 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us