In this lesson, you query the remote database and return results to the server. This is very useful when troubleshooting because you can find out exactly what state the remote database is in.
This lesson assumes you have completed all preceding lessons. See Lesson 1: Creating a consolidated database.
This lesson assumes you have the roles and privileges listed in the Privileges section at the start of this tutorial: Tutorial: Using central administration of remote databases.
Context and remarks
The tables you have added to the database in this tutorial do not contain any data, so instead you query the database system tables. Even though you are querying a system table in this example, everything you do works exactly the same way as if you queried a user table.
Suppose that you wanted to confirm that the schema change you performed in the last lesson did what you expected, that the product table was created with the correct columns. You could confirm that by querying the systable and systabcol system tables.
In the Folders view of Sybase Central under MobiLink 16, expand Central Admin Tutorial, right-click Remote Tasks and click New » Remote Task.
The Create Remote Task Wizard appears.
On the Welcome page, type Table Query in the Name field.
Check This task requires or creates a remote database and set the Remote schema name to Tutorial Application v2.0 and click Next.
On the Trigger Mechanisms page, check When it is received by an agent and click Finish.
Add an Execute SQL command to the task with the following SQL:
SELECT * FROM systable WHERE table_name = 'product' go SELECT * FROM systabcol ORDER BY table_id
Right-click the new Table Query task and click Deploy. Click Next.
For Recipients, choose Specific agents, select agent AID_JOHN and click Next and then click Next again.
On the Reporting Results And Status page, set both If task succeeds and If task fails to Send results and status immediately. Click Finish and wait until the task executes.
Click the deployed copy of the Table Query task in the Folders view and then click the Results tab. If you don't see any results on the tab, wait until the tab is automatically refreshed or press F5 to refresh immediately.
Right-click the line in the table for the Execute SQL statement and choose Details.
The Command Result window appears.
Click the Results tab on the window. This tab shows results of any queries executed. The Result dropdown at the top of the pane allows you to switch between results for the two queries. Click Close.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|