General Tab

This tab is displayed by default. It provides the interface for entering table names, the number of prefetch rows returned from Informix®, and the type of query. The General tab contains the following fields:

• Table names. This field appears only when you select Generated SQL query. It contains the names of the Informix source tables or files being accessed. These tables must exist or be created and populated by Before SQL statements. There is no default.

  Separate multiple table names by a comma ( , ). You must have select privileges on each table. If you specify User-defined SQL query, Table names is ignored. You must specify a table name in Table names if you do not define User-defined SQL query.

  Additionally, you can use a job parameter to specify the table name.

  You can also click the ... button at the right of the Table name field to browse the repository to select the table.

• Prefetch rows. The number of rows that Informix returns when InfoSphere® DataStage® fetches data from the source tables. Specifying a value greater than 1 improves performance (memory usage increases to accommodate buffering multiple rows).
• Query type. Displays the Generated SQL query and User-defined SQL query options. Query type combines the "Generate SQL" and "User Defined SQL" grid properties.
  • Generated SQL query. This is the default setting, which specifies that the data is extracted using an SQL statement constructed by the stage. When this option is selected, the Generated tab appears. You cannot edit this statement.
  • User-defined SQL query. Specifies that the data is extracted using a user-defined SQL query. When this option is selected, the User-defined tab appears allowing you to edit SQL statements.
• Description. Contains an optional description of the output link.