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.

Thanks & Regards,
Sai

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.

    Jeff F.
    Customer Support Engineer I
    OpenText
Sign In or Register to comment.