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

Sai krishna
edited February 11, 2022 in Analytics #1

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.

Warning No formatter is installed for the format ipb

Comments

  • I don't believe this question is related to BIRT. It is possible that you will get an answer here, but you would be better served posting it to the database forum.

    Warning No formatter is installed for the format ipb