To enter a query, enter the SELECT statement straight into the Query field. Any valid SELECT statement based on the underlying database system and schema is allowed. No delimiting character to mark the end of the statement is required, for example:
SELECT * FROM CUSTOMERS 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.
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.
Click Query Designer to open the Query Designer. To learn more about this tool, see “Query designer”.
Click Execute Query to run the query.
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.
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” for more information about the optional properties and for more information about the following properties:
Database
Schema
Database options
Read Block Size value impacts the number of records loaded in a single simulation step.
Projects in DemoRepository and Help Flash movie:
Demo Transfer US Products
Demo Transfer German Sales
