Hi,

I need to add a field to one table
but without recreating it. I heard that this is possible by altering the Baan's dictionary files. Does somebody know how to do that?

I'm using baan IVC2 with Oracle 8

Thanks in advance

I am not sure if it’s possible to add a field to the table with out modifying/configuring the table. I see that you are using oracle for backend, so, just modifying the baan dictionary will not force the database to store the data related to this new field in oracle.

What is the reason you don’t want to modify/recreate the table?

Thanks,
NS

Fully agreeing with NS , doing such backend adjustments are not at all advisable. Technically this may be possible if you have oracle table also in same format and make the Baan dictionary according to Oracle table def and actual oracle table storage.

When you create runtime dd the changes so made will get lost. So file level changes to dd not at all advisable.

Thanks for your reply. Actually, what we want to do is adding a field to the table (using "alter table") by Oracle, and then update the file (or files) associated to the Baan's dictionary, so the field gets reflected in the application.

Adding a field using the Baan session is alot cumbersome (specially on tables with 40 or more million of registers), because it first copies the table to a temporary one, then adds the field to a new structure, and then copies back the data. A too much long and stressing process.