change size of two fields without increasing size of file

Dennis Malen dmalen at malen.com
Wed Sep 9 14:39:55 PDT 2009


Ken,

I assumed that was the case but did not want to take a chance with this very 
important file until I asked the list.

Thanks!

Dennis Malen
516.479.5912
----- Original Message ----- 
From: "Kenneth Brody" <kenbrody at spamcop.net>
To: "Dennis Malen" <dmalen at malen.com>
Cc: <filepro-list at lists.celestial.com>
Sent: Wednesday, September 09, 2009 4:00 PM
Subject: Re: change size of two fields without increasing size of file


> (Top-posting corrected.)
>
> Dennis Malen wrote:
>> ----- Original Message ----- From: "Kenneth Brody" <kenbrody at spamcop.net>
> [...]
>>
>>> Dennis Malen wrote:
>>>> Assume the following:
>>>>
>>>> Field 7 is 20 digits.
>>>> Field 86 is 6 digits.
>>>>
>>>> I want to add 5 digits to field 7 and reduce field 86 to 1 digit.
>>>>
>>>> Can I go in and change the size and let it rip? Will all the other 
>>>> fields remain intact?
>>>
>>> If by "go in" and "let it rip", you mean "use ddefine to make the change 
>>> and let it restructure the file", then of course the other fields will 
>>> remain intact.  Why would this scenario be different than any other?
>>>
>>> If you meant something else, then you'll need to explain further.
>>>
> > So the size of the file will remain the same and the all the other
> > fields will remain intact as there are over 300,000 records in this 
> > file?
> >
> > Yes, we do intend to use ddefine.
>
> I guess you've never changed a file definition before?  That's what 
> ddefine does when you change the file definition in a file with records in 
> it -- it restructures it to match the new definition.  If you only change 
> 2 out of the 86+ fields, then only those 2 fields will be changed.  The 
> other 84+ fields will be left alone, as you didn't change their 
> definition.
>
> And, because the resulting record length is the same as the original 
> record length, the file will remain the same size.
>
> Again, why would you expect otherwise?
>
> -- 
> Kenneth Brody 



More information about the Filepro-list mailing list