SAP HANA – SQL Data Import Export Statements
- 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.
Syntax: IMPORT SCAN <path>
- Scan the path ‘/data/import_path’ using IMPORT_SCAN function
Ans: IMPORT SCAN ‘/data/import_path’
- 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.
The reference was taken from below link (for more details check the link):