Creating an Insert Request

Use the Insert Request Editor to create an Insert Request. An Insert Request is a set of specifications that determines how the insert process inserts data.

To create an Insert Request:

  1. In the main window, click File > New > Insert from the main menu. The Insert Request Editor opens.
  2. On the General tab, enter the name of the source file and the Control File. You must also enter a Table Map name or choose to create a local Table Map.
  3. Provide any additional parameters, including Process Options that determine how the data is inserted.
  4. Click File > Save to open the Save the Insert Request dialog.
  5. In the Pattern box, type a unique name for the new Insert Request and click Save.