PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 10/06/2016 11:54 AM by  Ludy
recreate lawson table
 5 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Ludy
Private
Private
Basic Member
(43 points)
Basic Member
Posts:21


Send Message:

--
10/06/2016 9:59 AM

    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
    Private
    Private
    Senior Member
    (9650 points)
    Senior Member
    Posts:3234


    Send Message:

    --
    10/06/2016 10:22 AM
    do you mean you need to recreate it within the database?
    Thanks for using the LawsonGuru.com forums!
    John
    Ludy
    Private
    Private
    Basic Member
    (43 points)
    Basic Member
    Posts:21


    Send Message:

    --
    10/06/2016 11:16 AM
    John, we need to recreate the table itself.
    Xin Li
    Private
    Private
    Veteran Member
    (288 points)
    Veteran Member
    Posts:130


    Send Message:

    --
    10/06/2016 11:27 AM
    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
    Private
    Private
    Senior Member
    (9650 points)
    Senior Member
    Posts:3234


    Send Message:

    --
    10/06/2016 11:32 AM
    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
    Private
    Private
    Basic Member
    (43 points)
    Basic Member
    Posts:21


    Send Message:

    --
    10/06/2016 11:54 AM
    Thank you, John and Xin for the quick response.
    You are not authorized to post a reply.