Answer / guest

An alternate index is an another way of accessing key
sequenced data record stored in a base cluster and path is
the linkage which connect alternate index to its base cluster.

Answer / xyz

An alternate index is an additional way of accessing the
base cluster.
A PATH is an entry in VSAM catalog that establishes a
logical link between an alternate index and the base
cluster.

Hi, I want to create alternate index on VSAM file.my file structure is ex: RoomID pic x(7) R000001 Floor pic a((6) First RoomNo pic x(2) FA1 Occupied(yes/no) pic a(3) Yes Occupied Batch pic x(10). Maths i want to create alternate index on floor,roomno fields.can i create alternate index on both the fields.and tell me how to create.

1 Answers  

---

What is the difference between lds and esds?

0 Answers  

---

Explain the meaning and syntax for the START command. ?

4 Answers   IBM,

---

explain how can you initialize a vsam file before any operation?

0 Answers   IBM,

---

what is the purpose of the verify function of idcams?

0 Answers   IBM,

---

What is the maximum no. of records that can be allowed in VSAM ?

2 Answers  

---

What is the difference between sequential files and ESDS files?

1 Answers   IBM,

---

What is the base cluster?

1 Answers   CGI,

---

is there any lock for vsam file so that no one can update the vsam file ?

2 Answers   HCL,

---

Suppose a generation of GDG gets created in a particular step of a proc. How would you refer the current generation in a subsequent step? What would be the disposition of this generation now ?

4 Answers   Patni,

---

Explain about the file objects in vsam?

0 Answers  

---

difference between vsam and database tables

0 Answers   IBM,

---