Sybase for Servoy?

Classic Servoy
1

What is the exact version of Sybase that comes with Servoy?

I believe is SQL Anywhere version 9?

Sybases web site says it supports stored procedures. Does this includes support for Transact SQL? If so, how do you directly access the database for the purpose of writing triggers and manipulating other database specific features?

Thanks,
Lee Snover

2

leesnover:
Does this includes support for Transact SQL?

It should include Sybases’ version of Transact SQL which is slightly different from Microsofts.

After struggling with the Sybase and the bulky documentation, I decided to go for PostgreSQL instead, using PL/pgSQL.

3

swingman:

leesnover:
Does this includes support for Transact SQL?

It should include Sybases’ version of Transact SQL which is slightly different from Microsofts.

After struggling with the Sybase and the bulky documentation, I decided to go for PostgreSQL instead, using PL/pgSQL.

That would be great, but what do you use to access and edit the stored procs?

Transact SQL is OK, not as nice as PL/SQL for Oracle, but I wanted to at least evaluate this Sybase version as it is included with Servoy and would reduce costs if we go this route.

I’m not familiar wiht PostgresSQL. Is PL/pgSQL a clone of PL/SQL?

Regards,
Lee Snover

4

leesnover:
I’m not familiar wiht PostgresSQL. Is PL/pgSQL a clone of PL/SQL?

PostgreSQL Documentation:
PL/pgSQL is similar to PL/SQL in many aspects. It is a block-structured, imperative language, and
all variables have to be declared. Assignments, loops, conditionals are similar. The main differences
you should keep in mind when porting from PL/SQL to PL/pgSQL are:
There are no default values for parameters in PostgreSQL.
You can overload function names in PostgreSQL. This is often used to work around the lack of
default parameters.
No need for cursors in PL/pgSQL, just put the query in the FOR statement. (See Example 35-5.)
In PostgreSQL you need to use dollar quoting or escape single quotes in the function body. See
Section 35.2.1.
Instead of packages, use schemas to organize your functions into groups.
Since there are no packages, there are no package-level variables either. This is somewhat annoying.
You may be able to keep per-session state in temporary tables, instead.

5

leesnover:
That would be great, but what do you use to access and edit the stored procs?

Transact SQL is OK, not as nice as PL/SQL for Oracle, but I wanted to at least evaluate this Sybase version as it is included with Servoy and would reduce costs if we go this route.

Servoy ships with iAnywhere 9.0.1 which has support for Transact SQL built-in. Additionally you can run java inside the database.

You can edit your stored procs with Sybase Central that you can download as part of iAnywhere Studion from www.ianywhere.com

6

Hi,

SQL Anywhere Studio offers type styles of stored procedures.

  • Watcom SQL - based on a draft ANSI standard
  • TSQL
  • Java

Check out http://www.ianywhere.com/developer/prod … index.html

The Users’ Guide and Programmer’s Guide are key guides to finding information on stored procedures.