Answer / sivakumar devaram

253.but not more than 5 recommended because of overheada in
storing and maintaining alternate indexes.

Answer / guest

255 - but you must be a nut to have so many ALT Indexes on a
dataset!

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 do you mean by a vsam split?

0 Answers   IBM,

---

what how do you initialize a vsam file before any operation? A vsam with alternate index?

0 Answers   IBM,

---

Explain the purpose of the file status clause in the select statement?

0 Answers  

---

explain in brief how you can create a vsam file?

0 Answers   IBM,

---

Under IDCAMS , multiple functions can be executed, each of which returns a cond code. What will be the condition code returned to the operating system ?

1 Answers   IBM,

---

how to see the last records in vsam dataset??

1 Answers  

---

I have three fields in a Variable VSAM file X(2) Y(10) occurs X times Z(02) Say for the first record X=2 then the length of the file is 2+(10*3)+2=34 second record, x=4 then 4+(10*4)+2=46 If any time if the field x is updated then the total length changes. Is it feasible? Is it

2 Answers  

---

What is the difference between CI( Control Interval)and CA (Control Area)?

3 Answers   Infosys, TCS,

---

Using alternate indexes in batch program?

0 Answers  

---

What is control area?

0 Answers  

---

How do you define a KSDS ?

1 Answers   IBM,

---