This tab shows the actual SQL statement of the preset. The SQL statement also contains the parameters, if any. Parameters are identified by a colon.
Parameters may occur only once. To use a parameter more than once, you can use a SQL parameter and fill it with the preset parameter. The SQL parameter can be used without any restrictions.
Note: Almost all Isah presets are based on stored procedures. This means you do not see the actual SQL code, but only a procedure name.
Example
An SQL statement with a parameter could look like the following:
select * from country
where CountryCode = :CountryCode
Tip: The text block in which you enter the SQL statements has the same features as the form you use to add scripts. For example, you can press CTRL+SPACE BAR to display a list of all available SQL statements.