Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Dynamic Sql trigger Issues

Hi Experts

I'm creating a HANA application which is dynamic in nature every time I import data I need to run the following sql commands.Is there a way in which I can trigger these?

SET SCHEMA "SFP";

DROP FULLTEXT INDEX "COMPANY_FTI";

CREATE FullText INDEX "COMPANY_FTI" ON "sfp.crunchbase.data::company" ("overview")

CONFIGURATION 'EXTRACTION_CORE_VOICEOFCUSTOMER'

ASYNC FLUSH EVERY 1 MINUTES LANGUAGE DETECTION ('EN')

TEXT ANALYSIS ON

FUZZY SEARCH INDEX ON;

ALTER FULLTEXT INDEX "COMPANY_FTI" FLUSH QUEUE; 

Regards

Shashank K

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question