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
 
How to find the dupicate members in two PDS files??

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CLIST & REXX
View previous topic :: :: View next topic  
Author Message
Amar.Roy

New User


Joined: 26 Jul 2010
Posts: 4
Location: Banglore

PostPosted: Mon Jan 09, 2012 8:13 pm    Post subject: How to find the dupicate members in two PDS files??
Reply with quote

I need to find out the duplicate members in 2 different PDS .. I need to do this by using REXX .. Please help me with the logic.
Back to top
View user's profile Send private message

Craq Giegerich

Senior Member


Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA

PostPosted: Mon Jan 09, 2012 8:24 pm    Post subject:
Reply with quote

Duplicate based on name or contents?
Back to top
View user's profile Send private message
Amar.Roy

New User


Joined: 26 Jul 2010
Posts: 4
Location: Banglore

PostPosted: Mon Jan 09, 2012 8:30 pm    Post subject:
Reply with quote

Duplicate based on member names only.
Back to top
View user's profile Send private message
superk

Moderator Team Head


Joined: 26 Apr 2004
Posts: 4650
Location: Raleigh, NC, USA

PostPosted: Mon Jan 09, 2012 9:11 pm    Post subject: Reply to: How to find the dupicate members in two PDS files?
Reply with quote

Create a member list of each PDS using whatever method you normally employ to create member lists. Then combine them, sort them, and select the entries that occur more that once. Your basic, simple duplicate check process.
Back to top
View user's profile Send private message
Amar.Roy

New User


Joined: 26 Jul 2010
Posts: 4
Location: Banglore

PostPosted: Mon Jan 09, 2012 9:41 pm    Post subject:
Reply with quote

Can you please provide me REXX code for that?
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10308
Location: italy

PostPosted: Mon Jan 09, 2012 9:45 pm    Post subject: Reply to: How to find the dupicate members in two PDS files?
Reply with quote

Quote:
Can you please provide me REXX code for that?

why should anybody do that...
this is a help forum, not a gimme the code one icon_evil.gif
Back to top
View user's profile Send private message
dick scherrer

Site Director


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

PostPosted: Mon Jan 09, 2012 9:57 pm    Post subject:
Reply with quote

Hello,

Quote:
I need to do this by using REXX ..
Why is this a "need" . . .?

If you know nothing about Rexx, suggest you use something you do know.

You can do what Superk suggested without Rexx. . .
Back to top
View user's profile Send private message
Michael Jakob

New User


Joined: 13 Mar 2011
Posts: 17
Location: Switzerland

PostPosted: Wed Jan 25, 2012 4:03 am    Post subject: Use ISPF functions
Reply with quote

Use these ISPF functions in this sequence:
LMINIT
LMOPEN
LMMLIST n times
LMCLOSE
LMFREE

The MOD function in the ISPF editor will help you to build this commands.
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Wed Jan 25, 2012 2:04 pm    Post subject:
Reply with quote

Michael
Just to be pedantic, that's not REXX icon_wink.gif

Amar.Roy

How to list a PDS using REXX / TSO
Code:
PDS1 = "'YOUR.PDS.NAME'"
X=OUTTRAP(LIST1.)
"LISTDS " PDS1 " MEM "
X=OUTTRAP(OFF)
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 -> CLIST & REXX All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Split 1 file into 10 output Files - S... Prasanth Kumar SYNCSORT 5 Sat Sep 16, 2017 12:02 am
No new posts Historical/statistical details for me... elixir1986 TSO/ISPF 13 Wed Aug 30, 2017 9:02 pm
No new posts Join records from 2 files with No Dup... Poha Eater DFSORT/ICETOOL 21 Sun Aug 27, 2017 10:35 pm
No new posts Match two files using multiple keys a... santoshks1987 SYNCSORT 11 Fri Aug 18, 2017 10:50 am
No new posts Command to find TMEMBER name for a TPIPE Siva NKK Kothamasu IMS DB/DC 0 Wed Aug 16, 2017 6:08 pm

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