I have a set of sql script files which are being called in a main file. The path to the directory where the files are located is defined in a variable in the main file.
This substitution variable is then used to reference the files. The define character is also set to ` instead of ampersand (&)
When i execute the main file, it in turn calls the other script files and executes them. But only some of them are executed and for others getting the error as SP2-0310: unable to open file "``home_path/Application/Dbobjects/Scripts/adm_group_permissions.dat"
home_path is the substiution variable.
Main file looks like this
set define `
All the files are in the same directory. Files upto adm_menus.dat are executed. From then on there is error.
If I place the adm_group_permissions.dat as the first file to be called, it works.
Any idea what is going wrong here?
Thanks in advance.