Defining Data Copy Actions
Access the JD Edwards EnterpriseOne Table Conversion Director.
Select Data Copy, and click Next.
On the External Data form, select a processing option template, define a data structure, as appropriate, and click Next.
On the Select Environments form, select an input environment and an output environment, and click Next.
On the Select Actions form, enter the name of a table in the Table field of the grid.
If you want to copy a single table, select <Literal>, and enter the name of that table on the Single Value tab. If you do not know the name of the table that you want to copy, use the <Find a Table> option.
When you enter the name of a table, the system automatically populates the remaining fields for you.
On the Select Actions form, modify these fields as necessary:
To Table
Enter either the last table in a range of tables to be copied, or leave the field blank if you are copying a single table.
Source Type
Select Data Source if the input and output sources are data sources. Select Environment if the input and output sources are environments.
When you select Data Source, the system retrieves table definitions from the specifications in the sign-in environment.
When you select Environment, the system uses the input and output environments to locate data and specifications for the tables. This enables the specifications to be different in the input and output environment, but the data is copied.
Input Source
Select the data source or environment from which the input is read.
Output Source
Select the data source or environment to which the output is written.
Create
When you select <If Table Exists>, the system creates the table in the output and runs the conversion only if both the table specifications and the actual table exist in the input.
When you select <Yes>, the system creates the table in the output. If the table already exists in the output, the system deletes it and creates a new table.
When you select <No>, the system assumes that the table already exists in the output and does not create it.
Clear
When you select <If Table Exists>, the system clears the table in the output only if it exists in the input.
When you select <Yes>, the system deletes all rows in the output table before copying the table.
When you select <No>, the output table is not cleared.
Note: If you select <No> to not clear the output table, the conversion could result in key conflicts.Copy
When you select <Yes>, the system copies the data from the input table to the output table using Map Same.
When you select <No>, no data is copied.
Owner ID
Owner Pwd (owner password)
If the data source requires an owner ID and password, enter them here. If you leave these fields blank, the system enters the ID and password of the sign-in user, or <None> if the data source does not have security.
To import an existing copy table script from another location, click Import, locate the file that you want to import, and click Open.
The system adds an action for each copy table item in the copy table script.
Click Advanced ER to add event rule logic to the copy table process, and click Next.
You can use event rules to write a custom copy table script.
On the Logging Options form, select the appropriate logging options, and click Next.
On the Finish form, select a version option, and click Finish.