|
View previous topic :: View next topic
|
| Author |
Message |
bhuspin
New User
Joined: 13 Aug 2008
Posts: 26
Location: chennai
|
|
|
|
Hi,
I am new to this forum.May i know the answer for my question posted below?
I am having a vsam ksds file with 10 records with keyfield of length 5.Supposing my records are not in sequence.That is;
For eg:
00001
00003
00002
00004
00005
How could i find the record or key which causes this abnormality?Waiting for your answers. |
|
| Back to top |
|
 |
jaspal
New User
Joined: 22 May 2007
Posts: 68
Location: mumbai
|
|
|
|
Hi Bhuspin
When we insert any record in VSAM it inserts in sorted order i.e
00001
00002
00003
00004......
for example: if you have two records:
00001
00003
and then you insert on more record i.e 00002 then it will take 2nd position ( for KSDS VSAM)
Now output will be :
00001
00002
00003
Thanks,
Jaspal |
|
| Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA
|
|
|
|
| Why worry about it? Sort the file then load into VSAM. End of issue. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello bhuspin and welcome to the forums,
| Quote: |
| Supposing my records are not in sequence |
If they are already in the vsam file, they are "in sequence".
If you need to load records into a vsam file, follow Robert's advice. |
|
| Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales
|
|
|
|
| bhuspin wrote: |
Hi,
I am new to this forum.May i know the answer for my question posted below?
I am having a vsam ksds file with 10 records with keyfield of length 5.Supposing my records are not in sequence.That is;
For eg:
00001
00003
00002
00004
00005
How could i find the record or key which causes this abnormality?Waiting for your answers. |
But your records would be in sequence if they were stored in a KSDS. |
|
| Back to top |
|
|
|
|
