HANA SQL- Internal Table Operation- 6

light111Use 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-



Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s