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.

Using SQL Anywhere

Setting up ODSL model the documentation indicates that without a model, all tables and views with primary keys are exposed.

If I setup a model and only include the statement for a service

service namespace "OBabyService" {
serviceop get "tso"."WebAData" returns multiplicity "*";

I would expect to only expose this service. In practice though, this exposes all tables and views with primary keys and in addition this service.

Right now I am using a dummy table as an entity entry to avoid this, but are there other ways to accomplish this goal?

Also, are there any more flexible ways to handle the ODSL service model, such as all procedures owned by X user?

asked 25 May '17, 17:14

Siger%20Matt's gravatar image

Siger Matt
accept rate: 15%

edited 25 May '17, 17:16

We did not anticipate the scenario that someone would only want to expose service operations. As a work around, you can create a user that has execute permissions on the service operation and access to no tables.

We will investigate adding support for this in the future.

Unfortunately, we cannot determine the multiplicity of all procedures and, as documented, there are some kinds of stored procedures we cannot handle. Therefore we cannot expose automatically all procedures owned by a given user.

permanent link

answered 26 May '17, 10:40

PhilippeBertrand%20_SAP_'s gravatar image

accept rate: 22%

edited 26 May '17, 15:14

Your answer
toggle preview

Follow this question

By Email:

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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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:


question asked: 25 May '17, 17:14

question was seen: 1,837 times

last updated: 26 May '17, 15:14