Renaming Tables

[Jupiter]

Hi,
Is it possible to rename a table without dumping and reloading its data? Please help.

 

[TomBascom]

Yes.

Just go into the data dictionary, choose "modify table", pick a table, change the name and save your changes.

Code which uses the old table name will need to be changed to reflect the new table name or you will have compile errors

 

[Jupiter]

Yes.

Just go into the data dictionary, choose "modify table", pick a table, change the name and save your changes.

Code which uses the old table name will need to be changed to reflect the new table name or you will have compile errors

Thanks Tom,
But My requirement is to do this during loading incremental df. Coz I have to deploy my source code with incremental df.
Thanks again... in advance.

 

[KlausErichsen]

Thanks Tom,
But My requirement is to do this during loading incremental df. Coz I have to deploy my source code with incremental df.
Thanks again... in advance.

That is also easy. Change the names in a second database, connect both dbs and create a so called delta.df with the Data Administration. It will ask you, if you want to rename the table.

Best Regards
Klaus

 

[Jupiter]

Hi Klaus,
Sorry for late reply.As I ould not visit this place for quite sometime. Your suggestion worked. Thanx a lot.

Regards