Heterogeneous Select statement

#1

I'm using ASA 9.

I'd like to do the following, and would like an example of
how to name each database:

SELECT INTO "ARCHIVE_DB"."Table"
FROM "LIVE_DB"."Table"
WHERE My_Criteria

#2

You need to use proxy tables to accomplish what you want. See the
section on Remote Data Access in the documentation.

Karim
S. Male wrote:

Quote:

I'm using ASA 9.

I'd like to do the following, and would like an example of
how to name each database:

SELECT INTO "ARCHIVE_DB"."Table"
FROM "LIVE_DB"."Table"
WHERE My_Criteria

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Heterogeneous Select statement

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general

Heterogeneous Select statement - 01-27-2010 , 10:50 AM

Re: Heterogeneous Select statement - 01-27-2010 , 12:13 PM