Can't view Data available in VSAM KSDS

ragin · New User Joined: 20 Feb 2005 Posts: 16

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.

brahmanandareddy · New User Joined: 16 Dec 2004 Posts: 44 Location: Hyderabad

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

ragin · New User Joined: 20 Feb 2005 Posts: 16

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.

brahmanandareddy · New User Joined: 16 Dec 2004 Posts: 44 Location: Hyderabad

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.