Executing a View

After you have designed and saved a view (refer to Designing a View and Table Resource) you can execute its SQL from within Studio to see the result.

For executing a view’s SQL through client applications, see TDV Client Interfaces Guide.

Executing a view might be affected if the view uses a data source that was originally added to TDV Server using the pass-through mode without saving the password. To execute such a view, you must log into TDV Server with the same login credentials (user name/password) that are necessary to log into the data source. For further information on pass-through credentials, see the details for the Save Password and Pass-through Login fields under Adding a Data Source.

Executing a view from Studio is blocked if the view’s SQL is SELECT * on a view that includes a table with column-based security (see “About Managing Dependency Privileges” in the TDV Administration Guide).

To execute a view from Studio

1.

Double-click the view to open it, or right-click the view. Select Open.

2.

Click the Execute button.

The Result panel displays the first 50 rows (default) of view execution results.

3.

Use the Load More Results button to view the next 50 rows.