temp table in upsert functionNot planned
I was trying to use a temp table as source in the upsert function. It didn't work. Would be great to get this feature.
Comment actionsOfficial comment
thanks for posting this request to our Data Virtuality Community.
Right now we are working on a self service web based information tool that will be released within the next major version (2.1) and we are not planning to support temp tables in the Upsert procedure in the near future.
However, the Upsert procedure is written in SQL and our solution engineers can provide you a template and show you how to write a similar custom procedure that supports temp tables.
Please sign in to leave a comment.