[teiid-issues] [JBoss JIRA] (TEIID-5725) Please improve documentation on definition of stored procedures, virtual functions and virtual procedures
Christoph John (Jira)
issues at jboss.org
Tue Apr 23 15:25:00 EDT 2019
[ https://issues.jboss.org/browse/TEIID-5725?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13725692#comment-13725692 ]
Christoph John commented on TEIID-5725:
---------------------------------------
Hello together, I have another question which I could not solve with the docs yet. Probably a stupied question but I am searching for a solution for a while and do not want to use multiple selects.
As Steven already mentioned SELECT INTO only allows for selection into tables. My question is how can I select into multiple variables in a single select statement. I mean equivalent to
DECLARE INTEGER a,b;
SELECT a := table.a, b:= table.b FROM table WHERE table. c = 0;
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)
More information about the teiid-issues
mailing list