MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Fileaid search

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Utilities
View previous topic :: View next topic  
Author Message
shiva r
Beginner


Joined: 09 May 2003
Posts: 7
Topics: 3

PostPosted: Fri May 09, 2003 10:22 am    Post subject: Fileaid search Reply with quote

Hi,

I have opened a VSAM file in file-aid in edit mode and inserted some data
.This gave rise to SEQ-ERR and once when it was cleared by sorting the key i was getting DUPL error as data with similar key existed. The ==DUP> error is shown on the place where we enter line commands. I would like to know whether there is any way to search for the records(or any command) having the error DUP> message .

Thanks
Shiva
Back to top
View user's profile Send private message
blitz
Beginner


Joined: 24 Dec 2002
Posts: 28
Topics: 4

PostPosted: Sun May 11, 2003 1:14 am    Post subject: Reply with quote

the 'dup' error is due to duplicate keys. From your post I think that in order to insert new keys, you are trying to repeat the existing rows and then trying to modifying the same.

I would suggest that if you are in the edit mode, then insert new lines and then type in the key yourself. That way you will avoid the above error.
Back to top
View user's profile Send private message
shiva r
Beginner


Joined: 09 May 2003
Posts: 7
Topics: 3

PostPosted: Mon May 12, 2003 10:49 am    Post subject: Reply with quote

Hi Blitz,
Let me be more clear.I need to find out those error records so that i can eliminate them.They are distributed at different places in a large file.Is there any easy way, please let me know.

Thanks
Shiva
Back to top
View user's profile Send private message
Cogito-Ergo-Sum
Advanced


Joined: 15 Dec 2002
Posts: 637
Topics: 43
Location: Bengaluru, INDIA

PostPosted: Mon May 12, 2003 10:59 pm    Post subject: Reply with quote

Shiva,
I do not understand, when you say that, the duplicates are distributed at different places in a large file. When you get a DUP err message, then it means you have entered a record with a key that is in duplicate. Now, such a situation can never happen while loading thru" an utility or a COBOL program. This means, you are getting the message when you are manually trying to enter records. So, how is that you want to know where are the duplicates, when you get the message the moment you enter duplicate records? Kindly elaborate.
_________________
ALL opinions are welcome.

Debugging tip:
When you have eliminated all which is impossible, then whatever remains, however improbable, must be the truth.
-- Sherlock Holmes.
Back to top
View user's profile Send private message
Premkumar
Moderator


Joined: 28 Nov 2002
Posts: 77
Topics: 7
Location: Chennai, India

PostPosted: Mon May 12, 2003 11:36 pm    Post subject: Reply with quote

Shiva,

The command LOCATE DUP or L DUP should take you to the next dup-record in the file.
Back to top
View user's profile Send private message Send e-mail
shiva r
Beginner


Joined: 09 May 2003
Posts: 7
Topics: 3

PostPosted: Tue May 13, 2003 8:14 am    Post subject: Reply with quote

Hi Prem,

Thanks.The command works fine to find the records having warning message as duplicate.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Utilities All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group