How to store downloaded ODBC data

[#1]

Hi to all,

I 'm connecting to an ODBC server to download data, I would like to know if there is a way to save the downloaded data in a local file in order to modify fields name without re-connecting to the server every time I modify something in the script.

Thanks

Francesco

[Miguel_Angel_Baeyens · Accepted solution]

Hi Francesco,

That's what QVD are for, among many other things. Take a look at the following script:

SET vQVDPath = 'C:\TempFiles\';
 
ODBC CONNECT64 TO [DSNNameHere];
 
Table:
LOAD *;
SQL SELECT *
FROM Customers;
STORE Table INTO $(vQVDPath)Customers.qvd (qvd); // this will allow you to load from this file later on
 

Hope that helps.

Miguel