The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

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.6k418576824
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
29.3k287438645
accept rate: 32%

converted 06 Aug '15, 12:27

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

Nick Elson S...
6.2k2890

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:

×266
×73

question asked: 06 Aug '15, 09:01

question was seen: 243 times

last updated: 10 Aug '15, 10:37