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.

Hi,

I have created a remote server in ASA 9, and all seems fine with the connection.

But How do I query this remote server?

sp_remote_tables PSCRM

shows me a list of all the tables, but how do I query an individual table? I have tried various combinations but everythings throws up an error.

asked 09 Nov '15, 07:42

Jongee's gravatar image

Jongee
217171722
accept rate: 0%


You will usually create a so-called proxy table for each remote table/view you want to access, cf. that doc topic Creating proxy tables (SQL) .

Furthermore, you can "directly" access remote tables by using the FORWARD TO statement - but then you are not able to easily connect local and remote data.

Please note that both links go to the v12.0.1 doc set but should apply to ASA 9 as well.

permanent link

answered 09 Nov '15, 08:22

Volker%20Barth's gravatar image

Volker Barth
40.2k361550822
accept rate: 34%

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:

×108
×56

question asked: 09 Nov '15, 07:42

question was seen: 1,942 times

last updated: 09 Nov '15, 08:22