Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

How to elliminate duplicates in FOCUS?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
pkmurali
Warnings : 1

Active User


Joined: 15 Dec 2005
Posts: 236

PostPosted: Mon Jan 05, 2009 12:24 pm    Post subject: How to elliminate duplicates in FOCUS?
Reply with quote

Hi,
I like to know is there any option to elliminate duplicates from a file using FOCUS. Please let me know.

Regards,
murali.
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 05, 2009 12:46 pm    Post subject:
Reply with quote

Hello,

When you read a record that has the same value of the previous record, skip that record?
Back to top
View user's profile Send private message
pkmurali
Warnings : 1

Active User


Joined: 15 Dec 2005
Posts: 236

PostPosted: Mon Jan 05, 2009 1:05 pm    Post subject:
Reply with quote

Dick,

Thanks for your reply.

My file has following structure

accountno acctname address-1 address-2
10000 xxxxx 01east crtt
10002 yyyyy 55west drtt
10000 xxxxx 01east crtt

TABLE FILE DAILY
PRINT ACCTNAME
BY ACCOUNTNO
END

Is there any builtin function like NODUPS in ICETOOL,SUMFIELDS=NONE in SORT utility etc. in FOCUS instead of comparing two values and elliminating?
Back to top
View user's profile Send private message
pkmurali
Warnings : 1

Active User


Joined: 15 Dec 2005
Posts: 236

PostPosted: Mon Jan 12, 2009 12:58 pm    Post subject:
Reply with quote

Hope I have given the clear picture of my requirement. I read a document for Focus http://documentation.informationbuilders.com/masterindex/html/html_s390_73/mf_create73/mf_create73.pdf where they have specified distinct clause to elliminate duplicates. since i don't have hands on experience on FOCUS,can anyone help me regarding this issue?

Regards,
Murali
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 -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Removing Duplicates based on certain ... chandracdac DFSORT/ICETOOL 8 Fri Dec 09, 2016 4:40 am
No new posts Updating the counters after eliminati... PANDU1 DFSORT/ICETOOL 12 Mon Nov 21, 2016 9:47 am
No new posts Relatated to FOCUS program Sumeendar All Other Mainframe Topics 1 Thu Mar 10, 2016 5:21 pm
No new posts FOCUS Database query lanand1985 All Other Mainframe Topics 4 Fri Jan 16, 2015 2:15 pm
No new posts SORT CARD to remove duplicates & ... mkk157 DFSORT/ICETOOL 17 Tue Jul 08, 2014 9:04 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us