|
Home > Archive > SQL Anywhere database > May 2005 > Send SQL statement, or run stored procedure in remote server?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Send SQL statement, or run stored procedure in remote server?
|
|
| Edgard L. Riba 2005-05-30, 1:23 pm |
| Hi,
Using ASA 9.
Is it possible to run a SQL statement in a remote server? Or is it
possible to run a stored procedure with parameters?
I know you can create proxy tables, but I was wondering if it was possible
to the above...
Thanks,
Edgard
| |
| Reg Domaratzki \(iAnywhere Solutions\) 2005-05-30, 1:23 pm |
| See the documentation on the FORWARD TO statement.
ASA SQL Reference
SQL Statements
FORWARD TO statement
--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup
iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL
"Edgard L. Riba" <elriba at rimith dot com> wrote in message
news:429b5c5e@forums
-1-dub...
> Hi,
>
> Using ASA 9.
>
> Is it possible to run a SQL statement in a remote server? Or is it
> possible to run a stored procedure with parameters?
>
> I know you can create proxy tables, but I was wondering if it was possible
> to the above...
>
> Thanks,
> Edgard
>
>
| |
| Breck Carter [TeamSybase] 2005-05-31, 7:23 am |
| You can also have a proxy procedure; CREATE PROCEDURE has an AT
clause.
Breck
On 30 May 2005 11:33:02 -0700, "Edgard L. Riba" <elriba at rimith dot
com> wrote:
>Hi,
>
>Using ASA 9.
>
>Is it possible to run a SQL statement in a remote server? Or is it
>possible to run a stored procedure with parameters?
>
>I know you can create proxy tables, but I was wondering if it was possible
>to the above...
>
>Thanks,
>Edgard
>
--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
|
|
|
|
|