Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Ok people, what am I doing wrong here?
LET vQVD_dir='..\QVD\debug\';
DIM_BUSINESS_LINE:
SQL
SELECT * FROM DIM_BUSINESS_LINE;
STORE DIM_BUSINESS_LINE INTO $(vQVD_dir)DIM_BUSINESS_LINE.QVD (QVD);
DROP TABLE DIM_BUSINESS_LINE;
Script blows up at STORE command.
My extractor is in the folder QV\EXTRACTORS
MY QVD folder is at QV\QVD
and I am trying to use a debug subdir QV\QVD\debug
What am I doing wrong? I've tried LET, SET, no quotes, with quotes.
Thanks,
Frustrated in NY
Does the debug folder already exist?
Does the debug folder already exist?
Yes, it does
Script seems right to me. Is it giving you any specific error?
Please post which error you are getting at STORE.
If you step into the script using the debugger, how does the expanded STORE command looks like?
Can you make it work using the hardcoded path?
Sorry folks, my bad.
I was running script on server, created debug folder locally, thought I was in local copy.
And just to double check: The user that runs the script has proper access rights to the folder and potentially already existing QVD and the potentially already existing QVD is not locked by another process?