DELETE records from Database with WHERE Clause and then INSERT records
There can be situation when you have to delete records (delete all records from table) and then Insert records, this is possible and easy and there are many Blogs and discussions on this.
Now if a situation comes and you have to delete only particular records with where clause and then Insert records in table, then is it possible? Can you write DELETE query in Message Mapping with where clause? Let’s see the solution below.
Following design needs to be done to make this happen.
Create JDBC Receiver Data Type Structure like below-
Explanation for Message Mapping:
Statement1 is for DELETE Query
Key1 –> LastName will be used for WHERE condition
The corresponding SQL statement for Statement1 in the example above is as follows:
DELETE FROM dbTableName WHERE (LastName = ‘Kumar’)
Using above design, particulars rows in table dbTableName will be deleted where LastName is Kumar.
We cannot write DELETE query with where condition in action that is the reason Key1 is used.
Statement2 is for INSERT Query
This feature available from long back right .We often use this .Any thing new ???
I just want to understand am I missing some thing.
Yes you are correct this feature is available from long back. This blog is for those who will try to use this feature first time.
Some of my friends asked about this kind of feature so I thought to write a blog on this.
Thank you for this. I just started with SAP PI/PO and find this very useful.