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.
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.
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 |