Perform the following steps
to validate a query in the
Designer window:
-
Click
Validate SQL in the toolbar at the top of the
Designer window.
-
Examine
the
Log tab that is displayed in the
Designer window to verify that the query was submitted
successfully or to troubleshoot an unsuccessful submission.
Note: You can use
the Runtime Manager in SAS Data Integration Studio to cancel the SQL
query. The SQL Join transformation is displayed as a row in the Runtime
Manager. You can right-click the row and click
Stop Job to cancel the query. (You can also click
Stop in the
Designer window
toolbar.) The SQL Join transformation is currently the only transformation
that supports this type of cancellation.