HANA SQL- Internal Table Operation- 6

Use of EXCEPT in HANA SQL Script with Internal Table

---

EXCEPT use is quite simple. Its like a minus operation. The result of EXCEPT operation is the record set that present in first and not present in the second.

Below one internal table contains all the records of a client present in DB and another internal table contains few records. 

The AMDP method with EXCEPT operation between two internal tables.

Program/Report to test the AMDP method.

Debug Details-

Result table of the EXCEPT operation-

First Table record details-

---