View previous topic :: View next topic |
Author |
Message |
shiva r Beginner
Joined: 09 May 2003 Posts: 7 Topics: 3
|
Posted: Fri May 09, 2003 10:22 am Post subject: Fileaid search |
|
|
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 |
|
 |
blitz Beginner

Joined: 24 Dec 2002 Posts: 28 Topics: 4
|
Posted: Sun May 11, 2003 1:14 am Post subject: |
|
|
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 |
|
 |
shiva r Beginner
Joined: 09 May 2003 Posts: 7 Topics: 3
|
Posted: Mon May 12, 2003 10:49 am Post subject: |
|
|
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 |
|
 |
Cogito-Ergo-Sum Advanced
Joined: 15 Dec 2002 Posts: 637 Topics: 43 Location: Bengaluru, INDIA
|
Posted: Mon May 12, 2003 10:59 pm Post subject: |
|
|
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 |
|
 |
Premkumar Moderator

Joined: 28 Nov 2002 Posts: 77 Topics: 7 Location: Chennai, India
|
Posted: Mon May 12, 2003 11:36 pm Post subject: |
|
|
Shiva,
The command LOCATE DUP or L DUP should take you to the next dup-record in the file. |
|
Back to top |
|
 |
shiva r Beginner
Joined: 09 May 2003 Posts: 7 Topics: 3
|
Posted: Tue May 13, 2003 8:14 am Post subject: |
|
|
Hi Prem,
Thanks.The command works fine to find the records having warning message as duplicate. |
|
Back to top |
|
 |
|
|