Building INSERT statements
Build INSERT statements to insert rows in a database table.
Procedure
- Click the Insert tab.
- 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.
- 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.
- 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.
- Click on the Sql tab to view the finished query.
Parent topic: Building SQL statements