This came out of : https://answers.launchpad.net/trafodion/+question/253796
"select syskey from (insert into parts values(?,?,?)) x" does not work as expected with a odbc rowset. A rowset with single row works, but with multiple rows in the rowset, no rows get inserted.
The workaround is to execute the select after the insert rowset operation.
It also fails with jdbc batch, t4 driver throws a "select not supported in batch" exception.