Use the Interactive SQL window to send SQL queries to Connect CDC servers. The results of your queries are displayed in an SQL Results window, from which they can be saved and printed. The SQL statements you send are subject to certain usage rules and restrictions. See Enter SQL.
To use interactive SQL
-
Select the server you want to query, and select New SQL Window from the context menu. If you already have an SQL window open, select SQL Window.
-
If more than one logon ID is already defined for this server on its Properties dialog, Server page, select an ID for the connection to the server from the Interactive SQL window.
Note: If you are testing replication, the connection ID must not be the replicating user. See Set up an SQL connection for testing replication. -
Enter SQL statements in the Interactive SQL window, and click the Go or Execute one button at the bottom of the window to execute the SQL.
Or click the Open button to find and open a file that contains an executable SQL script, for example.
Depending on the type of data you are retrieving and what you want to do with that data, select or clear the Use spaces between columns checkbox. See Use spaces between columns, instead of Horizontal tabs.
To commit each statement you execute automatically, select the Use autocommit checkbox. See Use autocommit.
-
View the result of your query in the Status of last request box and in a separate SQL Results window. You can use the SQL Results window to accumulate the results of multiple queries.
-
As necessary, use the Save as and the View results buttons.