Creating a Custom Table for J.D. Edwards World

How to:

You must create a custom table for J.D. Edwards World to store key fields of an activity on J.D. Edwards World base tables. You can create a custom table using a J.D. Edwards World Table Design Aid, or third-party tool, such as DB Visualizer. The following example describes how to create a custom table using DB Visualizer.


Top of page

x
Procedure: How to Create a Custom Table

The iWay custom table, IWAY_JDE, must be created in the World DB2 Database. This is the table that will receive key-based data for transactional events.

  1. Copy the following SQL script and paste it into the top input box on the DB Visualizer SQL Commander tab.
    Create table JDFDATA.IWAY_JDE 
         (IWAY_DATE        DATE,
          IWAY_TRANSACTION NUMERIC,
          IWAY_KEYS        CHAR(256),
          IWAY_ACTION      CHAR(12))

Note: This JDFDATA string references the "Library" where the table will reside in DB2. The DB2/World Administrator must provide support and guidance for the DBA functions. They might specify a different "Library" designation for their specific site/environment.


iWay Software