Search VisualAge for Java Information Go to Information Home Page Go to VisualAge for Java WWW Site

SQL Assist SmartGuide

Use the SQL Assist SmartGuide to visually compose an SQL statement for a Select bean.

Pages

Tables Page

Use the Tables page of the SQL Assist SmartGuide to specify the tables that are accessed in an SQL statement. The table names that are selected will appear in the FROM clause of the SQL statement.

Fields

Push buttons

Join Page

Use the Join page of the SQL Assist SmartGuide to join tables in an SQL statement. The join page displays the columns of each table selected in the Tables page. Select displayed columns to join. You can specify multiple joins.

Push buttons

Condition Page

Use the Condition 1 page of the SQL Assist SmartGuide to specify a search condition for an SQL statement. You can specify multiple search conditions; you specify each search condition in a separately numbered Condition page. The search conditions supplement any joins specified in the Join page, that is, the joins and the search conditions appear in the WHERE clause of the SQL statement.

Fields

Push buttons

Columns Page

Use the Columns page of the SQL Assist SmartGuide to specify the columns for the result set. The columns will appear in the SELECT clause of the SQL statement.

Fields

Push buttons

Sort Page

Use the Sort page of the SQLAssist SmartGuide to specify the order of rows in the result set. You specify the order by identifying a column to be used as a sort key. You can specify multiple columns, each one is used as a separate sort key. The rows of the result set are ordered by the value in the selected column, that is, by the value of the sort key. If you specify more than one sort key, the rows of the result set are ordered by the value of the first sort key, then by the value of the second sort key, and so on. The sorting specification will appear in the ORDER BY clause of the SQL statement.

Fields

Push buttons

Mapping Page

Use the Mapping page of the SQLAssist SmartGuide to remap the data retrieved from a table column to a different SQL data type.

Fields

.

Push buttons

SQL Page

Use the SQL page of the SQL Assist SmartGuide to display the SQL statement for a Select bean. After you display the SQL statement, you can copy it to the clipboard, run it as a test from the SQL page, or save it to a file.

Fields

.

Push buttons


Related procedures
Specifying the Tables for an SQL Statement
Joining Tables
Specifying Search Conditions
Specifying Result Columns
Sorting the Result Set
Remapping Data to a Different SQL Data Type
Displaying the SQL statement