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.
1976What are the optional parameters to the input dataset While loading the empty cluster with the data records?
IBM,
1 5326
What are the different types of table spaces?
Can you explain enq and deq used in cics?
What is the role of data manager in the db2 database?
We have an output dataset in job with disp parameter as shr.
How can a like table be created?
What are fillers?
Name the sections present in data division.
I have a program with an Array of 5000 occurences which is being passed from 5 sub levels to the front end screen. Thess 5 programs using each 5*2 = 10 different arrays with size as 5000. This is causing the transaction to utilize more storage consupmtion. I am looking to reduce the storage consumption. As part of that initially i thought Dynamic array may solve my problem. After viewing the comments given i see its same as normal array. IS there any other way we can resolve this issue?
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?
How did PL/I originate?
how can you detect and handle a record lock situation?
WHAT IS THE PROCESS OF "CLAIM PROCESSING SYSTEM"
What is the use of symbol // in jcl?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
how can u check no of records in a file?