Yes. Because the alternate key would first locate the primary key, which in turn locates the actual record. Needs twice the number of I/Os.
what is the probability of a complete system distortion under high end low performing multiprocessor job?
What is the use of KSDS,LDS,ESDS,RRDS??what is VRRDS?? How are all these useful in realtime scenario??Plz helpme out...Its a recent question in IGATE..
OPEN INPUT StudentFile READ StudentFile AT END SET EndOfStudentFile TO TRUE END-READ PERFORM UNTIL EndOfStudentFile DISPLAY StudentId SPACE StudentName SPACE CourseCode SPACE YOBirth READ StudentFile AT END SET EndOfStudentFile TO TRUE END-READ END-PERFORM CLOSE StudentFile STOP RUN what will be output
write a program to read from a VSAM file , there will be a 5 records to create name. empno. resignation and address to update in a db2 table and call another program using dynamic call to find the matching fields in program 1 to update in db2 table. anybody pls send de program for dis ? thanks in advance...
In a KSDS file, key is missing for one record. How to insert the key for that particular record from back up file. Is there any sorting needed for the back up file before the key insertion?
what is the syntax of ams modal commands?
what how do you initialize a vsam file before any operation? A vsam with alternate index?
if you wish to use the rewrite command how must the vsam file be opened?
what is the purpose of the verify function of idcams?
how do you create an alternate index ?
what is meant by dirty read in vsam?
name a few common vsam status codes?
explain the differences between vsam and non-vsam files
how do you define an altindx ? How do you use altindxs in batch, cics programs?