Wizard Result Screen (Magic xpi 3.x)
In the Wizard Result 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.
|
Note:
|
-
When you click SQL from the Database Schema Properties window to manually enter an SQL statement, this dialog box's name is SQL Statement.
-
After you set any text in the SQL Statement dialog box, you must use the TAB key to enable the OK button.
|
|
|
|
|
|
Enter 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
-
You can click  to open the Translated SQL Statement dialog box. This displays the full SQL statement that is sent to the database, with translated environment variables.
|
|
|
