User`s guide

Content Explorer
48 Sybase IQ ETL 4.1
❖ To modify the default setting of a join
A join between two tables is indicated by a line that connects the joining fields.
The line is labeled with a join operator. The default is Equi Join.
1 Right-click the line connecting the two joining fields.
2 Select the Modify command.
3 Choose a join type from the list:
•= EQUI Join
• += Left outer Join
• =+ Right outer Join
• +=+ Full outer Join
The default setting of the join changes to the type you selected.
❖ To add one attribute to the SELECT clause
1 Drag the tables to the Design area (if they are not there already).
2 Click the attribute names you want to add.
3 Right-click and select Add Items to Selection.
❖ To select more than one attribute to the SELECT clause
1 Drag the tables to the design area (if they are not there already).
2 Hold the Ctrl key and click the attributes that you want to add to the
SELECT clause.
3 Right-click and select the Add Items to Selection.
❖ To select all attributes of a selected table to the SELECT clause
1 Click the header (name) of the table in the Design area.
2 Right-click and select Add Items to Select.
❖ To view generated SQL statements
• To display the statement as currently generated by the Content Explorer,
click Generated Query or select Generated Query from the View menu.
❖ To add functions to the SELECT attributes
1 Click the attribute and right-click to open the pop-up menu.
2 Select any of the available functions.