Native SQL and Open SQL

Common grounds: -

1. Keywords are case-sensitive.
2. Table and column names seem case-insensitive but SAP HANA converts them to upper case unless quoted.

Difference: -

1. Columns list are comma-separated
2. Table and column name qualifiers are separated using “.”
3. No FOR ALL ENTRIES IN or INTO CORRESPONDING FIELDS OF as they are only known to ABAP and open SQL.

Native SQL statement Testing in the SAP HANA Studio

As there is no syntax check for native SQL statements in ABAP, it can be very difficult to ensure the syntax is correct. A convenient solution can be to use the SQL Console view of the SAP HANA studio.

Here you can enter the SQL statement and execute them. If the statement is not correct, error message is displayed that can be used to locate and correct the error.