Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.

I set the script version with script:

ALTER SYNCHRONIZATION SUBSCRIPTION uploadtope
SET SCRIPT VERSION = 'vup_1';

Is there a sql script to retrieve the script version?

asked 08 Dec '20, 01:57

ontsnapt's gravatar image

ontsnapt
125121218
accept rate: 0%

It's unclear to me exactly what you are asking. Both Chris and I have provided responses that answer the question correctly, but make different assumptions on what you are asking. If we haven't answered your question, please clarify your question.

(08 Dec '20, 08:56) Reg Domaratzki

The SQL that Chris provided is used at the consolidated database, and will let you know what script versions are defined, allowing you to verify that when you synchronize a remote database to this consolidated database, that the 'vup_1' script version exists at the consolidated database.

If you would like to know which script version a remote database will use when you synchronize the synchronization subscription named 'uploadtope', you would execute the following SQL on the remote database :

select script_version from SYS.SYSSYNC where subscription_name = 'uploadtope';

Reg

permanent link

answered 08 Dec '20, 08:54

Reg%20Domaratzki's gravatar image

Reg Domaratzki
7.9k343119
accept rate: 36%

edited 08 Dec '20, 09:01

This information is in the MobiLink system table ML_SCRIPT_VERSION.

i.e., select NAME from ML_SCRIPT_VERSION

permanent link

answered 08 Dec '20, 07:14

Chris%20Keating's gravatar image

Chris Keating
8.0k50131
accept rate: 32%

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:

×371

question asked: 08 Dec '20, 01:57

question was seen: 2,445 times

last updated: 08 Dec '20, 09:01