cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

SQL Anywhere Procedures/Functions language

Former Member
12,006

Been an analyst using SQL Anywhere for a few years and just getting into database management. Regarding writing/developing procedures/functions, is there a particuliar programming language that is used or patterned after?

View Entire Topic
MCMartin
Participant

It doesn't really matter if you prefer watcom or T-SQL because you can translate the code from watcom to T-SQL and vice versa inside the Sybase Central

VolkerBarth
Contributor
0 Likes

...though there are advanced cases of Watcom SQL code that cannot be converted to T-SQL (and possibly vice versa).

Former Member
0 Likes

I've discovered you can't mix these two constructions in the same stored procedure (no matter how many lines apart they are) ...select <calculation> as VariableName1... and ...select VariableName2 = <calculation>... (disclaimer: I only know up to version 10.0.1)