recreate lawson table

 5 Replies
 1 Subscribed to this topic
 12 Subscribed to this forum
Sort:
Author
Messages
Ludy
Basic Member Send Private Message
Posts: 21
Basic Member

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
Send Private Message
Posts: 3351
do you mean you need to recreate it within the database?
Thanks for using the LawsonGuru.com forums!
John
Ludy
Basic Member Send Private Message
Posts: 21
Basic Member
John, we need to recreate the table itself.
Xin Li
Veteran Member Send Private Message
Posts: 133
Veteran Member
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
Send Private Message
Posts: 3351
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

Thanks for using the LawsonGuru.com forums!
John
Ludy
Basic Member Send Private Message
Posts: 21
Basic Member
Thank you, John and Xin for the quick response.