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.