Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

The database server (dbsrv12) starts 20 databases.

We create a service (CREATE SERVICE ws_getAnimalData TYPE 'XML' AUTHORIZATION OFF USER DBA AS SELECT..).

How can we retrieve the data from the correct databasefile?

asked 15 Dec '17, 01:28

ontsnapt's gravatar image

ontsnapt
125121218
accept rate: 0%


AFAIK, there are several methods, depending on whether the database server uses one port for all databases or different ports for each database (or a combination):

  1. You can use different ports for each database by using -xs with several http options, such as this one taken from the docs - in that case the client has to use the according port and thereby specifies the desired database:

    dbsrv17 -xs http(PORT=80;DBN=your-first-database),http(PORT=8800;DBN=your-second-database) your-first-database.db your-second-database.db

  2. You can use the same port and include the database name in the URL the client specifies, as described here. In that case the "-xs http" option should include "DBN=REQUIRED".

Note that in both cases the according web service definition has to be created in each database, as web service definitions are parts of the database, not the database server. So in your case the CREATE SERVICE statement needs to be run in each database.

permanent link

answered 15 Dec '17, 04:09

Volker%20Barth's gravatar image

Volker Barth
40.2k361550822
accept rate: 34%

edited 15 Dec '17, 04:15

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:

×65

question asked: 15 Dec '17, 01:28

question was seen: 1,111 times

last updated: 15 Dec '17, 04:15