[teiid-issues] [JBoss JIRA] (TEIID-2614) Allow anonymous procedure blocks

[Ramesh Reddy (JIRA)]

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

Ramesh Reddy commented on TEIID-2614:
-------------------------------------

Steve, Can I execute like?

{code}
select x.* from (execute (begin select 1; end) as x
{code}
                
> Allow anonymous procedure blocks
> --------------------------------
>
>                 Key: TEIID-2614
>                 URL: https://issues.jboss.org/browse/TEIID-2614
>             Project: Teiid
>          Issue Type: Enhancement
>          Components: Query Engine
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 8.5
>
>
> In some cases it is beneficial to submit a block of sql for processing rather than performing partial result processing in the client.
> Given that we are effectively using anon blocks internally, we should expose this feature for general use.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira