ofrendo
3/31/2016 - 7:38 AM

SQLSCRIPT HANA Select * dynamically from table name by String

SQLSCRIPT HANA Select * dynamically from table name by String

hanaSelectDynamically.sql
content_copyfile_download
SELECT "Value" INTO datasetSchema FROM :configuration WHERE "Key"='Schema';
SELECT "Value" INTO datasetName FROM :configuration WHERE "Key"='Name';
	
-- then select this data
datasetFull := '"' || :datasetSchema || '"."' || :datasetName || '"';
	
EXEC 'CREATE LOCAL TEMPORARY TABLE #data LIKE ' || datasetFull;
EXEC 'INSERT INTO #data SELECT * FROM ' || datasetFull;