SQL Remote User's Guide
SQL Remote for Adaptive Server Enterprise and Adaptive Server Anywhere: Differences
Differences in approach
In SQL Remote for Adaptive Server Anywhere, SQL statements are used to carry out the tasks that these stored procedures carry out in Adaptive Server Enterprise. The following table lists the SQL Remote procedures, and how they correspond to SQL statements in Adaptive Server Anywhere:
| Adaptive Server Enterprise procedure | Corresponding Adaptive Server Anywhere statement |
|---|---|
| sp_remote_type | CREATE REMOTE MESSAGE TYPE |
| sp_remote_type | ALTER REMOTE MESSAGE TYPE |
| sp_drop_remote_type | DROP REMOTE MESSAGE TYPE |
| sp_grant_remote | GRANT REMOTE |
| sp_revoke_remote | REVOKE REMOTE |
| sp_publisher | GRANT PUBLISH |
| sp_publisher | REVOKE PUBLISH |
|
sp_create_publication
sp_add_article sp_add_article_col |
CREATE PUBLICATION |
|
sp_add_article
sp_remove_article sp_add_article_col sp_remove_article_col |
ALTER PUBLICATION |
| sp_drop_publication | DROP PUBLICATION |
| sp_subscription 'create' | CREATE SUBSCRIPTION |
| sp_subscription 'drop' | DROP SUBSCRIPTION |
| sp_subscription 'start' | START SUBSCRIPTION |
| sp_subscription 'stop' | STOP SUBSCRIPTION |
| sp_subscription 'synchronize' | SYNCHRONIZE SUBSCRIPTION |
| sp_passthrough_user | PASSTHROUGH FOR USERID |
| sp_passthrough_subscription | PASSTHROUGH FOR SUBSCRIPTION |
| sp_passthrough_stop | PASSTHROUGH STOP |