0
votes
1answer
31 views
Procedure default parameters
-- Not sure if this a bug, or a lack of understanding on my part... but I want to use a DEFAULT value of NULL on a stored procedure parm, and SQLA returns a value of 0 when I would …
3
votes
2answers
162 views
Does parameter passing degrade stored procedure performance?
I've got a complicated calculation that involves several lines of my stored procedure. This is in several places throughout the stored procedure. So I'd like to encapsulate it, u …
4
votes
1answer
150 views
How does SQL Anywhere pass parameters?
Per Breck's suggestions, I am adding another question directly about how SQLA passes parameters. In the past couple years the question has come up several times when trying to mov …
4
votes
1answer
41 views
Product Suggestion: Please implement record variable type
I'd like to see records added to the stored procedure language of SQA. One of the biggest complaints from my developers when moving code from Oracle to SQLA is the lack of records …