[teiid-issues] [JBoss JIRA] (TEIID-1131) Document/expand sequence support

[ https://issues.jboss.org/browse/TEIID-1131?page=com.atlassian.jira.plugin... ] Steven Hawkins edited comment on TEIID-1131 at 3/3/12 7:18 AM: --------------------------------------------------------------- For oracle inserts if a table has an autoincrement column with a name in source of columnname:SEQUENCE=sequencename.val, then we'll use the sequence value in the insert submitted to Oracle if no value has been set for that column. For any other sequence usage you'd have to model the sequence as a UDF or procedure depending on how you need to call it and whether you need the value to be inlined or obtained from a separate statement. was (Author: shawkins): For oracle inserts if a table has an autoincrement column with a name in source of :SEQUENCE=sequencename.val, then we'll use the sequence value in the insert submitted to Oracle if no value has been set for that column. For any other sequence usage you'd have to model the sequence as a UDF or procedure depending on how you need to call it and whether you need the value to be inlined or obtained from a separate statement. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira