Answer Posted / john

USING IDCAMS UTILITY
//SYSIN DD *
ALTER ABC.FILE -
NEWNAME(ABC.FILE.NEWNAME)

ALTER ABC.FILE.DATA -
NEWNAME(ABC.FILE.NEWNAME.DATA)

ALTER ABC.FILE.INDEX -
NEWNAME(ABC.FILE.NEWNAME.INDEX)
/*

how do you create an alternate index ?

1051

---

is it required that primary key values have to be unique? Do alternate key values have to be unique?

1034

---

What is a vsam dataset?

1006

---

what parameter in the define aix option is used to determine the maximum number of duplicate keys allowable ?

987

---

in a cobol select statement for a ksds can you tell me what are the 3 possibilities for access?

1188

---

what are the idcams commands that can be used for vsam and explain each of them.

971

---

to use the rewrite command, how should the vsam file be opened?

1297

---

If fspc(100 100) is specified does it mean that both the control interval and control area will be left empty because 100 % of both ci and ca are specified to be empty?

1085

---

Tell me how many alternate indexes you can have on a dataset?

1080

---

what is the use of the file status clause in the select statement in vsam?

1098

---

What is a ci split?

937

---

How do you calculate record size of an alternate cluster?

1115

---

What is the function of entry sequenced data set?

1066

---

Define gdg?

972

---

explain in brief how you can create a vsam file?

1113

---