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

[Christoph John (Jira)]

    [ https://issues.jboss.org/browse/TEIID-5725?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13725011#comment-13725011 ] 

Christoph John commented on TEIID-5725:
---------------------------------------

Hello Steven,
thanks for the answer.

>> There are two aspects here, one is if there is documentation for the base (non-odata) case. And the other is what is documented with regards to odata.

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.

>> There is no concept of an OUT or INOUT parameter in OData. There is only IN and RETURN. A result set returned from a procedure is mapped to a complex return value.

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?

>>  I'll update this page to use a table of contents and unfortunately it does not explicitly show the usage of a RETURN statement
Yes having a return statement in the examples for a virtual procedure and function has helped

>> A result set is mapped automatically to a complex type collection result. A array result will be mapped to a simple type collection.

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.





> Please improve documentation on definition of stored procedures, virtual functions and virtual procedures
> ---------------------------------------------------------------------------------------------------------
>
>                 Key: TEIID-5725
>                 URL: https://issues.jboss.org/browse/TEIID-5725
>             Project: Teiid
>          Issue Type: Enhancement
>            Reporter: Christoph John
>            Assignee: Steven Hawkins
>            Priority: Critical
>
> I refer to the discussion with Ramesh in 
> https://developer.jboss.org/message/989048#989048 and would like to ask for a more detailed explanation on how to write virtual procedures and functions. 
> -Especially, how are OUT and INOUT params set and how can they be obtained via odata. 
> - How is the return value of a virtual function set?
> - How are collections and arrays of collections returned?



--
This message was sent by Atlassian Jira
(v7.12.1#712002)