Update: Please confirm this query makes sense...

-- Look for existing MobiLink and SQL Remote objects on the remote database.
SELECT 1,  * FROM SYSARTICLE;          -- MobiLink     SQL Remote
SELECT 2,  * FROM SYSARTICLECOL;       -- MobiLink     SQL Remote
SELECT 3,  * FROM SYSPUBLICATION;      -- MobiLink     SQL Remote
SELECT 4,  * FROM SYSREMOTEOPTION;     --              SQL Remote
SELECT 5,  * FROM SYSREMOTEOPTIONTYPE; --              SQL Remote
SELECT 6,  * FROM SYSREMOTETYPE;       --              SQL Remote
SELECT 7,  * FROM SYSREMOTEUSER;       --              SQL Remote *
SELECT 8,  * FROM SYSSUBSCRIPTION;     --              SQL Remote 
SELECT 9,  * FROM SYSSYNC;             -- MobiLink **
SELECT 10, * FROM SYSSYNCPROFILE;      -- MobiLink
SELECT 11, * FROM SYSSYNCSCRIPT;       -- MobiLink
-- * rows exist if and only if SQL Remote is in use.
-- ** rows exist if and only if MobiLink is in use.


Original question...

Sometimes it's just easier to ask forgiveness for asking a question than to reverse-engineer.

The SYSPUBLICATION.type column contains an 'R' but that column has been marked "deprecated" since it first appeared in the V8 docs... all the way through to V17 :)

asked 06 Aug '15, 09:01

Breck%20Carter's gravatar image

Breck Carter
26.9k438609883
accept rate: 21%

edited 10 Aug '15, 10:37


I'd look into SYSREMOTEUSER vs. SYSSYNC...

permanent link

answered 06 Aug '15, 09:41

Volker%20Barth's gravatar image

Volker Barth
31.3k312458674
accept rate: 33%

converted 06 Aug '15, 12:27

Nick%20Elson%20SAP%20SQL%20Anywhere's gravatar image

Nick Elson S...
7.3k35107

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×298
×78

question asked: 06 Aug '15, 09:01

question was seen: 365 times

last updated: 10 Aug '15, 10:37