reapply dbdef changes after data refresh

 2 Replies
 0 Subscribed to this topic
 17 Subscribed to this forum
Sort:
Author
Messages
Karen Sheridan
Veteran Member
Posts: 141
Veteran Member
    Good Morning

    I used to know how to do this, but cannot find any notes so...

    I added tables to a test product line in dbdef, built dictionary, applied to database in April.  The project stalled for a while, the database was refreshed.

    My definitions are in dbdef, but I need to get them applied back out to the physical database (Oracle 11).

    Seems like bldora11ddl  is what I need - can someone verify the steps for me?

    TIA,
    Karen Lynn Schuette
    Judy Consoli
    Veteran Member
    Posts: 43
    Veteran Member
      That’s correct – I use bldibmddl with the –U option for update for db2.

      J

      From: forums-lsf-s3-cust-dev@lawsonguru.com [mailto:forums-lsf-s3-cust-dev@lawsonguru.com]
      Sent: Wednesday, July 20, 2011 11:59 AM
      To: Judy Consoli
      Subject: reapply dbdef changes after data refresh [00008912:00000000]

      [https://images.lawsonguru.com/logos/LawsonGuru_com_200.jpg]<https://www.lawsonguru.com/>
      S3 Customization/Development Forum Notification
      A message was posted to a thread you are tracking.
      reapply dbdef changes after data refresh

      Posted by: Karen Schuette
      07/20/2011 09:49 AM

      Good Morning

      I used to know how to do this, but cannot find any notes so...

      I added tables to a test product line in dbdef, built dictionary, applied to database in April. The project stalled for a while, the database was refreshed.

      My definitions are in dbdef, but I need to get them applied back out to the physical database (Oracle 11).

      Seems like bldora11ddl is what I need - can someone verify the steps for me?

      TIA,
      Karen Lynn Schuette

      ________________________________

      To view the complete thread and reply via your browser, please visit:
      https://www.lawsonguru.co...-after-data-refresh/

      You were sent this email because you opted to receive email notifications when someone posted and/or responded to a message on this forum.
      To unsubscribe to this thread please visit your user profile page and change your subscription options.

      Thank you,
      LawsonGuru.com

      ________________________________
      Email correspondence to and from this address is subject to public records requests pursuant to the North Carolina Public Records Law, resulting in monitoring and potential disclosure of this message to third parties.

      In compliance with federal law, Charlotte-Mecklenburg Schools administers all education programs, employment activities and admissions without discrimination against any person on the basis of gender, race, color, religion, national origin, age or disability.
      John Henley
      Posts: 3353
        You should use verifyora11 to figure out which tables / indexes are missing.
        Then use bldora11ddl to create the missing tables / indexes.
        Thanks for using the LawsonGuru.com forums!
        John