Who's On?

recreate lawson table

5 Replies

1 Subscribed to this topic

12 Subscribed to this forum

Sort:

Author

Messages

Ludy

Basic Member

Posts: 21

10/6/2016 1:59 PM

Hi,

Does anyone know if it's possible to recreate a lawson table?

If it is, how do we do it?

Thanks,

Ludy

John Henley

Posts: 3353

10/6/2016 2:22 PM

do you mean you need to recreate it within the database?

Ludy

Basic Member

Posts: 21

10/6/2016 3:16 PM

John, we need to recreate the table itself.

Xin Li

Veteran Member

Posts: 133

10/6/2016 3:27 PM

If your database is Oracle. you can use bldoraxxddl to recreate table. xx is dependent on which version of Oracle you are using.

John Henley

Posts: 3353

10/6/2016 3:32 PM

Posted By Ludy on 10/06/2016 11:16 AM
John, we need to recreate the table itself.

Does the table exist within the Lawson metadata, e.g. dbdef?

If so, then you would use the bldxxxddl (where xxx is msf, ora, ibm etc.) to create the table in the database.

Be *VERY* careful with the command, and its options. You can destroy your entire database

Ludy

Basic Member

Posts: 21

10/6/2016 3:54 PM

Thank you, John and Xin for the quick response.