User`s guide

Source components
82 Sybase IQ ETL 4.1
SELECT A.CU_NO, A.CU_NAME, A.CU_CITY, B.SA_ORDERDATE,
B.SA_TOTAL
FROM CUSTOMERS A, SALES B
WHERE A.CU_NO = B.CU_ID
ORDER BY A.CU_NO
For database schema lookups, click Database Lookup.
Note The SELECT statement must be compliant with the SQL language
supported by the connected database system. Be especially aware of
differences regarding quote characters, date functions, and expressions. It is
good practice to use the SQL 92 ANSI standard for queries compatible
between different database systems.
Using Query Designer to enter a query
Click Query Designer to open the Query Designer. To learn more about this
tool, see “Query designer” on page 55.
Validating a query
Click Execute Query to run the query.
Modifying a connection
After modifying connection parameters, re-logon to the database to validate the
settings. To re-logon, right-click the component in the project and select
Logon.
Optional properties
The optional properties are:
• Read Block Size — defines the number of records retrieved by the
component within a single simulation step.
• Pre-processing SQL — defines one or more SQL statements to be
executed during initialization of the component.
• Post-processing SQL — defines one or more SQL statements to be
executed after all components finished execution.
See “Entering database connection parameters” on page 71 for more
information about the optional properties and for more information about the
following properties: