CODEWITHSUNDEEP
sqlibm-midrange
EJOLRO
EJOLRO

Reputation: 11

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

I've tried many SQL statements and failed every time. I want to have an SQL object kick off after the records are written to the file and get rid of the records where the concatenation of JOBNO || BATCHNO is not equal to the 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?

Upvotes: 1

Views: 51

Answers (1)

Buck Calabro
Buck Calabro

Reputation: 7648

See the SQL statement CREATE TRIGGER This will create a trigger that executes your code when a row is added to the table.

Upvotes: 1

Related Questions