I have table 'A' in schema 'USER'. There are three columns in this table. below are the names of the columns:
- id (primary key)
- name
- age
I want to insert a row in this table, but if the row is already present (with same id) then the name and age should be updated instead of giving error sqlcode -803.
Is there any way to do this in a single query?