[teiid-issues] [JBoss JIRA] (TEIID-4524) Add support for Microsoft SQL Server Sequences to the translator

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-4524?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins updated TEIID-4524:
----------------------------------
    Component/s: JDBC Connector


If there is no objection, this will be resolved as a documentation issue.  The same recommendation for oracle will be made for SQL Server, that is use a function:

CREATE FOREIGN FUNCTION seq_nextval () returns integer OPTIONS ("teiid_rel:native-query" 'NEXT VALUE FOR seq');


> Add support for Microsoft SQL Server Sequences to the translator
> ----------------------------------------------------------------
>
>                 Key: TEIID-4524
>                 URL: https://issues.jboss.org/browse/TEIID-4524
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: JDBC Connector
>            Reporter: Debbie Steigner
>            Assignee: Steven Hawkins
>
> As of Microsoft SQL Server 2012 - https://msdn.microsoft.com/en-us/library/ff878058%28v=sql.110%29.aspx they have SEQUENCE like Oracle.  Can the Microsoft SQL Server translator be changed to handle it the same or similar to the way we handle the Oracle SEQUENCE?



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