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

SQL Anywhere Procedures/Functions language

Former Member
12,003

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

To complete the picture:

I guess your question is focused on stored functions and procedures in SQL, and that's what the answers explain.

But you can also write (or re-use) stored procedures and functions in other programming languages and create an SQL interface for them. This includes

  • C/C++ via Embedded SQL/ODBC
  • CLR (aka Dot.Net)
  • Java
  • Perl
  • PHP

If this is your intention, have a look at the CREATE PROCEDURE statement for external procedures.

Breck_Carter
Participant
0 Likes

I was wondering when someone was going to mention all the other languages 🙂

VolkerBarth
Contributor
0 Likes

@Breck: Are you saying I have insulted the general "Stealth marketing" rule? I feel ashamed:)

Former Member
0 Likes

Any suggestions on how to get started writing procedures/functions?