Table of Contents

Search

  1. Preface
  2. Product Overview
  3. Before You Begin
  4. Tutorial Lesson 1
  5. Tutorial Lesson 2
  6. Tutorial Lesson 3
  7. Tutorial Lesson 4
  8. Tutorial Lesson 5
  9. Tutorial Lesson 6
  10. Appendix A: Naming Conventions
  11. Appendix B: Glossary

Getting Started

Getting Started

Creating a Target Table

Creating a Target Table

In the following steps, you use the Designer to generate and execute the SQL script to create a target table based on the target definition you created.
  1. Select the table T_ITEM_SUMMARY, and then click
    Targets
    Generate/Execute SQL
    .
  2. In the
    Database Object Generation
    dialog box, connect to the target database.
  3. Click
    Generate from Selected tables
    , and select the
    Create Table
    ,
    Primary Key
    , and
    Create Index
    options.
    Leave the other options unchanged.
  4. Click
    Generate and execute
    .
    The Designer notifies you that the file MKTABLES.SQL already exists.
  5. Click
    OK
    to override the contents of the file and create the target table.
    The Designer runs the SQL script to create the T_ITEM_SUMMARY table.
  6. Click
    Close
    .

0 COMMENTS

We’d like to hear from you!