The components in the upper half of the SQL builder are
common to all types of SQL statement that you can build. The pages
that are available in the lower half depend on the type of query that
you build.
Toolbar
The toolbar for the SQL builder contains tools for actions
such as clearing the current query, viewing data, and validating the
statement.
Tree panel
The tree panel shows the table definitions in the IBM® InfoSphere® DataStage® repository.
You can import a table definition from the database that you want
to query.
Table selection canvas
The table selection canvas shows a list of columns and
column types for the table that the SQL statement accesses.