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? |
SQL Anywhere supports two dialects of stored procedures:
The WATCOM SQL dialect closely resembles the ISO/ANSI SQL/2008 standard. 1
@Mark: Am I right to notice some kind of bias in favour of the first dialect in your description? If so, I would fully agree:) - And I am sure Watcom SQL seems much more familiar to those with experience in common programming languages... 1
I vote "Watcom SQL"... 99.9% of Foxhound is written in it, including the enire GUI. Comment Text Removed
1
My preference is Watcom SQL, but users that are familiar with ASE or MS SQL may be more comfortable using the TSQL dialect. @Mark: By the way, are there any iAnywhere staff members who have been involved with the development of the Watcom compiler products? (Yep, call me curios.) @Volker: Yes, there are still a few. @Mark: Hmm, you can bet the curiosity isn't really satisfied, I was looking for names... - I guess us users here do not only share a admiration for you SQL heroes, there's place for compiler gurus, too:) 1
@Volker: I am a little reluctant to name others without their permission. I will say that I know of at least six staff that worked on the Watcom compilers/interpreters and (trying not to give away too much info) some of them are users on this forum. I'll leave it as an exercise to the reader to figure out who. Note: I am not one of them. @Mark: I fully appreciate your point of view, as it really would be unfair to tell about other persons's CV. (And yes, as a typical German citizen, I do care much about privacy - cf. the German Google StreetView debate...) - Besides that, I do have some suspicions:) More comments hidden
|
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
If this is your intention, have a look at the CREATE PROCEDURE statement for external procedures. I was wondering when someone was going to mention all the other languages :) @Breck: Are you saying I have insulted the general "Stealth marketing" rule? I feel ashamed:) Any suggestions on how to get started writing procedures/functions? Comment Text Removed
|