Information icon IBM Information Server, Version 8.1
Feedback

Using a Generated Query

You can write data to an SQL table using an SQL statement constructed by WebSphere® DataStage®. When you specify the table and the column definitions to use, the SQL statement is automatically constructed and can be viewed on the View SQL tab.

To use a generated query:

  1. Choose a table from the Table name list on the General tab.
  2. If required, specify that the existing table is cleared before new rows are written by selecting the Clear table before writing check box.
  3. Type an optional description of the input link in the Description field.
  4. Click the Columns tab. The Columns tab appears at the front of the Inputs page.
  5. Edit the Columns grid to specify column definitions for the columns you want to write.

    The SQL statement is automatically constructed using your chosen update action and the columns you have specified. You can now optionally view this SQL statement.

  6. Click the View SQL tab. The View SQL tab appears at the front of the Inputs page.
  7. Click OK to close theUniData 6 Stage dialog box. Changes are saved when you save your job design.
Parent topic: Defining UniData 6 Input Data
PDF This topic is also in the IBM WebSphere DataStage and QualityStage Connectivity Guide for IBM UniVerse and UniData.

Update icon Last updated: 2008-09-30