Add a Second File Description to your Application Program

Add a Second File Description to your Application Program

The second way to minimize space-extension overhead applies to application programs that add records to an existing database file. First, add a second file description for the file to your processing program, and open that file description for output only. Then, prior to calling the program, issue an OVRDBF (Override Database) CL command specifying SEQONLY (*YES nnnn), where nnnn is the output blocking factor (i.e., 128 K divided by the record length equals nnnn). Be aggressive with the blocking factor and get it as close to 128 K as possible without exceeding it.