Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Can't view Data available in VSAM KSDS

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
ragin

New User


Joined: 20 Feb 2005
Posts: 16

PostPosted: Wed Mar 02, 2005 9:26 am    Post subject: Can't view Data available in VSAM KSDS
Reply with quote

Helo Frndz,
I have a doubt on KSDS.Well after creating a cluster and populating the data(using REPRO cmd) iam not able to view my entire data given in the PS file(thru Print CH in the cmd line near to data component).It displays only 2 dada set,as i have more than 2 records in PS file.So what does Key in KSDS relate to in defining the KSDS.I want to know waht is the role for key in KSDS.Also how to display the entire record in KSDS as it is in PS file.Plz send me the reply ASAP.
Back to top
View user's profile Send private message

brahmanandareddy

New User


Joined: 16 Dec 2004
Posts: 44
Location: Hyderabad

PostPosted: Wed Mar 02, 2005 2:47 pm    Post subject:
Reply with quote

When u declare EMPNO as a key field in a KSDS file all the records in that file will be arranged based on EMPNO. Using key field v can retrieve records fast instead of reading one by one. Key field creates an index.


To see the output from KSDS use PRINT command in SYSIN DD statement thru IDCAMS utility

(The above is to my knowledge, plz make a confirmation)

Thank You
Back to top
View user's profile Send private message
ragin

New User


Joined: 20 Feb 2005
Posts: 16

PostPosted: Fri Mar 04, 2005 7:23 am    Post subject: KSDS
Reply with quote

Hello Reddy,
Thanks for ur mail,well iam not clear with what u said?Well can u elobrate a bit.Suppose u have an emp id like this:
Emp ID Emp name Emp Dept
100 sss It
200 qqqq Cse

Now how will ur key be set as in KSDS.?Reply me soon.
Back to top
View user's profile Send private message
brahmanandareddy

New User


Joined: 16 Dec 2004
Posts: 44
Location: Hyderabad

PostPosted: Fri Mar 04, 2005 2:12 pm    Post subject:
Reply with quote

Hi,

EmpID EmpName EmpDept

100 SSS IT
200 QQQQ CSE


In the above file if u mention EmpID as key field all the records will b arramged based on that field. When u refer 200 (dont forget it is keyfield) it refers to all the data in that row. A key field uniquely identifies the row.

For ex, u have records 200,300,400,500 and u have deleted the record 300. The next time when u try to insert the record 300 using random/dynamic access it will b accommodated in between 200 and 400, which is not possible in sequential files.

Hope u got it

Thank U

Bramhananda Reddy. K.
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 -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Fail to change physical VSAM filename... jacobdng CICS 6 Fri Jan 20, 2017 12:36 pm
No new posts Storing huge volume of data, compare ... Pradeep K M All Other Mainframe Topics 3 Mon Jan 16, 2017 5:08 pm
No new posts how to recover an uncataloged VSAM da... archanamuthukrishnan All Other Mainframe Topics 3 Wed Jan 11, 2017 6:18 pm
No new posts Underlying DB2 VSAM LDS - SMF recording vasanthz All Other Mainframe Topics 6 Thu Jan 05, 2017 4:20 am
No new posts HALDB data refresh/copy from producti... vineetanand2007 IMS DB/DC 1 Mon Jan 02, 2017 11:16 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us