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.

0

Program/Report to test the AMDP method.

4

Debug Details-

1

Result table of the EXCEPT operation-

2

First Table record details-

3


 

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 )

Google photo

You are commenting using your Google 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