Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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