Building INSERT statements

Build INSERT statements to insert rows in a database table.

Procedure

  1. Click the Insert tab.
  2. Drag the table you want to insert rows into from the repository tree to the canvas. You must have previously placed the table definitions in the IBM® InfoSphere® DataStage® repository. The easiest way to do this is to import the definitions directly from your relational database.
  3. Specify the columns that you want to insert on the column selection grid. You can drag selected columns from the table, double-click a column, or drag all columns.
  4. For each column in the column selection grid, specify how values are derived. You can type a value or select a derivation method from the drop-down list.
    • Job Parameters. The Parameter dialog box appears. Select from the job parameters that are defined for this job.
    • Lookup Columns. The Lookup Columns dialog box appears. Select a column from the input columns to the stage that you are using the SQL builder in.
    • Expression Editor. The Expression Editor opens. Build an expression that derives the value.
  5. Click on the Sql tab to view the finished query.