Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I get an error table not found when I try to load table from the database and save as qvd format with store command. The table exists in the db though . This is the first time I am trying to store in qvd format . I just followed the same steps as in the help section. Can anyone help me?
Sai,
It should be like below:
Table_Name:
SQL SELECT *
FROM CAQADMIN.STICHPROBE;
store Table_name into D:\Asaini\Test\Table_Name.qvd;
Thanks,
AS
the same loads when I do it with the select command though.
Can you post the script?
Did you define table name as below before you store into QVD?
TableNm:
Sql Select * from table;
Store TableNm into Qvd(qvd);
if loading from flat files:
Table1:
Load * from XYZ(Path/table);
Store Table1 into Path/Table1.qvd(QVD);
And similarly if you are loading from database
Table2:
Sql Select * from Table;
Store Table2 into Path/Table2.qvd(QVD);
//Path= path of the file where you want to store or load it from
STORE tetower into ttower.qvd;
(this is the store command I used to store the table in qvd format)
//SQL SELECT *
//FROM "TEF_UAT_NEW".dbo.tetower
(the same table that loads without store command)
Sai,
It should be like below:
Table_Name:
SQL SELECT *
FROM CAQADMIN.STICHPROBE;
store Table_name into D:\Asaini\Test\Table_Name.qvd;
Thanks,
AS
Whenever you load put a Name of the table.
i.e
Table1:
SQL SELECT *
FROM "TEF_UAT_NEW".dbo.tetower ;
//Store Command
Store Table1 into Table1.qvd(QVD);
You cannot use sql table name directly in store statement. Table name has to be mentioned before your Select like below and use the same in Store statement
tetower:
SQL SELECT *
FROM "TEF_UAT_NEW".dbo.tetower;
STORE tetower into ttower.qvd;
Thanks Amit and others.
Cheers!