On April 27, 2024, our Sign-in and Create Account options will be unavailable from 9am-12pm ET. During this maintenance window, developer account access and free trial registration will be unavailable.

How to use UPSERT in Actuate birt to modify the Database using prompts

Hello Team,

Good morning!

I am trying to call the sql function which contains the 'UPSERT' which means - "if given input exits then do Update else Insert". This is because I have a request that using the prompt values we have to update the Database using BIRT report.
At present I am getting issue with 'UPSERT' I am failing with this concept. Could anyone of you please tell me how to write the Logic code for Upsert in pgplsql. So then I can call the database and update the database using the birt report parameter values. Thanks in advance.