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