Wizard Summary Screen (Magic xpi 4.5)
In the Wizard Summary screen, you can view and edit the created SQL statement. However, this statement will not show the WHERE clause, since it will be determined during the mapping itself.
|
|
|
|
SQL Statement
|
This field lets you edit the SQL statement created by the wizard. If the current object is a Source object, only a Select statement is allowed. If the current object is a Destination object, then only Update, Insert, and Delete statements are allowed.
You can edit the statement and add flow variables. When a flow variable is entered, it will be surrounded by angle brackets and question marks as follows: <?flow variable name?>. You can also add other legal SQL statement text, such as Example or Order By.
You can use multiple tables in the statement, with a JOIN between them (or, if multiple tables were selected through the wizard, a JOIN will be automatically created according to the selections made in the wizard).
For more information on what types of SQL statements can be used in the Data Mapper, see Creating an SQL Statement.
|
Note:
|
If you used environment variables for your databases, the wizard will use them in the SQL statement.
|
|
|
Translated SQL Statement
|
Displays the full SQL statement that will be sent to the database with translated environment variables when you select the Translate check box.
|
