IFB to delete all records from S_ORG_EXT table that were created on the previous day

Presently I came across one of my friend's requirement for an IFB to delete all records from S_ORG_EXT table that were created on the previous day and with value of SRV_PROVDR_FLG as Y, so that IFB can be scheduled to run on a particular interval and delete process can be automated.

Here, I am sharing it with you guys and you can make use of it on any table and for deleting records in any time period just by changing the parameters given, as per your requirement.

Delete Process Parameters in IFB

These are the parameters which are only applicable to EIM Delete process and are written with in the Process section in an IFB file used for delete process. They are :-

CASCADE DELETE ONLY

• Optional parameter that tells whether to delete the child records when a parent record is deleted.
• Valid values are TRUE or FALSE.
• Default value is FALSE.
• If set to FALSE, EIM deletes the parent record and sets the foreign key column in the child records to NULL.
• Example: CASCADE DELETE ONLY = TRUE