SQL Anywhere Feedback - Enhanced remote procedure support

Author

Enhanced remote procedure support

Russell Fleming

2005-08-15, 8:23 pm

The supported data types for a stored procedure should not vary whether or
not if the execution is in a local or remote server.

Glenn Paulley

2005-08-16, 1:25 pm

"Russell Fleming" <russ.fleming@gmail.com> wrote in
news:4300e93e$1@foru
ms-2-dub:

> The supported data types for a stored procedure should not vary
> whether or not if the execution is in a local or remote server.
>
>

Can you give me some additional details so that I can do some
investigation?

Is the remote server in your case another ASA server, or something else?

Can you post a particular procedure that illustrates your problem?

Thanks

Glenn

--
Glenn Paulley
Research and Development Manager, Query Processing
iAnywhere Solutions Engineering

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Breck Carter [TeamSybase]

2005-08-16, 1:25 pm

He may be referring to this list of allowed data types; note that
TIMESTAMP, DATE, LONG VARCHAR, etc, are missing:

=====
ASA SQL User's Guide

Accessing Remote Data

Using remote procedure calls (RPCs)

Creating remote procedures
....
Data types for remote procedures
The following data types are allowed for RPC parameters. Other data
types are disallowed:

[ UNSIGNED ] SMALLINT

[ UNSIGNED ] INT

[ UNSIGNED ] BIGINT

TINYINT

REAL

DOUBLE

CHAR

BIT

NUMERIC and DECIMAL data types are allowed for IN parameters, but not
for OUT or INOUT parameters.
=====

Breck

On 16 Aug 2005 06:51:53 -0700, Glenn Paulley <paulley@ianywhere.com>
wrote:

>"Russell Fleming" <russ.fleming@gmail.com> wrote in
> news:4300e93e$1@foru
ms-2-dub:
>
>
>Can you give me some additional details so that I can do some
>investigation?
>
>Is the remote server in your case another ASA server, or something else?
>
>Can you post a particular procedure that illustrates your problem?
>
>Thanks
>
>Glenn

--
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

Russell Fleming

2005-08-16, 1:25 pm

Considering that all my servers are ASA it doesn't seem justifiable that
since some data types are disallowed a valid stored procedure can only be
executed locally.

"Breck Carter [TeamSybase]" < NOSPAM__bcarter@risi
ngroad.com> wrote in
message news:lbu3g19bq0ahbhd
ea1eip7snb1mhq441ad@
4ax.com...
> He may be referring to this list of allowed data types; note that
> TIMESTAMP, DATE, LONG VARCHAR, etc, are missing:
>
> =====
> ASA SQL User's Guide
>
> Accessing Remote Data
>
> Using remote procedure calls (RPCs)
>
> Creating remote procedures
> ...
> Data types for remote procedures
> The following data types are allowed for RPC parameters. Other data
> types are disallowed:
>
> [ UNSIGNED ] SMALLINT
>
> [ UNSIGNED ] INT
>
> [ UNSIGNED ] BIGINT
>
> TINYINT
>
> REAL
>
> DOUBLE
>
> CHAR
>
> BIT
>
> NUMERIC and DECIMAL data types are allowed for IN parameters, but not
> for OUT or INOUT parameters.
> =====
>
> Breck
>
> On 16 Aug 2005 06:51:53 -0700, Glenn Paulley <paulley@ianywhere.com>
> wrote:
>
>
> --
> 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

Breck Carter [TeamSybase]

2005-08-16, 1:25 pm

I agree. As far as I can tell sa_disk_free_space can't be called
because it has a varchar parameter.

Breck

On 16 Aug 2005 07:53:16 -0700, "Russell Fleming"
<russ.fleming@gmail.com> wrote:

>Considering that all my servers are ASA it doesn't seem justifiable that
>since some data types are disallowed a valid stored procedure can only be
>executed locally.
>
>"Breck Carter [TeamSybase]" < NOSPAM__bcarter@risi
ngroad.com> wrote in
>message news:lbu3g19bq0ahbhd
ea1eip7snb1mhq441ad@
4ax.com...
>http://www.amazon.com/exec/obidos/A...7/risingroad-20
>

--
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

Sponsored Links