James, Let us know what kind of performance difference you see. Are any of the 5 fields you update used in the key for FILE2LF? Steve Morrison Beacon Insurance 940-720-4672 -----Original Message----- From: James R. Newman, CDP [mailto:newman400@xxxxxxxxxxx] Sent: Friday, October 15, 2004 11:58 AM To: Midrange L Cc: vhamberg@xxxxxxxxxxx Subject: Setting parms in CL for PF - follow up Thanks for the great input on changing the CL for updating this big file. Here's the changes I've made and plan to run over the weekend. Would someone tell me if this looks right? FILE1 is the sequential input and FILE2 is the indexed output with 1 logical: CHGLF FILE(FILE2LF) MAINT(*DLY) OVRDBF FILE(FILE1) NBRRCDS(32000) SEQONLY(*YES) OVRDBF FILE(FILE2) FRCRATIO(32000) CALL PGM(BIGFREAKINUPDATE) CHGLF FILE(FILE2LF) MAINT(*IMMED) TIA. James R. Newman, CDP -- This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/midrange-l or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.
This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact