Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
What's the correct syntax for storing qvd's?
The folder i've created on the right in Data Editor is called QVD_FOLDER the actual folder on the server is called QVD, what am i doing wrong in the store syntax.
Thanks Guys
LIB CONNECT TO 'XXX.HOST.NAME.com (user_e111)';
SEGMENTS:
load *;
sql select *
FROM Warehouse.dbo."SEGMENT";
STORE SEGMENTS INTO [lib://QVD_FOLDER/SEGMENT.qvd](qvd); // with folder created in Data Editor name QVD_FOLDER
or
STORE SEGMENTS INTO [lib://QVD/SEGMENT.qvd](qvd); // with server folder name QVD
STORE SEGMENTS INTO [lib://QVD_FOLDER/SEGMENT.qvd](qvd); // with folder created in Data Editor name QVD_FOLDER
seems correct. you can try putting the connection string in ''.
i.e. 'lib://QVD_FOLDER/SEGMENT.qvd' (qvd)
Where will the connection string go?
do you want to store connection string as well in QVD ??
No just the table/data.
then try what Guohao suggested...
Is it not working?
Try putting the connection string - you mean the connection string for the QVD_FOLDER? where do i put the connection string?
Hi Lak,
The second one's right. You need to give the name of the connection you created.
Is this you are asking?
in the script..
Step1)
Connection string on the top..............like connect to(Connection String Paramneter after connection)
Step2) Fetch the table
Tres:
load * from Databasename.Tablename;
Step 3) create a QVD
store Tres INTO [lib://QVD_FOLDER/SEGMENT.qvd](qvd);
Step4) Drop the table
drop table Tres;
Step 1 - Connection string for the server or connection string for the folder