[
https://issues.jboss.org/browse/TEIID-5725?page=com.atlassian.jira.plugin...
]
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)