Hello, I am trying to execute a pre-defined SQL script which looks something like this:
DEFINE CODE_PATH =C:\XYZ
DEFINE DATA_PATH =C:\XYZ\Final_Extracts
@"&&CODE_PATH\ALL_PARAM.sql"
DEFINE FRAMEWORK = HFV
@"&&CODE_PATH\ALL_HFV.sql"
In above code - ALL_PARAM.sql just contains the date parameters
and ALL_VFH.sql is another script which enables the scripts that are needed to be run... Is there anyway I could run the scripts in Alteryx as I can it in SQL developer.
Any help would be much appreciated.
@HKR_4410
I dont know much detail but maybe you can dig something with Run Command Tool?