Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am having trouble including a variable as the name of the file I'd like to load for which includes sql code for creating my QVD's
This code is working:
LET T = 'DM_CASE';
$(T):
LOAD *;
SQL
$(Include=lib://Epic_Scripts_Temp/converted/DM_CASE.sql);
However what I want to do is include $(T) in the reference function to call the text script file. I have over 900 scripts to bring in so I really want to minimize the number of times I have to state each table name. Changing the name to $(T) in the file name doesn't seem to work.
You are right - with a lib: Sense will not accept a $-sign expansion.
There is however a workaround for this:
LET T = 'DM_CASE';
LET vInclude = 'Include=lib://Epic_Scripts_Temp/converted/$(T).sql';
$($(vInclude));
This doesn't seem to be working, was there ever a resolution?