Extracting data from a table using STORE

[cliff_clayman]

I would like to be able to extract the data from a table into a CSV file using the STORE command in the script.  However, I'm not sure what the name of the table is.  How can I find out the table name?

[martinpohl]

for store you can use

store tablename into filename.csv

(txt, codepage is 1252, embedded labels, delimiter is ';', msq);

the tablename you can find in the table viewer (ctrl + t) after reload the script

from files it is the filename, from excel-sheets the sheetname with prefix $, from data bases the table name maybe with prefix of database content (msd.country)

you can also give your own table name in the script with the table label and a ":" before your load or select statement

data:

load.....

or

data:

sql select * from.....

Regards

[Chanty4u]

chk dis

ctrl+T  will give u the  ur table names and filed names.

Re: Store csv into qvd

[avinashelite]

Does your CSV have the table names ??? if not then you need to define the custom table names for the same , so that you can use this while storing the tables as QVD's

Table1: //custom name

LOAD *

from CSV ;

STORE Table1 as History.qvd(QVD);// you can define you own name for the QVD