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

Need logic to remove duplicates from same file


IBM Mainframe Forums -> COBOL Programming
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Fri Aug 21, 2009 9:34 pm
Reply with quote

Quote:
has been active since almost a year


I would rather say ...
has been inactive since almost a year, only 10 posts after all

and he should have known that if he wanted better replies he should have posted in a better way ...

these threads usually lower the benevolence factor of the TS/OP
Back to top
View user's profile Send private message
renjithravi1
Warnings : 2

New User


Joined: 31 May 2005
Posts: 16

PostPosted: Fri Aug 21, 2009 10:44 pm
Reply with quote

Hi All,

Thanks for your expertise and suggestions so far. Let me explain you the requirement before i leave.

I have a file coming from some system, not from mainframe, dont know or dont care how it is coming sorted and specifications says it will be sorted.

So the file is sorted on the key and the file content example is below,

AA12345ZINSSXY
AA12345ZINSSXY
AA12345ZINSZXY
BB34444STUPSPP

My key is position 1 to 2 and 13 to 14

if two records have the same key and the value of the first record in position 8 to 12 is 'ZINSSS' and second record the same position has record 'ZINSSZ' then both the records have to be omitted from writing to output file, rest all records should be written to output file.

Of course my system has SORT and related tools, but for the records omitted a report should be printed and should be sent to business in specific format, for this the client feels using a cobol program is better.
So i have to do using program and i got the logic and did the program and first report has been successfully delivered.

To the point that i did only 10 posts during the last one year, i have explanation for that, it is not necessary for me to look at this everytime i am stuck, i know enough and i do my 'HOMEWORK' well and i have enough knowledge in IT. But sometimes too many things are need to be done from your side and you have a lots of work to do, all have to be done in one day, you think the best possibilities to reduce your time...that is the mistake i did and posted in this site..sorry for that...

Now you have the requirement clear...if you think about the logic or dont think i dont care!

Thanks a lot for all your help so far!
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: Sat Aug 22, 2009 12:43 am
Reply with quote

Hello,

Quote:
that is the mistake i did and posted in this site
Posting was not a mistake. Taking personal affront to replies might be. . . Keep in mind that replies are not directed at the poster nearly as often as they are directed at the idea icon_neutral.gif

Unfortunately, your initial post was misunderstood by many and so most replies centered on a sort/utility solution. Had your most recent post been part of the topic start, this topic might have developed completely differently.

And yes, i agree with your client - i believe this is best served by code.

Quote:
if you think about the logic or dont think i dont care
Probably not the best way to proceed. . . Attitude is everything.
Quote:
Thanks a lot for all your help so far!
You're welcome - is this work complete now?
Back to top
View user's profile Send private message
renjithravi1
Warnings : 2

New User


Joined: 31 May 2005
Posts: 16

PostPosted: Sat Aug 22, 2009 4:27 pm
Reply with quote

HI

Yes this work is complete now!
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: Sat Aug 22, 2009 10:52 pm
Reply with quote

Good to hear it is working - thanks for letting us know icon_smile.gif

d
Back to top
View user's profile Send private message
mmwife

Super Moderator


Joined: 30 May 2003
Posts: 1592

PostPosted: Sun Aug 23, 2009 5:29 am
Reply with quote

Quote:
But sometimes too many things are need to be done from your side and you have a lots of work to do, all have to be done in one day, you think the best possibilities to reduce your time...

I love it!!

This guy feels overworked and decides to get some consulting help w/o paying for it and gets pissed when he gets no cooperation. icon_eek.gif icon_evil.gif icon_lol.gif
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 -> COBOL Programming Goto page 1, 2  Next

 


Similar Topics
Topic Forum Replies
No new posts Compare 2 files and retrive records f... DFSORT/ICETOOL 3
No new posts FTP VB File from Mainframe retaining ... JCL & VSAM 8
No new posts Extract the file name from another fi... DFSORT/ICETOOL 6
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
Search our Forums:

Back to Top