[teiid-issues] [JBoss JIRA] (TEIID-5725) Please improve documentation on definition of stored procedures, virtual functions and virtual procedures

[ https://issues.jboss.org/browse/TEIID-5725?page=com.atlassian.jira.plugin... ] Christoph John commented on TEIID-5725: --------------------------------------- Hello Steven, thanks for the answer. The fact that there is a difference between an odata and non-odata case did not become clear for me from the documentation. Maybe this could be explained together with the differences. So I assume this is the difference, if I want to export the functions as ODATA I am not allowed to use OUT or INOUT? Yes having a return statement in the examples for a virtual procedure and function has helped Not sure what this means. I will try out what hapens if I return an array of collection items -> did you mean this by multidimensional? I am currently trying to get some functions implemented in DDL. It looks like I have quite some trouble with the syntax. So what kind of SQL version is used here? Could you recommend a tutorial on it? For example I expected this to work: DECLARE retVal INTEGER DEFAULT 1; However, looks like the correct syntax looks like this: DECLARE INTEGER retVal = 1; And I tried using count and select into, like follows: SELECT COUNT(Weekday) INTO retVal FROM NutritionGoal WHERE fkProfile = 2; but the statement does not work as probably the syntax is also wrong in Teiid. It would be great if you could provide a link to a tutorial for the relevant sql version that Teiid is using in DDL and add a info to the documentation as well. Thanks for your help. -- This message was sent by Atlassian Jira (v7.12.1#712002)