Changing file Frame SIze (OpenInsight Specific)
At 11 DEC 1997 12:36:46PM Steve C. wrote:
I've been looking all through the Native Table manual,
and searched this discussion group and knowledge base.
I'm on OIWG 3.5. How do I change a table's frame size
from 1024 to 4096. Can I do it through the Database Manager
or entering a command in the System Editor. I've read a lot
about the subject… but no where have I found How to do
it. Thanks…. Steve Carlson.
At 11 DEC 1997 12:46PM Andrew P Mcauley wrote:
By far and away the easiest is to create a new file with the correct size then copy across…
amcauley@sprezzatura.com
World Leaders in all things RevSoft
At 11 DEC 1997 12:51PM Nick Stevenson wrote:
A bit of elbow grease is required, I'm afraid. Create a dummy table in your database with the frame size you require (you can set the frame size when creating the new table). In the editor Exec Line, use the COPYROW routine to copy all the rows from your table into the dummy table. (RUN COPY_ROW "FILE_A","*","DUMMY_FILE","*").
Then get the REVnnnn numbers for both files from Database Manager. Log out of the system, go to DOS and copy the dummy file over the old file…. after taking backups, of course. Hey presto… a resized file!