|
It seems from our experience that 1. we never use a pf directly - always through a logical 2. we always specify the individual fields we want to use in the logical Chgpf only seems to affect the physicals and not the logicals We use chgpf a log and never seem to have any problems. Some times it seems that we have a lot of logicals. Since many of them have the same index, I assume that under the covers the system has almost no additional overhead because only 1 index is being maintained. Is there something I don't understand? Jim Horn PS Hi to Scott Klemment. Was great talking to you at the COMMON last night party. -----Original Message----- From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of rpg400-l-request@xxxxxxxxxxxx Sent: Tuesday, April 04, 2006 2:04 PM To: rpg400-l@xxxxxxxxxxxx Subject: RPG400-L Digest, Vol 5, Issue 418 Send RPG400-L mailing list submissions to rpg400-l@xxxxxxxxxxxx To subscribe or unsubscribe via the World Wide Web, visit http://lists.midrange.com/mailman/listinfo/rpg400-l or, via email, send a message with subject or body 'help' to rpg400-l-request@xxxxxxxxxxxx You can reach the person managing the list at rpg400-l-owner@xxxxxxxxxxxx When replying, please edit your Subject line so it is more specific than "Re: Contents of RPG400-L digest..." *** NOTE: When replying to this digest message, PLEASE remove all text unrelated to your reply and change the subject line so it is meaningful. Today's Topics: 1. RE: Changing a PF (Michael_Schutte@xxxxxxxxxxxx) 2. RE: Changing a PF (Don Wereschuk) 3. RE: Changing a PF (Scott Klement) 4. RE: Changing a PF (Michael_Schutte@xxxxxxxxxxxx) 5. RE: Changing a PF (Phil Kestenbaum) 6. RE: Rename a field (Alan Shore) ---------------------------------------------------------------------- message: 1 date: Tue, 4 Apr 2006 14:55:41 -0400 from: Michael_Schutte@xxxxxxxxxxxx subject: RE: Changing a PF Well obviously, you have to add the field to the source. Then you execute the command CHGPF, specify that new source to change the file. Basically the command, moves the data to a TEMP file, then recompiles the source file (as you would for creating a new file), then maps the data back from the temp file to the new updated file. It just does all the steps for you. Michael Schutte Work 614-492-7419 email michael_schutte@xxxxxxxxxxxx "Phil Kestenbaum" <pkestenbaum@sdit ech.com> To Sent by: "RPG programming on the AS400 / rpg400-l-bounces+ iSeries" <rpg400-l@xxxxxxxxxxxx> michael_schutte=b cc obevans.com@midra nge.com Subject RE: Changing a PF 04/04/2006 02:51 PM Please respond to RPG programming on the AS400 / iSeries <rpg400-l@midrang e.com> Yes but I don't see how you can add a field to the file using CHGPF. -----Original Message----- From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of RPower@xxxxxxxxxx Sent: Tuesday, April 04, 2006 2:40 PM To: RPG programming on the AS400 / iSeries Subject: RE: Changing a PF If you have an existing Physical File, and you change the source for the physical file, you can do a CHGPF (Change Physical File) command so that you can change the attributes of the PF OBJECT to match the source. You've never encountered that command before? It saves you time because you don't have to recompile the PF and copy the data back into it. Ron Power Programmer Information Services City Of St. John's, NL P.O. Box 908 St. John's, NL A1C 5M2 709-576-8132 rpower@xxxxxxxxxx http://www.stjohns.ca/ ________________________________________________________________________ ___ Success is going from failure to failure without a loss of enthusiasm. - Sir Winston Churchill "Phil Kestenbaum" <pkestenbaum@xxxxxxxxxxx> Sent by: rpg400-l-bounces@xxxxxxxxxxxx 2006/04/04 04:07 PM Please respond to RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx> To "RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx> cc Subject RE: Changing a PF Not sure of what you mean by CHGPF, what would you be changing w. that command? -----Original Message----- From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Don Wereschuk Sent: Tuesday, April 04, 2006 2:28 PM To: RPG programming on the AS400 / iSeries Subject: Changing a PF Need some help with changing a PF. I have a file with 3.5 million records. I have changed the DDS to include a new field at the end of the record. Does anyone know if it would be quicker to rename the file, recreate the PF and copy the records from the renamed file to the new file OR do a CHGPF on the old file. ****************************************** Don Wereschuk ISD Associate - Programmer Simcoe Parts Service Inc. Phone: 705-435-7814 Ext.: 302 Fax: 705-435-6746 dwereschuk@xxxxxxxxxxxxxxx ****************************************** -- This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/rpg400-l or email: RPG400-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/rpg400-l. This message contains information proprietary to our company. It is intended to be read only by the individual or entity named above or their designee. Any distribution of this message or the information contained herein without written permission from our company is strictly prohibited. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail, and delete the original message. -- This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/rpg400-l or email: RPG400-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/rpg400-l. This email communication and accompanying documents is intended only for the individual or entity to which it is addressed and may contain information that is confidential, privileged or exempt from disclosure under applicable law. Any use of this information by individuals or entities other than the intended recipient is strictly prohibited. If you have received this in error, please notify the sender and delete all the copies (electronic or otherwise) immediately. -- This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/rpg400-l or email: RPG400-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/rpg400-l. -- This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/rpg400-l or email: RPG400-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/rpg400-l. ------------------------------ message: 2 date: Tue, 4 Apr 2006 14:57:15 -0400 from: "Don Wereschuk" <dwereschuk@xxxxxxxxxxxxxxx> subject: RE: Changing a PF Just a bit more info on this. The file I want to change needs to be backed up in case there are problems as this is in production. Also I only have a limited time to do this thru the week so I'd like to do it now as opposed to taking up part of my weekend. There are also a number of logicals that have to be re-compiled plus a number of programs that use this file. ****************************************** Don Wereschuk ISD Associate - Programmer Simcoe Parts Service Inc. Phone: 705-435-7814 Ext.: 302 Fax: 705-435-6746 dwereschuk@xxxxxxxxxxxxxxx ****************************************** -----Original Message----- From: Don Wereschuk Sent: Tuesday, April 04, 2006 2:28 PM To: RPG programming on the AS400 / iSeries Subject: Changing a PF Need some help with changing a PF. I have a file with 3.5 million records. I have changed the DDS to include a new field at the end of the record. Does anyone know if it would be quicker to rename the file, recreate the PF and copy the records from the renamed file to the new file OR do a CHGPF on the old file. ****************************************** Don Wereschuk ISD Associate - Programmer Simcoe Parts Service Inc. Phone: 705-435-7814 Ext.: 302 Fax: 705-435-6746 dwereschuk@xxxxxxxxxxxxxxx ******************************************
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
