Re: Building a logical file with 1 member over a physical file with many members

Interesting Mark. Here we have this job (that you might have seen) that
/* THIS IS THE GUTS OF THE PROGRAM */
/* THIS WILL TRANSFER THE CORRECT MEMBER OF GLTRAN AND ALSO */
/* ADD MEMBERS WITH THE SAME NAME TO GLTRAND AND GLLINED. */
/* THE NEXT STEP WILL BE TO ADD THE RECORDS NEEDED IN THE GLTRAND
*/
/* FILE. AND FINALLY ADD A RECORD TO THE SWBTHCTL FILE. */

/* 09/10/07 - Troy Modlin - for each DTALIB, Copy GLPOST(GLPOST)
to */
/* GLPOSTH(GLPOST), GLPOSTD to GLPOSTHD and GLLLINED to GLPOSTHLD.
*/


Troy reads a file of libraries and copies the records over via OVRDBF.
Personally I think it needs a rewrite. Right now it causes so many IOs
that Mimix was over 16 million transactions behind.
And it get's run every night!


Rob Berendt