1 Reply Latest reply: Feb 20, 2016 4:15 AM by Petter Skjolden RSS

    Use variable to pull external sql script

    Brandon Golden

      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';


      LOAD *;




      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.