Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
To find the abnormal key in vsam ksds file

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
bhuspin

New User


Joined: 13 Aug 2008
Posts: 26
Location: chennai

PostPosted: Mon Sep 15, 2008 12:32 pm    Post subject: To find the abnormal key in vsam ksds file
Reply with quote

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
View user's profile Send private message

jaspal

New User


Joined: 22 May 2007
Posts: 68
Location: mumbai

PostPosted: Mon Sep 15, 2008 12:36 pm    Post subject: Re: To find the abnormal key in vsam ksds file
Reply with quote

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
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8201
Location: Dubuque, Iowa, USA

PostPosted: Mon Sep 15, 2008 5:14 pm    Post subject:
Reply with quote

Why worry about it? Sort the file then load into VSAM. End of issue.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Sep 15, 2008 9:44 pm    Post subject:
Reply with quote

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
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8620
Location: Back in jolly old England

PostPosted: Tue Sep 16, 2008 11:36 am    Post subject: Re: To find the abnormal key in vsam ksds file
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts ISSUE IN copying Sequential file reco... thesumitk JCL & VSAM 2 Wed Dec 13, 2017 3:07 pm
No new posts File Tailoring -- Temporary dataset i... samzee71 CLIST & REXX 3 Fri Dec 01, 2017 3:12 am
No new posts Rexx - File tailoring samzee71 CLIST & REXX 10 Thu Nov 30, 2017 10:47 pm
No new posts Compare VSAM files using DFSORT pshongal DFSORT/ICETOOL 5 Thu Nov 23, 2017 10:24 am
No new posts Moving a PS file as body of a mail! Vignesh Sid JCL & VSAM 4 Tue Nov 21, 2017 9:23 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us