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.
