Need a support for MERGE for JDBC update activity

Need a support for MERGE for JDBC update activity

book

Article ID: KB0087367

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix BusinessWorks -
Not Applicable -

Description

Resolution:
The "merge" statement is specific to Oracle and in BW we normally do not support features specific to database vendors

Here are a couple of workarounds which you can use in your process:

- Create a Stored Procedure to perform the MERGE statement, and then use JDBC Call activity to invoke this Stored Procedure.
-  Use SQL Direct activity.

Issue/Introduction

Need a support for MERGE for JDBC update activity
Powered by Wolken Software