SAP HANA – SQL Data Import Export Statements

CREATE

IMPORT SCAN:

  • The IMPORT SCAN statement searches the given path for objects exported using EXPORT statement and stores its result in the following session-local temporary table

The temporary table is #IMPORT_RESULTS and below is it’s structure.

4

Syntax: IMPORT SCAN <path>

Examples:

  1. Scan the path ‘/data/import_path’ using IMPORT_SCAN function

Ans: IMPORT SCAN ‘/data/import_path’

  1. Run select statement on #IMPORT_SCAN_RESULT to see the results of the scan.

Ans: SELECT * FROM #IMPORT_SCAN_RESULT

With this we have seen different SQL statements available in SAP HANA under data import export statements category along with their syntax and examples.

Thank you for reading and hope this information is helpful. Please do share with your friends if you feel the information is useful.

Happy Learning.

The reference was taken from below link (for more details check the link): 

https://help.sap.com/saphelp_hanaplatform/helpdata/en/20/ff532c751910148657c32fe3431a9f/content.htm?frameset=/en/2e/1ef8b4f4554739959886e55d4c127b/frameset.htm&current_toc=/en/2e/1ef8b4f4554739959886e55d4c127b/plain.htm&node_id=4&show_children=false

 

Check Also

Capture

SAP HANA – SQL Session Management Statements

Hello Everyone, In this article, we are going to look at different SQL Session Management …

Leave a Reply

Your email address will not be published. Required fields are marked *

12 + five =