Need a support for MERGE for JDBC update activity
Article ID: KB0087367
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.
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
Feedback
Yes
No
Powered by
