ibm midrange - Trying to delete extra records created by web app development platform using SQL object -

ibm midrange - Trying to delete extra records created by web app development platform using SQL object -

i've tried many sql statements , failed every time. want have sql object kick off after records written file , rid of records concatenation of jobno || batchno not equal jobnofull

jobnofull jobno batchno lf00698 14295001 lf00698 14295001 (keep these records) lf00698 14295001 lf00698 pkg1 14295001 (delete these records) lf00698 14295001 lf00698 pkg2 14295001 (delete these records)

any ideas?

see sql statement create trigger create trigger executes code when row added table.

sql ibm-midrange