[teiid-issues] [JBoss JIRA] (TEIID-4289) Add transaction command support for syntax BEGIN/ROLLBACK/COMMIT WORK

[Steven Hawkins (JIRA)]

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

Steven Hawkins commented on TEIID-4289:
---------------------------------------

In procedures we support
BEGIN ATOMIC

For JDBC we support 
START TRANSACTION
COMMIT
ROLLBACK

For PG we additionally support
BEGIN

In which usage context is this a request for and is it just for the work keyword or is is also for the transaction keyword and/or additional transaction options?

> Add transaction command support for syntax BEGIN/ROLLBACK/COMMIT WORK
> ---------------------------------------------------------------------
>
>                 Key: TEIID-4289
>                 URL: https://issues.jboss.org/browse/TEIID-4289
>             Project: Teiid
>          Issue Type: Feature Request
>    Affects Versions: 8.7.6.6_2
>            Reporter: Marc Shirley
>            Assignee: Steven Hawkins
>
> This request appears to be an expansion of TEIID-1701 to add syntax like the below as an alias for transactional commands.  This would be in line to make commands portable from other vendor DBs such as PostgreSQL/SQL Server/DB2/MySQL.
> BEGIN WORK
> ROLLBACK WORK
> COMMIT WORK



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)