[teiid-issues] [JBoss JIRA] Commented: (TEIID-1700) Move odbc cursor logic to engine

[Steven Hawkins (JIRA)]

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

Steven Hawkins commented on TEIID-1700:
---------------------------------------

Trying to merge the PG statement vs. embedded SQL cursors is a little tricky.  The PG statement usage does not require an open statement,  allows for bulk fetch/move (FORWARD/BACKWARD n), and fetch does not use an into clause.  Creating the different usage rules is a validation/documentation burden.  So we'll also have general support for the bulk fetch operations, but only on resolved cursors where the schema is known.  Also, I think we'll leave statement level cursors undocumented.

> Move odbc cursor logic to engine
> --------------------------------
>
>                 Key: TEIID-1700
>                 URL: https://issues.jboss.org/browse/TEIID-1700
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Query Engine
>    Affects Versions: 8.0
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 8.0
>
>
> ODBC added support for declared cursors, which would be a good general/procedure language feature.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira