Copying files is a long process, if files are huge. I liked Franco's hacking idea. Besides, it seems to work well.
>USE PP32GLOT02_B
>COPY TO path+PP32GLOT03_B DATABASE path+PP32GLOT02 PRODUCTION
>USE IN PP32GLOT02_B
>DROP TABLE PP32GLOT02_B
>
>>Hi everybody,
>>
>>Suppose, I have a table called PP32GLOT02_B, which is part of a database PP32GLOT02. 02 stands for Fiscal Year. Suppose, I found, that the fiscal year was assigned incorrectly and everything should be named ending on 03 (Fiscal Year 2003). How can I rename all these files and don't corrupt my database? Doing it in Explorer leads to errors while opening a database (though these errors could be resolved). I want to automate this process.
>>
>>Would appreciate your ideas.
>>
>>My own idea would be to create an empty clone of the table and append from the original one, but it seems like too complicated solution.
>>
>>Thanks in advance.
If it's not broken, fix it until it is.
My Blog