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?