[TRAFODION-3207] Add SQL syntax to allow user to retrieve the current transaction identifier

• Type: Wish
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 2.4
• Component/s: sql-exe
• Assignee: Sandhya Sundaresan
• Reporter: Sean Broeder
• Created: 14/Sep/18 18:06
• Updated: 14/Sep/18 18:06

Description

I would like to enhance SQL so that the current transaction could be retrieved and displayed as a long int that could be used in DML statements.

2 use cases come to mind:

> insert into t values (rowkey, current_transid, <...>);

or

> get transid;