table not found error on store as qvd.

[#1]

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?

[#2]

the same loads when I do it with the select command though.

[anbu1984]

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

[saumyashah90]

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

[#5]

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)

[amit_saini · Accepted solution]

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

[saumyashah90]

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

[anbu1984]

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;

[#9]

Thanks Amit and others.

[amit_saini]

Cheers!