SQL Tab
The following list describes the properties on the SQL Statement Record Properties dialog box SQL tab:
- Data Source
- List of all the data sources associated with this side of the map.
- SQL Statement
- Enables you to type SQL. This box also accepts C-style comments. For example, /*This is a comment*/
- Full Screen
- Maximizes the SQL statement list.
- Returns a Result Set
- SQL statement returns results.
- SQL statement is a Stored Procedure call
- SQL statement is a stored invocation procedure instead of a query or command.
- Test SQL
- Tests the SQL statement.
- Tables/Views
- List of database tables and views associated with the selected data source if a schema has been generated for the data source.
- Column Info
- Column information from the selected database table if a schema has been generated for the data source. The data type displayed is the translator data type of the column, not the database data type.