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

We've recently had to transition a DB to being hosted by our provider, instead of on-prem. With that, they've given us read-only access to the database to continue utilizing local scripts for pulling data.

Unfortunately, I've realized a few scripts of ours utilized custom functions that had been added to Sybase.

With read-only access, I can't add these functions to the remote database.

I'm trying to find another option, for example - installing functions locally with a way to execute them on the remote server.

I'm at a loss with this though, and am looking for any possible guidance.

Also - I've requested the functions be added, but I feel that is pretty unlikely.

asked 03 Jul '20, 16:44

JWise93's gravatar image

JWise93
51237
accept rate: 0%


I do not know whether I have understood your situation and requirements - so just FWIW, you can create temporary functions and temporary procedures with SQL Anywhere, and the docs state

Temporary stored procedures can be created and dropped when connected to a read-only database,...

Note, these are only visible for the current connection.

This may or may not be of help here.

permanent link

answered 03 Jul '20, 17:05

Volker%20Barth's gravatar image

Volker Barth
40.4k365554826
accept rate: 34%

converted 03 Jul '20, 17:41

2

That's perfect - I didn't realize that temporary functions could be utilized on a read-only database.

Thanks for your help!

(03 Jul '20, 17:31) JWise93
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:

×24

question asked: 03 Jul '20, 16:44

question was seen: 716 times

last updated: 03 Jul '20, 17:31