1. Table Conversion Guide
  2. Defining Table Conversion Output

Defining Table Conversion Output

Click Next on the Select Input form to access the Select Outputs form.

  1. Drag the table (or tables) that you want to use as outputs to the Description column, and click Next.

  2. For text file conversions, from the Text File tab, select the file to use as the output, and click Use.

    If you want to rename the selected file, enter the new file name, and click Rename.

    For the IBM i, input text files are stored in the IFS. Enter the path to the IFS before the file name.

    If you are using a text file, or if you need to define a format for a table or business view, select the User Defined Format option.

    Note: Text files are the only type of file that you can rename.

  3. Click Next.

  4. To delete an output, select the row and press Delete.

    If you are using a text file, or if you need to define a user-defined format for a table or business view, click User Defined Format.

  5. Click Next.

  6. On the Table Options form, select from these options:

    • Run Currency Triggers

      Select this option if a JD Edwards EnterpriseOne table that is included in the table conversion contains currency triggers. If a table contains currency fields and you do not select this option, the system cannot determine where the decimal should be placed within a field. If you do not select the currency trigger option, and the source or destination fields are currency fields that are used in a calculation, you might receive unexpected results.

      Do not select the Run Currency Triggers option if the input and output data sources are the same type (for example, Oracle, IBM i, or SQL Server) and no calculations are performed. Selecting this option results in slower performance.

      You should not use currency triggers for an environment that has a different path code from the sign-in environment.

    • Clear Output Tables

      Select this option to clear the output table before the table conversion runs.

    • Force Row by Row Processing

      Select this option to test the table conversion or to ensure that the conversion always runs in row-by-row mode.

      You can test a conversion to ensure that the mapping logic is correct. In this case, specify the number of rows to process. The number of rows can be defined in the jde.ini under [TCEngine] or when you submit the table conversion.

      Select this option if you know that the values in the input table will produce duplicate keys in the output, and you want only the non-duplicate keys to be inserted.

      Selecting this option results in slower processing.

    • Buffer Inserts To Output Tables

      Select this option to improve conversion performance if the conversion does not include any event rules to process insertion errors and you are processing row by row.

  7. Click Next.