I want to use directly within SQL Stored Procedure some data from external sources.

Types of external/remote data sources I mean:

  1. other Sybase databases (the same SQL Anywhere engine version, but different server)
  2. other database engines (including but not limited to MySQL, MS SQL Server)
  3. data returned from desktop applications and scripts
  4. data returned from URLs
  5. data from local text files
  6. use programming languages libraries

I'm using the Sybase SQL Anywhere 9 and 12 databases.

What from the list above is possible in them?

How to handle this?

asked 28 Dec '13, 17:50

BlueMark's gravatar image

BlueMark
246101624
accept rate: 50%


1, 2 and 5 can possibly be done via "remote data access" also known as proxy tables... 5 can possibly also be done via LOAD TABLE.

4 can possibly be done via web client procedures.

3 and 6 are too vague to even guess at.

permanent link

answered 28 Dec '13, 20:46

Breck%20Carter's gravatar image

Breck Carter
26.9k438609883
accept rate: 21%

1

Some further hints:

4 - web client procedures require SQL Anywhere 9.0.2 and above

For 3 and 6 we would need much more information about what kind of data you are thinking of. For example, it's surely possible to import all kinds of data in binary, text, XML format, say by the OPENSTRING clause of the SELECT statement, available with v11 and above, or by the openxml() system function...

(30 Dec '13, 03:18) Volker Barth
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:

×414
×106
×101
×26
×22

question asked: 28 Dec '13, 17:50

question was seen: 713 times

last updated: 30 Dec '13, 03:23