HANA SQL- Internal Table Operation- 7

light111Clear Internal Table in HANA SQL Script


In ABAP method generally in many instances, it is required to clear / refresh the internal table with CLEAR/ REFRESH statement but in HANA SQL SCRIPT  these statements don;t work and the below post shows how to make clear an internal table.

Suppose an internal table have some records and you want to clear this internal table as a part of the processing.

A simple SELECT statement with NULL entry for each column from dummy makes the internal table clear.

Below is an AMDP Method- 

12

The program that calls the method.

3

Debug Details- Internal table is filled with some records and let’s make it clear by executing the next SELECT statement with NULL value for each column.

4

Now the Internal table is cleared.

5


 

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