How to elliminate duplicates in FOCUS?

pkmurali · Active User Joined: 15 Dec 2005 Posts: 271

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

Regards,
murali.

dick scherrer · Posted: Mon Jan 05, 2009 12:46 pm

Hello,

When you read a record that has the same value of the previous record, skip that record?

pkmurali · Active User Joined: 15 Dec 2005 Posts: 271

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?

pkmurali · Active User Joined: 15 Dec 2005 Posts: 271

Hope I have given the clear picture of my requirement. I read a document for Focus 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