Re: CRTPF question?

[cmassoglia@xxxxxxxxxxx (Charlie Massoglia)]

Tim Truax wrote:

>Why isn't there a keyword on the CRTPF CL command that will give you an
>option to reserve the files existing data and then *ADD the data back
>using the FMTOPT(*NOCHK) for you?  Is this a stupid question?  But the
>OS400 developers seemed to have thought of everything so I am suprised
>that you have to go thru several steps when changing a physical file
>(Change the DDS, CRTDUPOBJ the current file, then CRTPF the new blank
>file, then CPYF the old data into it) Is there a good reason for these
>methodical steps? 

As of V3R2 you can change a physical file in place using CHGPF as long as
you are not deleting a field used in a logical file.  Just specify the name
of the source physical file containing the DDS for the file.  It does
everything you used to have to do manually.

It is beyond me why CHGPF will add a field to a logical file created over a
physical file using the physical file's record format but will die if you
try to delete a field.

I understand this is an SQL compatibility issue.  Once again the "lowest
common denominator" syndrome limits the capabilities of OS/400.


Charlie Massoglia, Massoglia Technical Consulting, Inc.
PO Box 1065, Okemos, MI 48854, USA
517-676-9700  Fax: 517-676-1006  EMAIL: cmassoglia@voyager.net


root
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the Midrange System Mailing List!  To submit a new message,   *
* send your mail to "MIDRANGE-L@midrange.com".  To unsubscribe from     *
* this list send email to MAJORDOMO@midrange.com and specify            *
* 'unsubscribe MIDRANGE-L' in the body of your message.  Questions      *
* should be directed to the list owner / operator: david@midrange.com   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *