Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI All,
I have written a logic to fetch the data based on variable value either full or Incremental load but i am facing some error
Already i have mentioned the DB Connection in top
and i have taken DB Name and table names are in variable.
all the tables will be called based on the SUB routines
Please find below script and the error also and give any one good logic
let varInitLoad=1;
//=======================Sub function to Store QVDs===========================================================//
Sub StoreAndDrop(varTableName,varCreateDate,varInitLoad)
let varReload=$(varInitLoad);
if varReload=1 then
$(varTableName):
Load *
FROM "$(varDBName)"."$(varTableName)" order by $(varCreateDate);
Let varMaxDate= Peek('$(varCreateDate)',-1,'$(varTableName)');
Store [$(varTableName)] into [$(varRawQVDPath)\$(varTableName).qvd];
Drop Table [$(varTableName)];
Endif
End Sub
Call StoreAndDrop('TRIAL_INFO','CREATED_AT','1');
Error: The following error occurred:
No qualified path for file: ***
The error occurred here:
TRIAL_INFO: Load * FROM "DIT_FIRST_USER_R3"."TRIAL_INFO" order by CREATED_AT
Try Loading the data by selecting the table post test connection without the variables, that might help you figure out where the issue is
Hi Anushree1
Thanks for your reply..!
Yes, If i am loading after load connection it is working.
But here i am trying to load all the required tables from DB By mentioning the table Name, Below DB path name name table name.
like
SUB StoreAndDrop(varTableName)
$(varTableName):
Load *.
from $(varDBName).$(varTableName);
End Sub
Call StoreAndDrop(TableName1);
Call StoreAndDrop(TableName1);
.
.
.
So, Here i am facing issue from and varDBName
so here how can i mention the path names.